By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,908 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

print number of copies based on text box value

P: n/a
i'm using access 2000 and have a form in which users can select
reports with check boxes and click a print button to print out the
selected reports. what i want to do now is place a text box on the
form where the user can put the number of copies they want to print. i
want to take that value and loop through my print code the number of
time = to the text box value
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
private sub cmdPrint_Click()

dim i as integer
for i = 1 to me!txtPrints
docmd.openreport strReport
next i

end sub

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQAglOIechKqOuFEgEQI4pgCeIwQiQCkxIWq37JMaraDio4 0mRTsAn0V7
mN4un2TfT6PkpS2gofgyiK5U
=m+nU
-----END PGP SIGNATURE-----
gasturbtec wrote:
i'm using access 2000 and have a form in which users can select
reports with check boxes and click a print button to print out the
selected reports. what i want to do now is place a text box on the
form where the user can put the number of copies they want to print. i
want to take that value and loop through my print code the number of
time = to the text box value


Nov 12 '05 #2

P: n/a
MGFoster <me@privacy.com> wrote in message news:<7z******************@newsread1.news.pas.eart hlink.net>...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
private sub cmdPrint_Click()

dim i as integer
for i = 1 to me!txtPrints
docmd.openreport strReport
next i

end sub

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)


Huh?
See the PrintOut method of the report object. You can specify the
number of copies as an argument... You'd just pass the value in your
textbox to the function call.
Nov 12 '05 #3

P: n/a
thank you for your help it works great.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.