Trouble with Access Prompts

  • Thread starter Thread starter DanCole42
  • Start date Start date
D

DanCole42

Weird stuff going on in one of my databases.

When I run an update or delete query, usually it asks me if I'm sure I
want to update xxxx records. Now it just does it.

Also, if I create a query, then decide I don't want to save it, if I
try to close the window or all of Access, it doesn't give me the "Exit
without saving? Yes/No/Cancel" dialog, it REQUIRES me to name/save my
unsaved query.

How do I fix this?

I don't know much about Access, so detailed instructions are
appreciated. Thanks!
 
In Access 2000 you turn the warnings on by ticking the boxes in the
TOOLS-OPTIONS-EDIT/FIND-CONFIRM box.

In VBA it's DoCmd.Setwarnings True
 
In Access 2000 you turn the warnings on by ticking the boxes in the
TOOLS-OPTIONS-EDIT/FIND-CONFIRM box.

In VBA it's DoCmd.Setwarnings True
Click to expand...

I tried that after seeing it in some other posts... doesn't seem to
work.
 
I would search for "SetWarnings" in the project to see where it's being
turned off. If the warnings are off and an action query is raising an error
then the warning might not be getting turned back on.

Stepping through the code in debug is probably the best way to find it.
 
Back
Top