Printing based on ID

[Guest]

Hello,

I'm not sure if this is the appropriate place for this question, so I
apologize if it is not.

I have several reports in Access 2003 and they all contain a primary key
field (ID). I would like to print out one copy of each report based on this
primary key identifier (ie. print out "report A" with ID 123, "report B" with
ID 123, "report C" ...etc). Is there any way I can set up Access to do this
with any given ID that I may require?

Thanks for your help!

 

[Mike Labosh]

I'm not sure if this is the appropriate place for this question, so I

apologize if it is not.

Yup, you're in the right place.

I have several reports in Access 2003 and they all contain a primary key
field (ID). I would like to print out one copy of each report based on
this
primary key identifier (ie. print out "report A" with ID 123, "report B"
with
ID 123, "report C" ...etc). Is there any way I can set up Access to do
this
with any given ID that I may require?

You can have the query the reports are based on have a parameter for ID that
it uses as a criterion. Then, to run them, pass the desired value from a
control:

DoCmd.OpenReport MyReport, acViewNormal, , txtID.Text

 

[Roger Carlson]

there are several ways to do this. On my website
(www.rogersaccesslibrary.com) is a small sample database called
"PrintOneLabel.mdb", which shows you 3 ways to do it. Don't be misled by
the name. Label reports are just like any other report and these methods
can be used for any report.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L