Auto Update

[Frank]

Is there a way that I can turn the "Auto Update" function
off so records do not get changed unless the "Save Record"
button is selected? If not, how can I prompt the user for
confirmation if a record has been changed?

All I have to say is thank God for backups
Thanks

 

[Ken Snell]

No, and doing so could create major headaches with your ACCESS database when
you forget to put code in to handle all the record savings, etc.

One way to get around this is to build all your forms as either unbound
forms (no recordsources) or use temporary tables that mimic your database
set up, and then when the user clicks the button to save, you have code
(lots of code!) that does all the work that ACCESS already is designed to do
for you.

You can prompt a user to confirm a change using the form's BeforeUpdate
event:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If vbNo = MsgBox("Are you sure you want to make these changes?", _
vbQuestion + vbYesNo+vbDefaultButton2, "Confirm Changes") Then
Cancel = True
Me.Undo
End If
End Sub

 

[Frank]

Thank You very much Ken. The prompt should help quite a
bit.

-----Original Message-----
No, and doing so could create major headaches with your ACCESS database when
you forget to put code in to handle all the record savings, etc.

One way to get around this is to build all your forms as either unbound
forms (no recordsources) or use temporary tables that mimic your database
set up, and then when the user clicks the button to save, you have code
(lots of code!) that does all the work that ACCESS already is designed to do
for you.

You can prompt a user to confirm a change using the form's BeforeUpdate
event:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If vbNo = MsgBox("Are you sure you want to make these changes?", _
vbQuestion +

vbYesNo+vbDefaultButton2, "Confirm Changes") Then