×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Multiple copies of rpt of Access97 runtime?

Multiple copies of rpt of Access97 runtime?

Multiple copies of rpt of Access97 runtime?

(OP)
Access97 RUNTIME on a client's PC. There is a Print Label button on a form that uses the DoCmd.OpenReport method to call a query based rpt and prints a label for that record. How can I give the user the option of printing multiple copies of the label at runtime without doing a mail merge? I would like to have a box pop up and request the number of copies required from the user. Any ideas?
Thanks.

RE: Multiple copies of rpt of Access97 runtime?

The DoCmd.PrintOut is what you need to look at.

Use a variable to get the number of copies wanted from a TextBox and plug that in for the copies parameter. Have your print button call this code with the On Click Event.

DoCmd.PrintOut acPrintAll, , , , Copies

Bob Crawford

RE: Multiple copies of rpt of Access97 runtime?

(OP)
Thanks for the reply Bob.
The Printout acPrintAll prints the open object which in this case is my form containing the "Print Label" cmd button - therefore it does not print n copies of the label but it does print n copies of the form. The onclick event of the cmd button calls a query based report to print the labels. Somehow I have to be able to let the user enter the number of copies and have it apply to the label print. If you have any other suggestions please let me know.
Thanks
Don

RE: Multiple copies of rpt of Access97 runtime?

FYI on page 438 & 439 of Alison Balter's Mastering Access97 there are two examples you might use. If you can't find the Access97 book anymore, she may have included them in a later book. They are named "Printing Multiple Labels" and "Determining Where a Label Prints" and are in the Advanced Reports Techniques chapter.

The thing is when you use multiple labels, you can then specify the next time to print, the next blank label, rather than having to start a whole new sheet. My users liked to avoid the hassle of having to load a new sheet each time. I used these once with pretty good success. I had to do a bit of trouble shooting but it was pretty smooth.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close