Search results

Have now changed the form to TestForm and changed the SQL in the combo box to refer to [forms]![TestFrom]![RetailerCode] Sadly - I still get the Enter parameter value question "Forms!TestForm!RetailerCode" when clicking on close. I can't think what else to try!!

No - it's really called VPAFieldReport

Thanks for that - but I've already tried this - (see above) - I called the box [RetailerDisplay] and then I get a different message then [forms]![MyForm]![RetailerDisplay]

I've checked the references - they're exactly the same. Any other ideas?

Yes I need all the columns to help select the correct entries. And yes ReviewerCode is the name of the combo box on the form. I tried changing the name of the combo box to RetailerDisplay but then I got a different parameter value request for [forms]![MyForm]![RetailerDisplay]

Here is the first called RetailerCode on the form VPAFieldReport: SELECT [Retailers].[RetailerCode], [Retailers].[RetailerName], [Retailers].[RetailerStreet1], [Retailers].[RetailerStreet2], [Retailers].[RetailerTown] FROM Retailers; and here is the second SELECT [VPAs].[RetailerCode]...

I have a form with two connected combo boxes - the first allows selection of a Retailer and the second allows selection of a staff member from the selected Retailer using the criteria [forms]![MyForm]![Retailer] to limit - This all works quite correctly. The problem is this - when I run this...

I am using Access 2000 and need to tell the user when another user has already selected and is viewing a particular record - I have this working successfully. I have set Default record locking to Edited Record and Open databases using Record-level locking on - on the Advanced tab of the Options...

Here is a database which uses the SendObject to email to the the current contact on the form 'Telephone_calls' - the code used on the [send email] button is as follows: Private Sub btnSendEmail_Click() Dim Linefeed, Content Linefeed = Chr$(10) & Chr$(13) Content = "Date: " & Me.Date & " "...

I need to produce a report which varies in number of pages and I need to put some text and a space for a signature at the bottom of the last page. The report footer appears after the last part of the report - how do you force this to the bottom of the page? Thanks

I have Access 2000 database which is giving this error when users try to make changes "Disk i/o error: could not read disk" Does any one have any ideas for me? Valerie

Many thanks for your help

Thanks for the reference to the MS Article - although it refers to Access 2002 and I am using Access 2000. The article implies that the data should be moved to SQL Server for database being constantly used, which this one is. Do you know how to check about network collisions? Do you know...

do you mean ldb files which don't belong to the currently opened database?

I have an Access 2000 database with upto 6 users. (split into Front end and Back end) Whenever a user logs into the database he sees the message "You or another user may have unexpectedly quit MS Access while the MS Access database was open. Do you want access to attempt to repair." The...

I have now created a new data file and imported all the tables and reset all the relationships. The system has just crashed again! (after about 1 hour of use) Have you any other suggestions? Please??? Valerie

I have compacted and repaired on numerous occasions!! I will try creating a new file and then importing all the tables. Thanks for the suggestion

Thanks for your reply. I have checked out the article and it implies that maybe I have not got the correct references. I have checked my references and see that I have the following references: 1) Visual Basic for Applications 2) Microsoft Access 9.0 Object Library 3) OLE Automation 4)...

I have an Access 2000 database with upto 6 users. (split into Front end and Back end) Whenever a user logs into the database he sees a message like "unrecognised database format" and the other users' data is not saved. This problem has started quite recently and until then there were no...

I have an Accesss 2000 system being used by 6 users. Upto 8 days a day the system crashes. Often when a user logs in the message "unrecognised database format - file needs to be repaired" is seen. The effect - the primary keys are lost, the relationships are lost and records appear with null...