Search results

I need to get the Autonumber (GUID) of the last record just entered into the table called Farmers. This is the code that I am using, but every time instead of getting the last AutoNo I keep getting 0. The Farmers table is a linked table in a separate Access database. I am working in Access 2000...

I am developing a system using Access 2000. Occasionally when I click on the save button in a form or a report, Access unexpectedly quits without any messages and without saving the current work. Any suggestions from any one would be welcome.

I am developing a system using Access 2000. Occasionally when I click on the save button in a form or a report, Access unexpectedly quits without any messages and without saving the current work. Any suggestions from any one would be welcome.

When I open a record using a form, I would like to find out if any one else already has that record open. And then to say who the other user is. Is there any way of doing this? Thanks

Is there any way that I can tell a user who has currently got a selected record locked?

I've created a Main form and subform, and everytime I try to enter anything in the subform (in any field) I get the message "property is read-only and can't be set". Clicking OK to the message clears it and I can then continue to enter the data successfully into the rest of the record. I have...

I am working with Office XP and have exported a query to Excel using the command DoCmd.OutputTo acOutputQuery, "OrderForm", acFormatXLS, "C:\AMLocal\OrderForm.xls" This correctly creates the excel file, but when I open the file I see the message "File Error. Some number formats may have been...

I have a combo box which is used to find a record on the form. I have set LimitToList = Yes and put in code for the event NotInList. My problem is that my code is working fine allowing me to produce my own message, but then the standard message appears as well saying "The text you entered is...

I have a database used by about 15 users. Occasionally a record appears which contains strange characters in it rather then regular text and numbers. The solution is to compact and repair the database but this means taking all users off the database. But I need to find out how these...

I need to be able to change the margins of a report from VBA based on values selected by the user from a form. PprtDevMode allows you to change orientation etc but not the margins. Any help would be appreciated

I am attempting to put a reminder in my Outlook calendar from a button on a form. Below is the code I am using, but I am getting "compile error: Method or Data member not found" on the CreateItem. Dim objOutlook As Application Dim objAppt As Object Set objOutlook =...

When I update a field on my subform, I use the AfterUpdate event to calculate a new value of a bound field on the Main form. I have to enter the new value on the subform TWICE, before I see the new calculated value on the main form. Any ideas? Thanks in advance.

I have a database which works well on local PC's. This has now been copied onto a PC in France with french installation of Access. The following error message occurs "Le parametre entre n'est pas cette propriete" (The entry parameter is not valid for this property) It has been tried on...

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...

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

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 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...