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

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-03-2017, 02:34 PM   #1
ridders
AWF VIP
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.

NOTE:
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)

__________________
Colin
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
Reply

Tags
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
General
Tables
Queries
Forms
Reports
Macros
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