Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Save dialog for any information add/change

Status
Not open for further replies.

padlock

IS-IT--Management
Mar 11, 2005
3
US
Hi everyone,

I've been put in charge of working on an access database that contains a ton of contact type information. I'm a network guy, I setup their web and email servers, etc, and this is a bit out of my field.

My issue is the client wants access to bring up a save change dialog box anytime information is changed in a form. People are being so careless and keep erasing data instead of doing a proper search (they'll type the info they want to find in the field instead of bring of a search dialog, etc.) So anytime anything is changed, they want a yes/no dialog to make sure the change was on purpose. But I can't seem to figure out how to have access do this. I know all the changes are saved as soon as they're done normally, but the client doesn't want it to work that way anymore.

Any help would be greatly appreciated! Thanks in advance for any help.
 
Review the BeforeUpdate() Code. I believe you can ask a Yes/No Question via Msgbox() then set the Cancel variable to True if they say No to Save. htwh,

Steve Medvid
"IT Consultant & Web Master"

Chester County, PA Residents
Please Show Your Support...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top