Prev: Close After Inactivity
Next: Cancel Button not working
From: mls via AccessMonster.com on 22 Feb 2010 16:07
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/Forums.aspx/access-forms/201002/1

From: Al Campagna on 22 Feb 2010 22:09
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(a)uwe> wrote in message
news:a407d343da9fd(a)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/Forums.aspx/access-forms/201002/1
>


From: mls via AccessMonster.com on 23 Feb 2010 10:54
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/Forums.aspx/access-forms/201002/1

 | 
Pages: 1
Prev: Close After Inactivity
Next: Cancel Button not working