Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
automate update query
0 views
Skip to first unread message
Greg Clements
May 14, 2004, 4:41:36 PM5/14/04
to
i have an update query i want to run when i close a form,
i want to know if there is a way to bypass the 2 pop up
screens that ask question about running the query, i was
going to try the sendkeys command running in the form
before closing it but the pop ups still occur, i know
this has to be something simple, I am just missing it,
any help would be great!.
i want to know if there is a way to bypass the 2 pop up
screens that ask question about running the query, i was
going to try the sendkeys command running in the form
before closing it but the pop ups still occur, i know
this has to be something simple, I am just missing it,
any help would be great!.
Greg
rotor
May 14, 2004, 4:56:05 PM5/14/04
to
You may be able to try:
DoCmd.SetWarnings False
Your code
DoCmd.SetWarnings True
HTH
anon...@discussions.microsoft.com
May 14, 2004, 5:35:40 PM5/14/04
to
nope still get the pop up windows.>.
>
>
Van T. Dinh
May 14, 2004, 7:31:21 PM5/14/04
to
Use the Execute Method to run the Query.
Exceute will run silently without warnings.
--
HTH
Van T. Dinh
MVP (Access)
"Greg Clements" <gcle...@tecvar.com> wrote in message
news:d51101c439f3$d9c5edc0$a001...@phx.gbl...
0 new messages