Having Trouble with Multiple Users Changing Information

[Quintios]

I am working by myself in this database I've created. On a lot of the forms I have a doubleclick event created such that another form will open based on the previous form that will either display more information about that particular record or just display it in an easier to read format. When I make changes in the second form and 'close and save' the record and get back to the first form, a lot of times I'll get an error where Access asks me whether or not I want to drop the changes or save the changes to the clipboard because another user has modified the record.

I'm definitely the only one in the database (no network connection). Can anyone offer me some advice on how to, when performing the above described action, avoid these types of errors?

Thanks in advance,
Onwards,

Q-

 

[Quintios]

To further clarify, this happens when I have more information for a record than is displayed on a form. I change information on the form so the record is being edited, I then click a button that brings up a memo field that is part of the current record. I type what I need in the memo and click the 'close and save' button on second form that popped up.

Then, when I try to 'close and save' the first form I get the error.

How can I save the current record when I click the button to pop up the second form?
Onwards,

Q-

 

[petrosky]

Hi Quintios,

On your doubleclick event on the first form you could try entering this before your existing code.


docmd.save


If this doesn't work let me know.
If you have already tried this, please ignore.


Peter Remember- It's nice to be important,
but it's important to be nice

 

[Quintios]

I put the command in the click event for the button that pops up the second form.

Didn't work, but thanks for the suggestion.

But hey, I tried some of the other options that pop up when you type DoCmd. in the VBA window, and it seems that 'ReQuery' does the trick. When the second window pops up I can see the pencil icon is gone from the previous form and the black triangle is back, indicating the record has been saved.

I wonder what other methods (?) on the DoCmd object would perform the same thing.

Thanks!
Onwards,

Q-

 

[petrosky]

Hi Q,

I am still learning em myself.

Hope you find the answers.

Pete.

This is another good one i use from time to time to refresh data on forms.

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

Actually got this from the wizard created refresh button.

Remember- It's nice to be important,
but it's important to be nice

 

[jonchaz]

I am not sure if this will help you, but I used to get this message all the time. I researched it on here and found a post that said to look at any bit fields in my tables. If you have any bit fields, make sure that the value in them is set to -1 or 0, otherwise Access will not allow you to save the record, even if you are not doing anything in this field. I went back and set all my bit fields to a non null value, and I haven't seen this message since. I hope this helps.

 

[Quintios]

Thanks jonchaz, I'll keep that in mind in the future!
Onwards,

Q-