I have a report that is generated after a macro runs. The macro runs several queries (select, make table and an append). I would like to have just the report open. Right now the 2 select queries open and then the report opens.
Preview Report without seeing queries
- Thread starter jbphoenix
- Start date
boblarson
Smeghead
- Local time
- Today, 12:46
- Joined
- Jan 12, 2001
- Messages
- 32,040
Why do you need to run SELECT queries? You shouldn't have to do that to make things work. A Select just selects items and displays them. However a select query can be inside an action query and if so it will not display it when it runs but use the results as the basis of that action query.
I rarely find that make tables are needed (unless your data is large enough to slow down reporting operations) but if you need to do that, instead of running your queries via a macro - move to VBA code and use
CurrentDB.Execute "YourQueryNameHere"
and you won't get the warnings and all.
Similar threads
