I am using Access 2002.
Is there a technique to produce a report listing all the tables, forms, queries, reports, etc.?
3 6587
Here's a link to Stephen Leban's website that contains an example of how to do this for the tables in a database: http://www.lebans.com/listtablesinmdb.htm
This should point you in the right direction for the other items as well.
Regards,
Scott
I am using Access 2002.
Is there a technique to produce a report listing all the tables, forms, queries, reports, etc.?
Here is basic code which will accomplish what you are requesting. Simply call the Function with the appropriate Parameter: - Public Function GetObjectList(ByVal lngType As AcObjectType) As Variant
-
' Returns an array of object names.
-
-
' Parameters:
-
' intType -- one of acTable, acQuery, acForm,
-
' acReport, acDataAccessPage, acMacro or acModule
-
-
Dim intI As Integer
-
Dim strName As String
-
Dim astrOutput() As String
-
Dim objCollection As Object
-
Dim aob As AccessObject
-
-
Select Case lngType
-
Case acTable
-
Set objCollection = CurrentData.AllTables
-
Case acQuery
-
Set objCollection = CurrentData.AllQueries
-
Case acForm
-
Set objCollection = CurrentProject.AllForms
-
Case acReport
-
Set objCollection = CurrentProject.AllReports
-
Case acDataAccessPage
-
Set objCollection = CurrentProject.AllDataAccessPages
-
Case acMacro
-
Set objCollection = CurrentProject.AllMacros
-
Case acModule
-
Set objCollection = CurrentProject.AllModules
-
End Select
-
-
intI = 0
-
-
For Each aob In objCollection
-
strName = aob.Name
-
intI = intI + 1
-
ReDim Preserve astrOutput(1 To intI)
-
astrOutput(intI) = strName
-
Next aob
-
-
GetObjectList = astrOutput
-
End Function
- Private Sub Command6_Click()
-
'Given the Object type to enumerate, this Function creates a
-
'list of Object names and returns that string. To return just specific Objects:
-
Dim varList, T As Integer
-
-
'one of acTable, acQuery, acForm,
-
'acReport, acDataAccessPage, acMacro or acModule
-
-
varList = GetObjectList(acForm) 'Returns all Forms
-
-
For T = 1 To UBound(varList)
-
Debug.Print varList(T)
-
Next T
-
End Sub
OUTPUT: - subfChild
-
Switchboard
-
frmEmployees
-
frmContinuous
-
Main Form
I am using Access 2002.
Is there a technique to produce a report listing all the tables, forms, queries, reports, etc.?
You can also go to Tools/Analyze/Documenter from within access.
J
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Der Andere |
last post by:
I need to implement a sorted (ordered) list. STL has no sorted list type as
far as I know. Is there a (straight) way to implement a sorted list using
STL?
BTW: The type of items in the list will...
|
by: kyle.tk |
last post by:
So I have a central list of python objects that I want to be able to
share between different process that are possibly on different
computers on the network. Some of the processes will add objects...
|
by: zeke |
last post by:
I have an Access database that suddenly opens without the list of
objects (You know, Tables, Queries, Forms, Reports . .) at the left of
the screen. The objects still exist - for instance, I can...
|
by: matthew.macdonald-wallace |
last post by:
Hi all,
I'm trying to add functionality to an app written in C# so that a list
of people is displayed in a list box on the left hand side and then
selected individuals can be added to another...
|
by: G Gerard |
last post by:
Hello
I am trying to connect to a msaccess database and then create a list of the
objects in that database (more specifically the tables) and then create a
list of the fields (including the...
|
by: Jeff |
last post by:
ASP.NET 2.0
My webpage has a GridView showing rows from a table in the database. All
these rows are stored in the session object -what's actually stored is
generic list of objects, as this:...
|
by: smoothmunkey |
last post by:
I want to make a switchboard with a list box to open objects... but i want the list box to be dynamic (as new queries or forms are created, i want them added). so far i have a combo box that selects...
|
by: AZRebelCowgirl73 |
last post by:
This is what I have so far:
My program!
import java.util.*;
import java.lang.*;
import java.io.*;
import ch06.lists.*;
public class UIandDB {
|
by: jappenzeller |
last post by:
We're using the HttpRuntime Cache for our objects and we're trying to do the following.
We pull lists of objects from the database and put them in cache. We put a reference to the list in...
|
by: krishna81m |
last post by:
I am unable to create a list of objects dynamically. I run a SQL query on the database and populate objects of types that I also know aprior. I read the query as a string, run it on the database and...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |