|
| 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
September 21st, 2004, 12:14 AM
|
|||
|
|||
Confirm Action Query
When I start up my database I would like to stop the
Confirmation of action queries. I know how to do this using options but others users use the database in runtime. I use an autoexec macro to run some action queries on start-up but I don't know how to deactivate the query confirmation. Any help is appreciated. Nick 
|
|
#2
September 21st, 2004, 01:39 AM
|
|||
|
|||
|
Insert the SetWarnings macro action (Argument value is No) into your
AutoExec macro as a step prior to running the first action query. That will suppress the warning message boxes. -- Ken Snell MS ACCESS MVP "Nick" wrote in message ... When I start up my database I would like to stop the Confirmation of action queries. I know how to do this using options but others users use the database in runtime. I use an autoexec macro to run some action queries on start-up but I don't know how to deactivate the query confirmation. Any help is appreciated. Nick
|
|
#3
September 21st, 2004, 03:09 AM
|
|||
|
|||
|
Thanks very much Ken, worked a treat.
Nick -----Original Message----- Insert the SetWarnings macro action (Argument value is No) into your AutoExec macro as a step prior to running the first action query. That will suppress the warning message boxes. -- Ken Snell MS ACCESS MVP "Nick" wrote in message ... When I start up my database I would like to stop the Confirmation of action queries. I know how to do this using options but others users use the database in runtime. I use an autoexec macro to run some action queries on start-up but I don't know how to deactivate the query confirmation. Any help is appreciated. Nick .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Update Query - Operation Must Use An Updatable Query | Cheryl Lamonds | Running & Setting Up Queries | 1 | September 2nd, 2004 12:24 AM |
| "Corrupted" query | Jeff J | Running & Setting Up Queries | 8 | August 12th, 2004 07:51 PM |
| Query to join records form 2 databases | bdehning | General Discussion | 5 | August 9th, 2004 03:09 PM |
| SELECT function in Query | alexparks | Running & Setting Up Queries | 9 | July 5th, 2004 11:31 AM |
| query field reference help | -dch | Running & Setting Up Queries | 4 | June 2nd, 2004 07:30 PM |
Linear Mode
