Better way of closing my database?

[comptechbranden]

Current Situation:
Right now when I close a form it will save the data and close.

Problem:
When somone goes in and messes up on something and they just want to exit without saving they cant do that. The data could have been changed and one may not remember what it was!

Solution Ideas:
I am thinking that a pop up window that says "Save Changes?" Yes/No then have it save or not. Could somone give me the details on how to do this or anything else that would solve this issue. Thanks.

 

[WayneRyan]

Branden,

Quite a topic.

First, Access generally "takes care of you" and automatically saves the changes
you make to your data. This is normally a good thing, as it relieves YOU of
the tedium of writing code for "save" buttons and such.

If your users tend to change data without meaning to, or decide later that they
need to undo changes, but have forgotten what they changed, that can lead to
problems.

Rather than trying to develop the application with unbound forms (which is a
lot of work), you might try using the Search Facility here and look for
"Audit Trail". GHudson has posted some applications that might interest you.
At least you'll know what has been changed. That should give you and your
users a starting point.

hth,
Wayne

 

[MarkK]

You may also be able to make use of the CommitOnNavigation and CommitOnClose properties of a form.

 

[comptechbranden]

So If I had this code that I located, where would your code go in there Pat?

Private Sub Close_Click()
On Error GoTo Err_Close_Click


DoCmd.Close

Exit_Close_Click:
Exit Sub

Err_Close_Click:
MsgBox Err.Description
Resume Exit_Close_Click

End Sub

 

[ghudson]

Check these links out for some working examples that will assist your project.

A Better Mouse Trap?

Enable/Disable The Control Box X Button

Audit Trail

HTH