Iterate Reports?

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

Obviously there are table, query and form collections within access which
can easily be iterated but has anyone found a way to do this with reports? I
am still unsure why Microsoft has never included reportdefs.

Any insight would be appreciated, thanks in advance.
 
Microsoft has never included FormDefs, either. The only two items that are
in the corresponding collections whether open or not are, yep, Tables and
Queries.

Just like Forms, the Reports collection only includes _open_ Reports. There
are however, Containers, which include all the Reports. Check Help or a good
self-study book on Containers and Collections. You may have to open the
Report in DesignView to do much of anything with it, and then it will be in
the Reports collection.

Access Projects have an AllReports collection that you could use, but
believe me, that's not reason enough to go to an ADP!

Larry Linson
Microsoft Access MVP
 
Back
Top