Recent content by Valerie

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.