By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,098 Members | 1,895 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,098 IT Pros & Developers. It's quick & easy.

Macros and queries

P: n/a
I've got a Macro that runs a few Queries and then ends with a Report. It
opens all the Queries and leaves them open and I'd really prefer that it not
do that. Is there a way to just run the Queries and/or close them
immediately?

Thanks,
Robert
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Robert wrote:
I've got a Macro that runs a few Queries and then ends with a Report. It
opens all the Queries and leaves them open and I'd really prefer that it not
do that. Is there a way to just run the Queries and/or close them
immediately?


I don't use macros but I think there's a close command you can use? I
don't see the point of opening a select query if you're not looking at
it's contents anyway, action queries I can understand running before a
report to do something that the report needs but they don't open on
screen, just execute so automatically close anyway.

--
[OO=00=OO]
Nov 13 '05 #2

P: n/a
The Select Query is choosing the Records for my Report.

Robert

"Trevor Best" <no****@besty.org.uk> wrote in message
news:42**********************@news.zen.co.uk...
Robert wrote:
I've got a Macro that runs a few Queries and then ends with a Report. It
opens all the Queries and leaves them open and I'd really prefer that it
not do that. Is there a way to just run the Queries and/or close them
immediately?


I don't use macros but I think there's a close command you can use? I
don't see the point of opening a select query if you're not looking at
it's contents anyway, action queries I can understand running before a
report to do something that the report needs but they don't open on
screen, just execute so automatically close anyway.

--
[OO=00=OO]

Nov 13 '05 #3

P: n/a
Never mind. I figured out that I can use a Filter instead of the Query to
build my Report.

Thanks. Lot's to learn but I'm getting there. This is kinda' cool.
"Robert" <ro***@email.com> wrote in message
news:3_********************@comcast.com...
I've got a Macro that runs a few Queries and then ends with a Report. It
opens all the Queries and leaves them open and I'd really prefer that it
not do that. Is there a way to just run the Queries and/or close them
immediately?

Thanks,
Robert

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.