By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,262 Members | 2,664 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,262 IT Pros & Developers. It's quick & easy.

Bug In Access 2000?

P: n/a
If I make a change to a query in Access 2000 and click on the X in the
upper right corner to close the query, I get the prompt "Do you want to
save changes to the design on query 'Query1'? Normal behavior so far.
Now if I create a macro that turns off warnings (SetWarnings: No) and
run it, it has no effect which I think is a bug because if I run what
should be the equivalent in VBA (DoCmd.SetWarnings False), I no longer
see the above prompt "Do you want to save...". And either a macro with
(SetWarnings: Yes) or VBA code (DoCmd.SetWarnings True) do cause the
above prompt to show up again as expected. Has anyone else seen this
behavior or can duplicate it?
Thanks, Sheldon

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
SH********@aol.com wrote:
If I make a change to a query in Access 2000 and click on the X in the
upper right corner to close the query, I get the prompt "Do you want
to save changes to the design on query 'Query1'? Normal behavior so
far. Now if I create a macro that turns off warnings (SetWarnings:
No) and run it, it has no effect which I think is a bug because if I
run what should be the equivalent in VBA (DoCmd.SetWarnings False), I
no longer see the above prompt "Do you want to save...". And either
a macro with (SetWarnings: Yes) or VBA code (DoCmd.SetWarnings True)
do cause the above prompt to show up again as expected. Has anyone
else seen this behavior or can duplicate it?
Thanks, Sheldon


Setting warnings off in a macro has always affected the setting only for the
duration that the macro runs. Probably a safety valve for newbies who would
not remember to turn it back on since they are most likely to use macros.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
So is VBA (DoCmd.SetWarnings False) the only way to turn off warning
messages outside of a macro or are there any other ways?

Nov 13 '05 #3

P: n/a
SH********@aol.com wrote:
So is VBA (DoCmd.SetWarnings False) the only way to turn off warning
messages outside of a macro or are there any other ways?


There might be other ways, but I'm not aware of them.

Do you have a problem with DoCmd.SetWarnings False?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #4

P: n/a
DoCmd.SetWarnings False works fine but we have databases that don't
have code so it would be nice to have a simple way of turning off
messages without VBA.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.