Hi,
If you look at the report in this file, I have to manually open it, manually print 2 copies, & then manually close this report.
Can this be automated.......once report is open , it prints X copies (user defined) & closes the report.
thanks
Hi,
If you look at the report in this file, I have to manually open it, manually print 2 copies, & then manually close this report.
Can this be automated.......once report is open , it prints X copies (user defined) & closes the report.
thanks
This is Access 101, and your database is so simple it barely exists. You have no forms to display/edit/add to your table. You have no form to present any print options to a user for the report.
Suggest you spend a bit more time on database design, form design, and User interface. Use Google.
I am looking for functionality...........not critique
thanks anyway
This is untested, but usually you can set up print options in the design view of the report. This works for orientation and margins, etc, but don't know about number of copies. Then create a macro to print the form, you can additionally create a form with a button which runs the macro. You can make it do it twice!
One way would be to put the OpenReport command behind a button, twice. You could also use a form textbox for a variable number of copies.
thx , I will try
This is untested, but usually you can set up print options in the design view of the report. This works for orientation and margins, etc, but don't know about number of copies. Then create a macro to print the form, you can additionally create a form with a button which runs the macro. You can make it do it twice!
that's a good idea. thanks