export no warning on overwrite

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
__________________________________________
 
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
 
you should
especially where setwarnings true isn't executed due to error handlers

Pieter
 
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
__________________________________________
 
OK, I will read it and go back through and check / and change things.
Thanks for the additional training!
 
Back
Top