Printing Multipal Reports

[STELLA94]

Good day,

We are doing certificates for the mines for lifting equipment. We now need to print certificates per page instead of printing a batch.

There must be a better way to print the batch of certificates for the client instead of just printing one by one?

 

[Minty]

Create a multi-select list box with the client's Certificate numbers in them.
Use that to drive printing the required reports.

 

[STELLA94]

Create a multi-select list box with the client's Certificate numbers in them.
Use that to drive printing the required reports.

how do i do this?

 

[Uncle Gizmo]

You may find my blog on printing multiple reports useful:-

Generate Multiple Reports - Nifty Access

Generate Multiple Reports This blog came about because of an answer I gave to a particular OP's question. Therefore the code isn't generic, it is designed for a specific situation, like most examples! However I hope there's enough information here for you to follow what's happening. Multiple...

www.niftyaccess.com

 

[Minty]

This is a little involved so Baby steps -
First create a list box which lists everybody's certificates.
Then using the client id on the form filter the query to just that clients certificates.
If you only have a limited number at any given time you would then create Where string for your report from the selected list items.

If there are loads of records then you might consider "moving" them into a second list so that visually your user can easily see which cert number will be printed.

You then create the where clause for your reports to print.
You will need to create a loop to get the selected items into a where clause ( I would use an IN(2,9,25,105) clause myself) but a search on here will give you plenty of examples.

Then simply print the report.
Easy

Obviously, if you haven't done this level of programming before it may be a little daunting but each step is pretty straight forward. Do each bit at a time and if you get stuck post back here.

 

[Pat Hartman]

The only time you would need a multi-select list box is if you can't use standard select criteria like:

Select ... from tblCertificates where ClientID = Forms!myform!cboClientID

Select ... from tblCertificates where ChangeDT Between Forms!myform!txtFromDT and Forms!myform!txtThruDT

Select ... from tblCertificates where UpdateDT= Forms!myform!txtUpdateDT