Computing.Net > Forums > Office Software > macro in ms access

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

macro in ms access

Reply to Message Icon

Name: xenias
Date: July 7, 2005 at 02:34:21 Pacific
OS: aa
CPU/Ram: aa
Comment:

I have automated some queries with a macro, but i wanted to know if there is a way not to SHOW the result of the query itself (or am i using the wrong macro)

so just execute the query without showing it ;)



Sponsored Link
Ads by Google

Response Number 1
Name: mdow
Date: July 7, 2005 at 07:01:55 Pacific
Reply:

I'm not sure what you mean by 'SHOW' the query. I'm guessing that you are referring to the query warnings. If so, you would want to do something like this:

DoCmd.SetWarnings False
run queries
DoCmd.SetWarnings True


0

Response Number 2
Name: xenias
Date: July 8, 2005 at 02:02:06 Pacific
Reply:

by 'SHOW' i mean

when i run the macro (containing the query) i get the resultpage of the query itself (like u would get when u just ran the query)

so i wanted to know if there was an option of any kind that when i run the macro, it executes the query on the background, so without showing a resultpage of any kind?

thx



0

Response Number 3
Name: mdow
Date: July 8, 2005 at 05:18:25 Pacific
Reply:

What is the query doing? Is it a select query, update query etc.


0

Response Number 4
Name: xenias
Date: July 11, 2005 at 02:05:32 Pacific
Reply:

found a macro that does the job!


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: macro in ms access

Max Records in MS Access www.computing.net/answers/office/max-records-in-ms-access/5993.html

printer object in MS access www.computing.net/answers/office/printer-object-in-ms-access/1576.html

Cannot record macro in Ms word www.computing.net/answers/office/cannot-record-macro-in-ms-word/9645.html