Auto Save Everything in Access

A

AccessHelp

Hello all,

For some reason, my Access database database does not prompt me any messages
when I run my Append or Update query.

Has anyone had this kind of experience? How can I make it to prompt me again?

Thanks.
 
J

Jeff Boyce

It sounds like the SetWarnings has been turned off.

You can create a small, simple macro in which you turn the SetWarnings to
ON.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
C

Cheese_whiz

Hi AH,

In 2003 (at least), you can go to Tools>Options>Edit/Find and look under
'confirm' and there is a place for 'action queries'. Check that to confirm
before running action queries.

Hope that helps,
CW
 
A

AccessHelp

Hi Cheese_whiz,

Thanks for the response. I checked the Confirm section of Edit/Find, and
"Record Changes", "Document Deletions" and "Action Queries" boxes are
checked. Is there anywhere in Access to turn it back on? Now, even when I
close the forms, it does not prompt me to save them.

Thanks.
 
A

AccessHelp

Hi Jeff,

Thanks for your response. I do have the SetWarnings turns off in my macros.
However, I don't think it should affect when I run the query directly. In
addition, Access does not prompt me to save the forms when I close them.

Thanks.
 
J

Jeff Boyce

I've noticed that when I turn the warnings off, they're off. Why do you
think that turning them off "in your macros" wouldn't turn them off
everywhere?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
L

Larry Daugherty

The "prudential rule of housekeeping" applies: "If you change the
setting of a global attribute within a procedure for use just within
that procedure then change it back to the prior state before leaving
that procedure". It isn't always clear when something is global.
Assume everything is global unless you know different.

In every procedure in which you Set Warnings Off, be sure to Set
Warnings On before leaving the procedure. That will leave the Options
you selected in force all the rest of the time.

Your Set Warnings On should be in the code after the MyProcedure_Exit:
label. Make sure that every exit from the procedure is via that
label, Even your Error path should exit via the MyProcedure_Exit:
label.

HTH
 
B

Brent Spaudling \(datAdrenaline\)

The SetWarnings setting does not "reset" when your macro finishes, the last
setting applied stays in effect until you toggle it again. The setting is a
Access level setting, and it is not the same as the "Confirmation" options.
 
Top