Can it be done!!

P

Patrick

HI ALL!!

can I use VBA to get info in the database itself.
EX.:
I would like to create a list of all the tables available
(that have been created so far) in the current database
I'm in right now. Same thing for Forms, queries modules
and so on.....

Can it be done...

If so, could you show me an example of VBA code....

Thank you,

Patrick
 
D

Dirk Goldgar

Patrick said:
HI ALL!!

can I use VBA to get info in the database itself.
EX.:
I would like to create a list of all the tables available
(that have been created so far) in the current database
I'm in right now. Same thing for Forms, queries modules
and so on.....

Can it be done...

If so, could you show me an example of VBA code....
Click to expand...

You can do it using DAO or by querying the hidden MSysObjects table.
Here's how to do it by querying MSysObjects:

http://www.mvps.org/access/queries/qry0002.htm

P.S. Please use a more meaningful subject next time. "Can it be
done!!" is almost as bad as "Help!"
 
J

Joel Wiseheart

-----Original Message-----


You can do it using DAO or by querying the hidden MSysObjects table.
Here's how to do it by querying MSysObjects:

http://www.mvps.org/access/queries/qry0002.htm

P.S. Please use a more meaningful subject next time. "Can it be
done!!" is almost as bad as "Help!"

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
Or, if you're looking for more than just a list, you can
also use the Database Documenter under Tools | Analyze |
Documenter.
 
Top