Printing Single Lables

[Guest]

How do I print a single label, of one record, from a table of 50 records?
I can print labels for all 50 records but, not just a selected single record.
I am using Microsoft Access 2000 in Microsoft XL Professional.

 

[Joseph Meehan]

How do I print a single label, of one record, from a table of 50
records?
I can print labels for all 50 records but, not just a selected single
record. I am using Microsoft Access 2000 in Microsoft XL Professional.

I use a query to select the records I want to print. I add a binary
(yes-no) filed to the table and display the records let the user select the
ones they want to print.

Next they click a "Next" button that displays the same data from the
query which filters out all "NO's" This gives them a chance to review the
list and make sure they really want to print all of them. This form as a
button "Print" (also has a quit button to reset all to no and quit) that
sends the list to the printer.

If you need you could have an additional step to assure they all printed
properly allowing the user to reprint as needed.

 

[Allen Browne]

Use the WhereCondition of the OpenReport to specify the primary key value of
the record you wish to print.

There's an example in this article:

Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html