ACCESS FEED: Re: [MS_AccessPros] Print a report twice

Rabu, 10 Juli 2013

Re: [MS_AccessPros] Print a report twice

Abdul,

I put a command button on a form so the user could print two copies. Here is the code I used:

Private Sub cmdPrintForm_Click()
On Error GoTo Err_cmdPrintForm_Click

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.PrintOut acSelection, , , , 2

Exit_cmdPrintForm_Click:
Exit Sub

Err_cmdPrintForm_Click:
MsgBox Err.Description
Resume Exit_cmdPrintForm_Click

End Sub

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> I would create a small table [tblCopies] with a two fields [CopyNumber] (numeric) and [CopyTitle] (text) and add two records
>
> 1 Office
> 2 Customer
>
> Add this table to the report's record source and don't join it to any other table. Add the CopyTitle to the query grid. Then your report will print two copies of each record.
>
> If you want, you can bind the CopyTitle field to a text box.
>
> Duane Hookom MVP
> MS Access
>
>
> ----------------------------------------
> > To: MS_Access_Professionals@yahoogroups.com
> > From: maxccess@...
> > Date: Wed, 3 Jul 2013 18:02:12 +0500
> > Subject: [MS_AccessPros] Print a report twice
> >
> > Dear All,
> >
> > I have a A4 size access report for sales invoices how do I print this
> > invoice twice i.e one office copy one Customer copy in one go
> >
> > --
> > Regards,
> > Abdul Shakeel
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
>