Access Object Counts

  • Thread starter Thread starter Dave Ruhl
  • Start date Start date
D

Dave Ruhl

Is there any way to query Access to get a count of forms,
tables, reports, and queries ? Thanks...
 
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
 
Back
Top