Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ACCESS PRINT PROBLEM
- Thread starter SAUL
- Start date
You could do it using a variable linked to a while clause. I have had a similar situation where different operators wanted a different number of copies of a specific print. I added a routine which enabled them to set the number of copies required which is stored in a table within the access database. This value is then read by the print procedure and I just loop round until the count is reached. [sig][/sig]
I used the same method as stated by mick
An unbound field on the print form then
Dim iMaxPage As Integer
iMaxPage = CInt(Me!txtCopies)
For giPrint = 1 To iMaxPage
DoCmd.OpenReport gstrfrmName, acViewNormal, , "LinkJobID = " & MyRSIP!LinkJobID 'acViewNormal
Next
Dave [sig]<p>Dave<br><a href=mailto:dab@completebs.com>dab@completebs.com</a><br><a href= Bsuiness Systems</a><br>See website for more info but we can develop most things for most people.[/sig]
An unbound field on the print form then
Dim iMaxPage As Integer
iMaxPage = CInt(Me!txtCopies)
For giPrint = 1 To iMaxPage
DoCmd.OpenReport gstrfrmName, acViewNormal, , "LinkJobID = " & MyRSIP!LinkJobID 'acViewNormal
Next
Dave [sig]<p>Dave<br><a href=mailto:dab@completebs.com>dab@completebs.com</a><br><a href= Bsuiness Systems</a><br>See website for more info but we can develop most things for most people.[/sig]
- Status
