export no warning on overwrite

[Guest]

I have notice the last few days when I export a form or report I have changed
to another mdb that ALREADY HAS THE SAME FILE, I am not getting the "you are
about to overwrite" warning. I have always gotten it in the past and it seems
like since patch Tuesday it stopped. Anyone else noticed this?

Or is it just me?
Thanks

 

[Guest]

Hi Imv,

It appears as if you may have Set Warnings to False, perhaps
unintentionally. Close all open objects (forms, reports, etc.). Open the
Immediate Window (Ctrl G) and issue the following command:

docmd.SetWarnings true

Then try your export operation without opening any forms or reports. Is the
warning now restored? If so, you may have a SetWarnings statement somewhere
(macro, VBA code, etc.) that is setting warnings false, but never resetting
the warnings back to true.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

THANKS TOM!

Have no idea how it happened but I guess it doesn't matter it's fixed now.
Should I search through the db and see if there is a place that doesn't have
docmd.SetWarnings true following a docmd.SetWarnings false?

Thanks

 

[Pieter Wijnen]

you should
especially where setwarnings true isn't executed due to error handlers

Pieter

 

[smart]

"Pieter Wijnen"

you should
especially where setwarnings true isn't executed due to error handlers

Pieter

 

[Guest]

I agree with Pieter's reply. In fact, my preference is to avoid using Set
Warnings at all. I prefer using the .execute method of the DoCmd Object. Here
is a Word document that you are welcome to take a look at (see example 4 for
using DoCmd.Execute):

http://home.comcast.net/~tutorme2/samples/ActionQueryExamplesWithSetWarnings.doc


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

OK, I will read it and go back through and check / and change things.
Thanks for the additional training!