Adjust Number of Reports

  • Thread starter Thread starter David Simons
  • Start date Start date
D

David Simons

I have designed an application with the following reports

RPTdelnote , RPTcreditnote , RPTinvoice

The reports are activated by "Command Buttons "

I need a simple method to be able to adjust the number of
copies printed as differing users require differing number
of copies of each report ( Some want 2 copies, some 3,
etc) .

Can I create a table detailing the individual report names
and the number of copies to print.
If so , how would I reference this table for each report

Or is there an easier way ?

Thanks in advance for any help/ advice

David
 
The PrintOut method allows a number of copies, but I find it
a bit limited. You can also just do a loop around a
OpenReport command after querying the user on the number of
copies.

Dim lngCopies as Long, lngCopied as Long

lngCopies = InputBox("How many copies would you like?")

Do Until lngCopies = lngCopied
DoCmd.OpenReport...............
DoEvents
lngCopied = lngCopied + 1
Loop

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top