Print Button / Multiple Copies (a2000)

Topic

New Reply

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

Reply | Quote

Replies

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

DoCmd.PrintOut

– Change this to

DoCmd.PrintOut Copies:=5

– 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.

Reply | Quote

Thanks Hans and John

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

Thanks again

Steve

Reply | Quote

Check out

Print Report Multiple Times (2000 SR-3)
post 267938

Reply | Quote