Print Query

[Guest]

I am setting up a macro to run several queries. I really don't want to
bother setting up a report for each of these queries as I am the only one who
will see them.

OpenQuery will only open them to view. I know someone out there has a
workaround for this, please share!

TIA!

Julie

 

[Jeff Boyce]

Julie

I'm not clear what you're asking for.

SELECT queries only do that. If you don't need to see the rows returned,
don't run the query!

INSERT/DELETE/UPDATE queries change things (these are "action" queries).
They generally don't return rows, so there's nothing to see.

Why are you running the queries, and what kind are they?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I am running several queries to audit changes to our payroll database. I
need these to review someone else's work. There are about 8 queries that
focus on specific portion of an employee file and show the record statistics
before and after the change.

So what I really want is to have the macro print the queries to the printer.
I've done this on other things and direct printed reports, but I really
don't want to go to the hassle of making up a report when the data shown from
the select query in datasheet form is good enough for me.

Thanks!

 

[Steve Schapel]

Julie,

It is difficult to understand "don't want to go to the hassle of making
up a report". Using the report wizard, and a few tweaks, you would have
the report in a lot less time than it took you to write your messages here.

Anyway, if printing the query datasheet is really what you want, I think
you could use a PrintOut action in your macro, following the OpenQuery
action.