Software

General discussion

Gravatar
Locked

Prompt a message before save records in Access

By Hunterzh ·
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.

4 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

by dryflies In reply to Prompt a message before s ...

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)

gravatar
Collapse -

by wvonboecklin In reply to Prompt a message before s ...

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

gravatar
Collapse -

by Karpi In reply to Prompt a message before s ...

Hello,

use the forms "before update" event

Select case Msgbox ("Save?",vbyesno)
case vbyes
case vbno
cancel=true
end select


HTH
Karpi
<fluctuat nec mergitur>

gravatar
Collapse -

by Hunterzh In reply to Prompt a message before s ...

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Start or search

Related Discussions

Related Forums