export no warning on overwrite

L

lmv

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
 
T

Tom Wickerath

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
__________________________________________
 
L

lmv

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
 
P

Pieter Wijnen

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

Pieter
 
T

Tom Wickerath

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
__________________________________________
 
L

lmv

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