Set Warning won't turn back on

[Brenda from Michigan]

User has Access 2002 SP3

She uses Set Warning in various places in her macro. She has turned off Set
Warning during database design and now wants it back on. She has set it to
yes, but the function to create a new table just runs and does not give the
warning.

For now we are restoring the file from a backup but are curious as to why
the Set Warning does not come back on. I do not do macros, so if you need
some code, let me know and I'll get it from the user. Thank you!

 

[Steve Schapel]

Brenda,

There is a way of turning off warnings universally. This is via the
Tools=>Options menu, and then the Confirm Action Queries option under the
Edit/Find tab. I would not generally recommend doing this. Maybe this is
what your user has done. I suggest making sure this option is checked, and
then put a SetWarnings/No action in the macros in those cases where they do
not want to see the confirmation messages.

 

[Brenda from Michigan]

This was exactly the problem and the fix. Thank you for making ME look good!
Brenda