If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trouble with Access Prompts
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! |
#2
|
|||
|
|||
Trouble with Access Prompts
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 "DanCole42" wrote in message ... 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! |
#3
|
|||
|
|||
Trouble with Access Prompts
On Jan 15, 10:28 am, "Geary" wrote:
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 "DanCole42" wrote in message ... I tried that after seeing it in some other posts... doesn't seem to work. |
#4
|
|||
|
|||
Trouble with Access Prompts
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. "DanCole42" wrote in message ... On Jan 15, 10:28 am, "Geary" wrote: 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 "DanCole42" wrote in message ... I tried that after seeing it in some other posts... doesn't seem to work. |
Thread Tools | |
Display Modes | |
|
|