Search results

It's the selected line in the form that i use to select which shipment I am printing.

OK so now I have the Report with the Sub-reports, so that it prints all of them at once, except it is picking up all of the data, it is ignoring the Where statement: DoCmd.OpenReport "Rpt Total EPA", , , "[Batch] = " & [ImportDataList] Any ideas?

I am an amature Access user. I inherited this databaase when I got the job, and I have been able to make some small improvements, but i don't know how to do subreports, how would it look?

Ok, so I have Access 2007 a report that I run alot during the course of a day calls 4 print jobs. How can I re-write the followin code so that when I hit print, it doesn't print out each report seperately? DoCmd.OpenReport "Rpt Fax Cover", , , "[Batch] = " & [ImportDataList] DoCmd.OpenReport...

I do not know how to make the 1report with 3 sub reports, and I don't wnat the seperator sheets anymore. I tried looking at the Lebans code for printing reports into a PDF and I am just confused by it.

Ok, so I am a very novice user of Access and I have some ability to code in VBA, but not much. A little background: I did not create this Database, I inherited it. This database is used to generate EPA documentation for thousands of requests a year. It imports the data from an excel sheet...