tfurnivall
Registered User.
- Local time
- Today, 01:51
- Joined
- Apr 19, 2012
- Messages
- 81
Hi there
I have a need to enumerate all the Tables/Forms/Modules/Classes etc in an Access Database. At present I'm scanning MSysObjects, but I was wondering if there were an easier way. Using Tables as an example the (pseudo-)code looks like this:
Not pretty, perhaps, but it works!
My question is - the UserForms collection is only those forms that have been loaded. When I am running this procedure, I'd far rather not have to load and show each form in turn. Quite apart from the overhead, it would be visually very distracting! Is there an easier way to get at ALL the forms, not just the loaded ones?
Thanks,
Tony
PS To avoid religious debates - I just wanna do this - it's so that I am not tied to Access in the future!
I have a need to enumerate all the Tables/Forms/Modules/Classes etc in an Access Database. At present I'm scanning MSysObjects, but I was wondering if there were an easier way. Using Tables as an example the (pseudo-)code looks like this:
Code:
Get all MSysObjects where Type = <Tabletype> ' An Access constant, value = 1
Strip off all 'Msys' and 'f_' entries ' Not needed for my purposes
Look in the TableDefs Collection and process the corresponding TableDef
My question is - the UserForms collection is only those forms that have been loaded. When I am running this procedure, I'd far rather not have to load and show each form in turn. Quite apart from the overhead, it would be visually very distracting! Is there an easier way to get at ALL the forms, not just the loaded ones?
Thanks,
Tony
PS To avoid religious debates - I just wanna do this - it's so that I am not tied to Access in the future!