How to save before exiting

[rbeatty]

Is there a way to make the database prompt to save when exiting. I am having a problem with people making changes on accident and then exiting and thus it saves automatically.

 

[hymn]

Would'nt it be easier to lock each record when it is completed and then force users to click on a button which would then allows them to edit the record

Hope this helps
Hymn

 

[jfgambit]

Add the following to the On Click event of the exit button

If MsgBox("Would you like to save changes made to this record?",vbyesno,"SAVE CHANGES&quot = vbYes Then
DoCmd.RunCommand acCmdSaveRecord
Else
MsgBox "Changes have not been saved."
me.undo
End if

DoCmd.Close




"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"

 

[CMooreJr]

or you can easily without using code to make a macro attached to the exit button. On the macro, line 1, have "Save"...the critearia at teh bottom allows you to choose "Prompt", "Yes" or "No"



"There are two ways to write error free programs. Only the third one works."

Cmoorejr.