Group:  Microsoft Access » microsoft.public.access.macros
Thread: Using a macro to run an update querey

Geek News

Using a macro to run an update querey
Access WannaBe 12/17/2008 11:56:00 PM
I am having trouble getting a macro to run a query if there is any other
action in the macro.

I am trying to run an update query with out seeing the warnings. If I use
setwarings/on to ‘no’ the query doesn't run. If I eliminate the warning
action the query runs.

I first wanted to run two queries at the same time, and when they didn't
work I started eliminating actions until I found the problem. My append
query works fine with the warnings turned off.

Any help is much appreciated.

Chad

RE: Using a macro to run an update querey
Access WannaBe 12/18/2008 12:04:00 AM
I fixed it by starting from scratch with a new macro. What's up with that?

"Access WannaBe" wrote:

[Quoted Text]
> I am having trouble getting a macro to run a query if there is any other
> action in the macro.
>
> I am trying to run an update query with out seeing the warnings. If I use
> setwarings/on to ‘no’ the query doesn't run. If I eliminate the warning
> action the query runs.
>
> I first wanted to run two queries at the same time, and when they didn't
> work I started eliminating actions until I found the problem. My append
> query works fine with the warnings turned off.
>
> Any help is much appreciated.
>
> Chad
>

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net