Access Object Counts

[Dave Ruhl]

Is there any way to query Access to get a count of forms,
tables, reports, and queries ? Thanks...

 

[Graham R Seach]

Dave,

CurrentProject.AllForms.Count
CurrentProject.AllMacros.Count
CurrentProject.AllModules.Count
CurrentProject.AllReports.Count

....for tables...
DCount("[Name]", "MSysObjects", "[Type] = 4")

....for queries...
DCount("[Name]", "MSysObjects", "[Type] = 5")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Brendan Reynolds]

For Access 2000 or later, see the topic 'How Many Objects?' at the following
URL ...

http://brenreyn.brinkster.net/

 

[Dave Ruhl]

Thanks very much. Both suggestions were very helpful!