If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
print command button- multiple copies
I have a print command button on my form. Is there a way to get it to print 3
copies when it is selected only one time? Or do I have to select it 3 times? |
#2
|
|||
|
|||
print command button- multiple copies
On Thu, 2 Feb 2006 14:12:31 -0800, Karen TS wrote:
I have a print command button on my form. Is there a way to get it to print 3 copies when it is selected only one time? Or do I have to select it 3 times? Print the Form itself? Never!! Create a report with just the data you need. (If you need the actual form with all of it's buttons and background, etc., select the form, right-click and select "save as ... report".) Then code that command button click event: DoCmd.RunCommand acCommandSaveRecord DoCmd.SelectObject acReport, "ReportName", True DoCmd.PrintOut acPrintAll, , , , 3, 0 Look up the various arguments needed in the SelectObject and PrintOut methods. All you need do is save the form once as a report. Anytime after that simply run this report and the data will be current. Note: the above will print every record in the table that the form is bound to. It's best to create an actual report and filter the data as needed in the report's record source. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
use print record command button to print multiple copies | Karen TS | New Users | 0 | February 1st, 2006 06:31 PM |
Multiple copies per sheet | Surelyknot | Publisher | 4 | January 20th, 2006 11:58 PM |
Record Duplication, multiple copies in Form | DianaS | General Discussion | 2 | August 4th, 2005 04:41 PM |
print multiple pages on one sheet of paper | Reunited | Publisher | 8 | January 4th, 2005 07:17 AM |