Solved

turn on/off warnings.

Posted on 2003-12-09
4
882 Views
Last Modified: 2010-04-16
hey experts,
this seems like an easy one.  i run a lot of access programs.  in all of these programs, except one, i do not want to get warnings about updates/deletion/inserts.  i have gone to tools>options>edit/find and unchecked the boxes under "confirm" so this does not happen.  the trouble occurs when i want to run the one program where i do want the confirmations.  i don't want to have to check the boxes everytime i run it and then uncheck them when i'm done so that it doesn't carry over to the other programs.  i've tried doing docmd.setwarnings = true on form load and turning it off before the program closes.  all i get is the following warning "you won't be able to undo the changes this action query is about to make to the data in a linked table or tables".  the warning i want to see is "you are about to update 132 row(s)" which is what i see when i have the "confirm" checkboxes checked.  is there a way of replicating the checking and unchecking of these checkboxes from code so that i get the desired warning message?

thanks,
rye
0
Comment
Question by:ryeandi
  • 2
4 Comments
 
LVL 4

Expert Comment

by:dasari
ID: 9905889
DoCmd.SetWarnings False
'U'r Code
DoCmd.SetWarnings True

U can use vice versa too
0
 
LVL 2

Accepted Solution

by:
bluzeman earned 25 total points
ID: 9905946
Application.SetOption "Confirm Action Queries", False
Application.SetOption "Confirm Record Changes", False

...to turn them off.  Same thing with True to turn them back on.

Rick
0
 
LVL 1

Author Comment

by:ryeandi
ID: 9906020
thanks rick,
exactly what i was looking for.
rye
0
 
LVL 4

Expert Comment

by:dasari
ID: 9906034
my bad...overlooked the post guyz
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question