Disable ask to save changes to form

[Djblois]

My users sometimes when exiting the access program get a pop-up asking them if they want to save the changes to the form/forms? Is there a way to disable this pop-up? I just want it to exit.

 

[DCrake]

DoCmd.SetWarnings False/True will do the trick.

 

[MSAccessRookie]

My users sometimes when exiting the access program get a pop-up asking them if they want to save the changes to the form/forms? Is there a way to disable this pop-up? I just want it to exit.

DoCmd.SetWarnings False/True will certainly do the trick, but it does not address the question of why your users are getting the message in the first place. Under normal curcumstances, users should not have the right or ability to modify Forms, since any modifications might affect how the Forms will run in the future. A user might encounter messages like this with a Table, since they might want to change the width of the Columns that are being displayed. Even so, they probably should not have direct access to the Tables, so they should not see such messages.

 

[Djblois]

Thank you both. three questions

1) What other warnings will that command prevent?

2) If I turn them off when I first log on will that suffice? or do I need to do it for each form?

3) Will they automatically turn on the next time they open Access?

Honestly, I do not know why they get it. I think it has something to do with my code changes certain label captions. This in turn would require a save.

 

[Djblois]

or is it possible to turn off the ability to edit the forms?

 

[MSAccessRookie]

Thank you both. three questions

1) What other warnings will that command prevent?

2) If I turn them off when I first log on will that suffice? or do I need to do it for each form?

3) Will they automatically turn on the next time they open Access?

Honestly, I do not know why they get it. I think it has something to do with my code changes certain label captions. This in turn would require a save.

1. The Code will prevent display of ALL Error and Warning Messages.
2. Any time that you turn them OFF (in the Startup Form or otherwise), they stay OFF intil they are turned back on.
3. I have had experience when MACROS using the compatible command, would cause Access to not have messages (even if one program stopped and a new one was started, until the effect was reversed. I believe the same might be true for VB Code. As a result, ALL MACROS and VB Code that turn Warnings OFF should turn them back ON when they have completed.

 

[Djblois]

or is it possible to turn off the ability to edit the forms? or another way to fix this? Because I do not want to turn off all error messages.