Printing from Access

  • Thread starter Thread starter AHopper
  • Start date Start date
A

AHopper

I am trying to print labels from an Access 2002 database
on a label printer. I want to print the labels when a
record is saved using a command button and I want to print
2 of each label. I would like to do this without the user
having to select the printer or number of labels. The
number of labels needed is stored in field in the database.

I install the printer (drivers).
Design the labels as a report?
What event of the "Save Record" button should I use? (On
Click)
If the printer is not the default how do I choose it
through the command button?
How can I print the number of copies of the label (report)
stored in the "Job" table field "LabelsNeeded"?

If this is not posted under the right category let me know
so I can repost.

Thank you for your time and help

Allan
 
See comments in-line.

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
I am trying to print labels from an Access 2002 database
on a label printer. I want to print the labels when a
record is saved using a command button and I want to print
2 of each label. I would like to do this without the user
having to select the printer or number of labels. The
number of labels needed is stored in field in the database.

I install the printer (drivers).
Click to expand...

Yes. This relates to your OS, not Access.


Design the labels as a report?
Yes



What event of the "Save Record" button should I use? (On
Click)
Yes



If the printer is not the default how do I choose it
through the command button?
Click to expand...

You nominate the specific Printer in the Design of the
Report.


How can I print the number of copies of the label (report)
stored in the "Job" table field "LabelsNeeded"?
Click to expand...

"fredg" (Fred Gutkind, a regular MVP respondent) often
posts code to do this in the "Reports" newsgroup. Check
posts in the "Reports" newsgroup. Also check Google
as "fredg" post his code numerous times previously. If
you cannot find previous posts from fredg, post again in
the "Reports" newsgroup.


If this is not posted under the right category let me
know so I can repost.
Click to expand...

Probably more appropriate in the "Reports" newsgroup but
do the above (checking previous posts / Google) and you
probably find that you don't need to re-post.
 
Van, thank you very much for your response.

Allan
-----Original Message-----
See comments in-line.

HTH
Van T. Dinh
MVP (Access)



Yes. This relates to your OS, not Access.




You nominate the specific Printer in the Design of the
Report.




"fredg" (Fred Gutkind, a regular MVP respondent) often
posts code to do this in the "Reports" newsgroup. Check
posts in the "Reports" newsgroup. Also check Google
as "fredg" post his code numerous times previously. If
you cannot find previous posts from fredg, post again in
the "Reports" newsgroup.




Probably more appropriate in the "Reports" newsgroup but
do the above (checking previous posts / Google) and you
probably find that you don't need to re-post.



.
Click to expand...
 
Back
Top