Not prompted when running append/make-table queries?

  • Thread starter Thread starter Pat Dools
  • Start date Start date
P

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!
 
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
 
kc-mass said:
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
Click to expand...

It's not necessary to create a new module for that. Pat could just press
Ctrl+G and enter it in the Immediate Window.
 
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.
 
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 said:
I would search all code for an instance of the "set warnings false".
Click to expand...


I think it had better be "SetWarnings False" that is searched for -- no
space between "Set" and "Warnings".
 
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!
 
Back
Top