Search results

Keith Now I get runtime error "424" object required

Error message Unfortunately the error message was happening on a a works PC and the same error does not occur on my own laptop. The when the error occured and I debugged the following line was causing the problem NumManagers = rstcount![NUMMANtstchk] When i display this line the following...

I was advised the other night a create reports function that I could not get working required a Do While Loop. I found the code for a Do While Loop and have amended my code accordingly but I am still getting errors is there and error in this loop Private Sub Create_Reports() Dim rstcount As...

Database Keith Thanks for you advice last night have only just got chance to attach database now. The all the functions in the module work correctly except the Create Reports function. Any pointers you can give me would be much appreaciated. Thanks Kevin

Database KeithG I have never put a database onto this forum, so I was wondering what do I have to do. I have noticed that a lot of the database already on this site are in a zip format, do they have to be zipped as I don't have a zip programme on my laptop, if it needs to be zipped I will put...

Do Until Loop Keith thanks for your advice, I have only just recently started to code using VBA so have never done A Do Until Loop have you got any pointers as to what you mean and how to implement it. Thanks KevW

I am having problems getting the function to work correctly. What it should do is create reports for every manager who has staff members in the tbl_Testcheck. It should then open outlook and allow the user to email the report as an attachment, then it should move on to the next manager who has...

Hi Rod Thanks for your input, I have checked the file and some of the first 25 have over 255 characters, (there is one row that actually has 313 characters). The table is populated using VBA code to import the table. I have also checked the alignment of the text in the spreadsheet and that is...

The table is populated from an Excel 2000 spreadsheet that is imported into the database using VBA code. So all the field data is from this spreadsheet. Not so sure as to what you mean about checking the expression but any pointers further ideas would be helpful. I checked Tools > References...

I have a table that i need to be able to store text that may be over 255 characters long. I have changed the fields datatype setting to memo as I thought this was able to show Up to 65,535 characters. But the data is still being trimmed to 255 characters. I have looked in Access help at data...

Thanks for that does exactly what I wanted. Would that also work on the date so that leading zeros are displayed

I am trying to get the folliwing DatePart query to work as I intended. testcheck_time: DatePart("h",[EDS_testchecks]![Query_Start_Date]) & ":" & DatePart("n",[EDS_testchecks]![Query_Start_Date]) & ":" & DatePart("s",[EDS_testchecks]![Query_Start_Date]) The above works well but what it is...

Was the type of spreadsheet, should have been Excel 2000. Also had an extra comma at the end of the statement. Thanks for your help now works as it should do.

I am trying to import and Excel 2000 workbook into an Access database using the following code: Private Sub Import_EDS_testchecks () DoCmd.TransferSpreadsheet acImport,9,"EDS_testchecks","C:\Documents and Settings\Kevin\My Documents\testchecks_030406.xls",True, End Sub When I try to run the...

I am trying to disable the next button on a form called frmCompany In the forms Current event procedure I am putting the following code. Private Sub Form_Current() ' If this form is on a new record, The Next button button should be disabled 'to do this to shift the focus first. If there is '...

New table design Hopefully this is what the tables should look like to remove the problems, do you think that this will now work SALEITEM *SaleItemID SaleID # RegNo SALE * SaleID # SaleItemID # StaffID # CustomerID Date Sale Price STOCK * RegNO # SupplierID Make Model...

So I am right in thinking that the Sale table should link to the new SaleItem table, then the Sale item table should limk to the Stock table. IF this is the case which table would the SaleItemID PK be the foreign key and what would then be the link on the stock table.

Thanks for your advice again, I can get the relationship between the Sale table to the Stock table to be 1:M, the only problem is you cannot enter a new item off stock because a related item is required in stock. Which is not always the case as new stock bought from a suplier will not be sold...

I have checked the data types and played about with the table design and the relationship now shows as 1:M. The problem that I have now is that the SaleID does not show in the Stock table.

Can anyone help me solve the problem that I have with the following tables. SUPPLIER * SupplierID Name Address Email SALE *SaleID # RegNo # StaffID # CustomerID Date Sale Price STAFF * StaffID Name Address TelNo CUSTOMER * CustomerID Name Address TelNo Email...