471,873 Members | 2,036 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,873 software developers and data experts.

Avoiding Form Autosave & Microsoft Error on Closing


I'm looking for help when it comes to how to stop a form from autosaving when it is closed and instead use a "save" and and an "exit" button. I've looked online and found tons of code that is supposed to help with this, but I am so code-illiterate that I have no idea what I need to modify in the code to apply it to my specific form.

I need a save button that saves, an exit button that exits without saving any changes, and I'd like to avoid the "You can't save this record at this time. Microsoft Access may have encountered an error while trying to save a record" message that comes up when trying to close with the X button.

I know that it'll be the BeforeUpdate event that needs coded but everything I've tried hasn't worked - one button will work and the other won't or I'll get the "you can't save..." message.

I'm so frustrated!!!

Any help would be greatly appreciated!!!
Dec 7 '16 #1
0 665

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Renzska | last post: by
1 post views Thread by thomasp | last post: by
2 posts views Thread by Fionnbarr Kennedy | last post: by
2 posts views Thread by Dave | last post: by
3 posts views Thread by Zürcher See | last post: by
reply views Thread by John Swan | last post: by
2 posts views Thread by rdemyan via AccessMonster.com | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.