D Dave Ruhl Feb 19, 2004 #1 Is there any way to query Access to get a count of forms, tables, reports, and queries ? Thanks...
G Graham R Seach Feb 19, 2004 #2 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
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
B Brendan Reynolds Feb 19, 2004 #3 For Access 2000 or later, see the topic 'How Many Objects?' at the following URL ... http://brenreyn.brinkster.net/
For Access 2000 or later, see the topic 'How Many Objects?' at the following URL ... http://brenreyn.brinkster.net/