Go Back   Access World Forums > Microsoft Access Reference > Code Repository

Thread Tools Rate Thread Display Modes
Old 09-03-2017, 02:34 PM   #1
Gold Supporter
ridders's Avatar
Join Date: Jan 2017
Location: Somerset, UK
Posts: 2,599
Thanks: 43
Thanked 610 Times in 565 Posts
ridders has a spectacular aura about ridders has a spectacular aura about
View All Database Objects

This item allows you to view all objects in a database.
The objects list is obtained from the hidden system table MSysObjects.
It is updated automatically as objects are added to or removed from the database.

Depending on the object type, you can choose to open the object in design view or run it direct from the form.

1. So you can see this in action, I have included a number of dummy objects e.g. Table1, Query1, Query 2 etc

2. To use this in your own databases, copy the following 3 items:
- Form frmDatabaseObjects
- Report rptDatabaseObjects
- Table tblSysObjectTypes

3. No additional VBA references are required for this item

4. It will work in 32-bit or 64-bit Access
Attached Files
File Type: accdb DatabaseObjects.accdb (700.0 KB, 43 views)

Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk

If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!
ridders is offline   Reply With Quote

database objects

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare Objects in a Database gemma-the-husky Code Repository 4 03-29-2016 07:42 AM
importing objects from secured database to clean database Jaye7 General 9 06-03-2015 10:58 PM
Question Two divisions but one set of database objects, How? JoeyB_99 General 5 12-07-2012 11:58 AM
view tables and forms in design view once it is converted to web database jpb Tables 0 12-06-2012 01:29 PM
Cannot find the database or some database objects the page refers to. Update the.... raggajunglist ASP and ASP.NET 1 06-04-2010 06:38 PM

All times are GMT -8. The time now is 12:01 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World