Is there a way to know, in vba, when a form is loaded all the available tables there are. The tables that I have to play with are constantly being deleted and created. So what I would like to do is have a list in an array of all the tables that were there when the form was loaded. Thanks for any help
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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
List available tables
- Thread starter coughnut
- Start date
Something like the following....
Dim strList as String
Dim tdf as TableDef
For each tdf in CurrentDB.TableDefs
strlist = strlist & tdf.name & vbcrlf
next tdf
Learn from the mistakes of others. You won't live long enough to make all of them yourself.
Dim strList as String
Dim tdf as TableDef
For each tdf in CurrentDB.TableDefs
strlist = strlist & tdf.name & vbcrlf
next tdf
Learn from the mistakes of others. You won't live long enough to make all of them yourself.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question