Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
table names 1
- Thread starter megatron7
- Start date
-
1
- #2
A starting point (VBA code):
For Each tdf In CurrentDb.TableDefs
Debug.Print tdf.Name
Next
(SQL code)
SELECT Name
FROM MsysObjects
WHERE Type In (1, 4, 6)
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
For Each tdf In CurrentDb.TableDefs
Debug.Print tdf.Name
Next
(SQL code)
SELECT Name
FROM MsysObjects
WHERE Type In (1, 4, 6)
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question