Trying to look up query from from & print

[BrookieOU]

Here's my problem, maybe you can let me know if it's possible to do something
like this.

I have a query that lists billing details for Purchase Orders (invoices that
were billed against that Purchase Order, the amount of the invoice and the
hours worked). Lots of times we would only like to look at billing for
specific invoices and print them in a report. I can go into the query and
enter the invoices I want in the criteria and then go to the report to print.
What I want to do is to be able to pull up the information and print all at
once without having to open the query, enter the criteria, close the query,
open the report and then print.

I know that I can set parameters that will ask what PO number you want, but
I don't know how to do it if they want to list more than one PO (sometimes
they want more than one on the report). Also, sometimes we want to limit the
detail by specific pay periods. Is there any way I can do this without
having to do all of the steps in the above paragraph?

 

[Tom Wickerath]

Hi Brooke,

Have a look at Access MVP Armen Stein's sample for "Report Selection
Techniques", available here:

http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

You can always add a multiselect list box, to allow selecting multiple
Purchase Orders. You'd need to add the appropriate VBA code to "iterate" the
..ItemsSelected property of this control. There is an example of doing this in
the February 12, 2008 download that I made available on the Seattle Access
Users Group site:

http://www.seattleaccess.org/downloads.htm

So, basically, it would just be combining the two ideas.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________