Access 97 Reports select records to print

K

kflint

I need to be able to set a parameter value. How? Have gone to the help menu
and no instruction on how to create the value. Printing labels and only need
certain records at times to print.

Help! ASAP!
 
K

Ken Snell [MVP]

I assume you're speaking of a parameter in a query. Easiest way to do this
is to put prompting text inside [ ] characters, and use that as the
criterion expression for the field that is to be filtered:

[Enter the Customer ID:]
 
F

fredg

I need to be able to set a parameter value. How? Have gone to the help menu
and no instruction on how to create the value. Printing labels and only need
certain records at times to print.

Help! ASAP!
Click to expand...


Do you mean you wish to select several labels at a time to print?
If so, add a Yes/No check box field to the table.
Then add the field to your form.

Make sure the report record source includes the new field.
If it is the table, it will be included. If it is a Query or SQL add
the check box field to the query.

Place a check mark in the records for which you wish to print a label.

Then add a command button to the form.
Code it's Click event:
DoCmd.OpenReport "LabelReport", acViewPreview, , "[CheckField] = -1"

Only records that have been checked will be printed.

To clear all the check boxes at once, use an Update query:

Update YourTable Set YourTable.CheckField = 0;

Run the query when you finish running the report to reset the check
boxes.
 
Top