Multiple Report, same format

[Excel_Kid1081]

Helllo-

I've searched this forum numerous times and have not seen a solution to the reporting solution I am trying to accomplish. Basically, I have one report that I want to repeat the format and style for different accounts. However, I don't want to go in and create the same report for each account but would rather have the template set-up in VBA for the the format and style (that way if I need to change something in the format I wouldn't have to do it 20+times for each report).

I haven't seen anything in terms of setting up the font, lables, lines, etc for building reports in VBA. Is that possible? If so, can someone point me to some helpful links/threads?

Thanks!!

EK

 

[pbaldy]

Rather than multiple reports, couldn't you use a parameter query or wherecondition to restrict a single report to the chosen account?

 

[boblarson]

And to go with Paul's absolutely straight on response, I have a sample which shows you how to have a GENERIC report and filter it by several means.

 

[Excel_Kid1081]

that would work if I only needed to run one report at a time. However, I'm looking to have a template for all the accounts as these 'template reports' will feed into a larger report.....

 

[Excel_Kid1081]

thanks for the reply Bob..I know it seems kind of foolish but unfortunately, using a parameter query to limit the results to one account won't work. The reason for the template is so I can have a the same report for say 3 accounts and look at them simultaneously by having them all in one larger report that doesn't have a record source.

A simple way to think of it would be if you wanted to have the back of three baseball cards for three different players all on one report. For each card it should have the same layout, fonts, etc. then for the final product those three sub-reports would be combined into one larger report so you could see all three side by side....

Hope that helps. Thanks again!