In Access 2000 or 2003, normally records are automatically saved after editing. I?ve just developed a database application using MS Access + SQL Server 2000. Colleagues say that they hope to have prompt message before saving records, so as to avoid mistaken modifications. How can I realize this in MS Access?
This conversation is currently closed to new comments.
Do you have warnings turned on? If you have warnings turned on Access will automatically prompt you before adding deleting or modifying records (if you are working from table view it may not prompt for an added or modified record)
Insert the following prior to moving to another record or closing the form: Beep If MsgBox("Do you want to save your changes?",vbYesNo,"Save Record") = vbYes then ... INSERT/UPDATE SQL Server table ELSE ... DO NOT SAVE CHANGES/RECORD End If
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Prompt a message before save records in Access
How can I realize this in MS Access?