Not prompted when running append/make-table queries?

[Pat Dools]

Hello,

When I am running queries from either the Database Window or from the Design
View of the query, I am not getting prompted when I am running either an
Append query or another make-table query. I would like to get prompted when
I run these queries, especially from the Database Window or Design view of
the actual query. Did some sort of warning option get inadvertently turned
off? How do I turn it back on?

Thanks!

 

[kc-mass]

Hi Pat

Fist look in "Tools\Options\Edit\Find tab and
see if the warnings are shut off there.
If not, it sounds like some code was run with:
"DoCmd.SetWarnings False"
and the corresponding:
"DoCmd.SetWarnings True"
did not get run.

Create a new Module with one line
"DoCmd.SetWarnings True"
Run that and see if you don't get it back

Regards

Kevin

 

[Dirk Goldgar]

Hi Pat

Fist look in "Tools\Options\Edit\Find tab and
see if the warnings are shut off there.
If not, it sounds like some code was run with:
"DoCmd.SetWarnings False"
and the corresponding:
"DoCmd.SetWarnings True"
did not get run.

Create a new Module with one line
"DoCmd.SetWarnings True"
Run that and see if you don't get it back

It's not necessary to create a new module for that. Pat could just press
Ctrl+G and enter it in the Immediate Window.

 

[kc-mass]

Did you get your warnings back??

 

[Pat Dools]

Something is wrong here. I went to Tools... Options... Edit/Find and
un-checked the 'Action queries' box and then re-checked it. I get my
warnings back. I open a query in design view, make a change, and I notice
that I don't get prompted to save my changes. I run the append query, and I
no longer get prompted when the rows are to be added to the table, they are
added with no warnings.

Is this a corrupt database? I've done a 'Compact and Repair' and it did not
help.

Thanks for the help.

 

[Gina Whipp]

Pat,

How big is your database and what version of Access? I will say I had this
happen once in Access 2003 and found that just importing everything into a
new database (make sure you turn off Autoname Correct and Compact on Close
should be unchecked) and the issue resolved itself. Never did figure out
what the problem was.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[kc-mass]

I would search all code for an instance of the "set warnings false".

 

[Dirk Goldgar]

I would search all code for an instance of the "set warnings false".

I think it had better be "SetWarnings False" that is searched for -- no
space between "Set" and "Warnings".

 

[Pat Dools]

Alright, I found it. I had a macro with the warning turned off and I did not
realize that turned warnings off for the entire database. I reset the
warnings to 'Yes' at the end of the macro and I'm good now. Thanks for all
of the replies!