Search results

Thanks for your reply Pat. I already tried using the AddNew method and that didn't work either. I actually now done a 'work around' - I've added an extra field called timestamp set as Now() and I've used that with another field to search for the record just added - from that I can then find...

No DMax doesn't work because the Autonumber is set as ReplicationID (which gives you a GUID)

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've not come across Decompile before. How do you do this?

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?

Thanks for the article re reserved words. This database was originally developed in 1997 using Access 97 - obviously before Module was a reserve word. Thanks Again for you help

Fantastic Wayne - thanks for sorting that out. Only problem is - this is just an extra form to be added on to an existing database and I have been using the field "Module" for ages - not to worry that is something that I know that I can fix. Once again - thank you very much.

Thanks for helping. I have definately not got any code on the main form or subform. I have attached the zipped database - if you open the form MarkingGrid and then try typing any letter into the Tutor box you will see the error message. Ideally the tutor box should be a combo box but I...

No - there is no code at all in either the Main form or sub form. In fact I have just created a new test db to try to fix this - I have imported the relevant tables and recreated the forms from scratch. Am now getting the error "You can't refer to a form or report module from form view or...

You can stop the new record appearing at the bottom of a form by setting the forms property AllowAdditions to No

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 know its confusing - but the query name is actually "OrderForm"! However - I seem to have solved my problem. I have changed the order of the fields in the query so that the first field is a text field rather than a autonumber field - the error message has now gone away.

To use a parameter query you need to put a brief request in square brackets [ ] as the criteria in your query eg instead of typing a town as criteria London type [Enter town] and when you run your query you will be asked to enter a town. To make this even better you could put Like "*" &...

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

Thanks for your comments. Going back to unicode. How do you make a database unicode enabled?

So - the back end of this database is in Access 2000. The front end is being used by both Access 2000 and Access 2002. But I am only using regular English text! and don't think I need unicode enabled (well not as far as I can tell) unless that is the cause of the problem. Do you know - if I...