Get List of Control/Properties of Form from another Access DB Grant 07.06.2006 06:55:01 Hi, I am programming in VBA and using DAO to connect to another Access DB (working fine). What I am trying to do is get a list of the Controls and the Properties for those controls for a Form on the other Access DB. I can get a list of the Forms via the SysObjects, but can't seem to find a way to access the Controls/Properties. I have approx 850 Access Databases to check through (Lab Test with 850 students) so want to check their DB and see if they have created the Form (ok), then check to see what Controls they have and what they have set for the Properties. I really want to use DAO (not ADO) but anything will do at this stage. Thanks in advance. Kind Regards, Grant.

Re: Get List of Control/Properties of Form from another Access DB "Douglas J Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 07.06.2006 11:51:16 Alex has already answered you post in microsoft.public.access.modulesdaovba In general, there's no need to post to more than one newsgroup. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Grant" <Grant[ at ]discussions.microsoft.com> wrote in message news:4A17F4F2-6C2D-45B3-8B3C-BA306D338D89[ at ]microsoft.com... [Quoted Text] > Hi, > > I am programming in VBA and using DAO to connect to another Access DB > (working fine). > > What I am trying to do is get a list of the Controls and the Properties for > those controls for a Form on the other Access DB. > > I can get a list of the Forms via the SysObjects, but can't seem to find a > way to access the Controls/Properties. > > I have approx 850 Access Databases to check through (Lab Test with 850 > students) so want to check their DB and see if they have created the Form > (ok), then check to see what Controls they have and what they have set for > the Properties. > > I really want to use DAO (not ADO) but anything will do at this stage. > > Thanks in advance. > > Kind Regards, > > Grant.