?
Solved

Warning messageboxes

Posted on 2003-03-06
12
Medium Priority
?
361 Views
Last Modified: 2009-07-29
Does anyone know a way to hide or default the answer to "yes" when a query (such as an update query) throws up a messagebox warning you that you are about to update rows?  I have a small system through access and the messageboxes become a pain, especially if you are doing a particular function over and over.

Thanks for any help
0
Comment
Question by:Raziel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
  • +2
12 Comments
 
LVL 12

Accepted Solution

by:
nexusnation earned 200 total points
ID: 8083076
sure. if you run it through code on a form or something:

DoCmd.SetWarnings = False
DoCmd.OpenQuery QueryName
DoCmd.SetWarnings = True
0
 
LVL 4

Expert Comment

by:CRagsdell
ID: 8083220
You can also set Warnings using a Macro if you aren't comfortable with programming. Create a new macro:

Action: Set Warnings | Warning On = No
OpenQuery: Query Name = Name of your query

Use your button to trigger the Macro instead of the Query.

CR
0
 
LVL 12

Expert Comment

by:nexusnation
ID: 8083246
and make sure you turn them on afterwards
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:Raziel
ID: 8083483
Thanks, I'll give that a try
0
 
LVL 4

Expert Comment

by:CRagsdell
ID: 8083892
Actually, when set from a macro, Set Warnings turns itself back on as soon as the macro runs.
0
 
LVL 1

Expert Comment

by:jonsykes
ID: 8087542
To permanently turn them off, go to Tools, Options, Edit/Find and deselect the checkbox:

Confirm Action Queries

0
 
LVL 12

Expert Comment

by:nexusnation
ID: 8091294
i wouldn't do that though. what if you create a delete query and erase all of your client's information accidentally (i have done it and i have seen questions regarding how to reverse it, which cannot be done)?

nex
0
 
LVL 4

Expert Comment

by:CRagsdell
ID: 8091915
Agreed, nex... I usually only use Set Warnings on inserts, not on deletes or updates, and definitely not as my Access default.
0
 
LVL 1

Expert Comment

by:jonsykes
ID: 8101530
In theory I agree with you, but, when you've got procedures that delete data from several tables, then run approx. 20 or so insert and update queries in order to build up your data, then users get very annoyed very quickly if they have to click on Yes all those times.

The majority of users have no idea of the workings behind databases and all they want to do is click on a button and see a report or the correct data. Confirming update and delete query actions only causes them to panic, thinking they've done something wrong.
0
 
LVL 12

Expert Comment

by:nexusnation
ID: 8785303
Hi Raziel,
This question has been abandoned and needs to be finalized (105 days since last comment).

   You can accept an answer, split the points, or get a refund. Go to
   http://www.cityofangels.com/Experts/Closing.htm for information and options.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

nexusnation
EE Cleanup Volunteer for Microsoft Access
0
 
LVL 18

Expert Comment

by:1William
ID: 8884596
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, points to nexusnation
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

1William
EE Cleanup Volunteer
0

Featured Post

Technology Partners: 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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

765 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