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
|
|||
|
|||
supress warnings in ACCESS 2007
How can I do the following in Access 2007..
In Access 2003 we can supress the warnings by the following... Tools Options Edit/Find (Tab) Action Queries (remove the selection) My database works fine in 2003 but when I run in 2007 it shows the alert for all my DoCmd.OpenQuery , DoCmd.RunSQL . I don't want to use DoCmd.SetWarnings False\True as there are about 10 action queries. Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201002/1 |
#2
|
|||
|
|||
supress warnings in ACCESS 2007
mls,
I think you want the Office Button/Access Options/Advanced, and uncheck the ActionQueries. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "mls via AccessMonster.com" u55943@uwe wrote in message news:a407d343da9fd@uwe... How can I do the following in Access 2007.. In Access 2003 we can supress the warnings by the following... Tools Options Edit/Find (Tab) Action Queries (remove the selection) My database works fine in 2003 but when I run in 2007 it shows the alert for all my DoCmd.OpenQuery , DoCmd.RunSQL . I don't want to use DoCmd.SetWarnings False\True as there are about 10 action queries. Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201002/1 |
#3
|
|||
|
|||
supress warnings in ACCESS 2007
Thank you very much. That worked perfectly.
Al Campagna wrote: mls, I think you want the Office Button/Access Options/Advanced, and uncheck the ActionQueries. How can I do the following in Access 2007.. In Access 2003 we can supress the warnings by the following... [quoted text clipped - 8 lines] Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201002/1 |
Thread Tools | |
Display Modes | |
|
|