Can it be done!!

  • Thread starter Thread starter Patrick
  • Start date Start date
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
 
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!"
 
-----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.
 
Back
Top