hiding queries behind a macro

M

magick

i have numerous macros that run a series of queries to get the results for a
report. In 2003, the macro would run and only display the report. a new
macro that i created in 2007 opens the report, but also opens all of the
queries behind it in dataview, which i don't want the users to have to see
and close. how do i change this in 2007? thanks!
 
S

Steve Schapel

Magick,

What sort of queries are these? Are they Action Queries (e.g. Append,
Make-Table, Update) or are they Select Queries? If they are Action Queries,
I can't understand how they can open in datasheet. If they are Select
Queries, I dcan't understnad why you would be running them.
 
M

magick

you are so right - i had 2 make-table and 1 append but had also included 2
select queries that the report is using in the macro (unneeded). thanks for
jogging my brain.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top