Bug In Access 2000?

[SHPsalm139]

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

[Rick Brandt]

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

[SHPsalm139]

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

[Rick Brandt]

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

[SHPsalm139]

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.