Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    London, Gtr London, United Kingdom
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print Button / Multiple Copies (a2000)

    Good afternoon

    A question in 2 parts

    1. I have used the button wizard to put a print button on a form, can I adjust the code behind the button at all to change the number of copies printed (I need 5 copies of the form printed)

    2. If the answer to 1. above is yes can each printed copy bear a different legend, i.e. 1st copy = Copy 1 for delivery agent, 2nd copy = Copy 2 for Origin Station etc.

    Thanks

    Stephen

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Print Button / Multiple Copies (a2000)

    1. Yes, but see under 2.
    - Open the form in design view.
    - Select the button.
    - Activate the Event tab of the Properties window.
    - Click in the On Click box.
    - Click the ... to the right of the dropdown arrow.
    - You will see some code, including a line

    <code>DoCmd.PrintOut</code>

    - Change this to

    <code>DoCmd.PrintOut Copies:=5</code>

    - If you want more info, click in the word PrintOut and press F1.

    2. Not easily. The best way to do this would be:
    - Create a table containing the 5 legends.
    - Create a query based on the table or query behind the form plus the new query.
    - Create a report based on this query, grouped by legend.
    - Print the report from the form.

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Button / Multiple Copies (a2000)

    Check out

    Print Report Multiple Times (2000 SR-3)
    <post#=267938>post 267938</post#>

  4. #4
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    London, Gtr London, United Kingdom
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Button / Multiple Copies (a2000)

    Thanks Hans and John

    Part 1 is fine, part 2 I am still doing my homework

    Thanks again

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •