Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 how to batch reports in Access97

Author  Topic 

Hommer
Aged Yak Warrior

808 Posts

Posted - 2005-03-16 : 14:08:44
Hi, my Access Gurus,

Is there a way to group them for preview and printing? I know how to add a field in a higher level table, then have their report names as foreign keys, but how to make DoCmd Openreport treat them as one?

If 97 doesn't have the feature, does any later version have it?

Does Print or Printout method have this feature?

Thanks!

Hommer
Aged Yak Warrior

808 Posts

Posted - 2005-03-29 : 11:24:32
I found a way to get by.
I started off trying to use sub-reports, but the original reports already have 3 level of subreports.
Then I found out in
DoCmd.OpenReport GetDBReportName(), acViewPreview, , strTmp
I could pass in strTmp ="orderID in ('q120120,q120121')"
Then I changed the grouping on the reports to make them look right.
Go to Top of Page
   

- Advertisement -