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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Batching reports for printing

Status
Not open for further replies.

scra

Technical User
Dec 7, 2001
55
US
I would like to setup a form with an option group (something like that) to select 1 or more different reports for printing at the same time. Any ideas?
 
Yuo could set up checkboxes with the name of each report. Then a command button for Preview or Print that goes through code like this:

If chk1 = -1 Then docmd.openreport "report1"
If chk2 = -1 Then docmd.openreport "report2"
If chk3 = -1 Then docmd.openreport "report3"
If chk4 = -1 Then docmd.openreport "report4"

 
I'll give it a try...thanks. Is there a way to link Access97 to Word97? The reports being selected is a Word document. My first intention was to convert the Word documents (letters, contracts, etc) into an Access report. Is there a way to print out those documents from Word97 using the codes you inscribed for Access97? I don't want to reinvent the wheel if I don't need to.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top