TIGREBLANCO
Programmer
Hi, hope someone can help:
This is a VB6 program trying to get access to all the properties in a given MS Access Form's control (i.e. textbox.caption).
I can connect a variable to the MS Access Object Collection (set accessapp = createobject(access.application)), but can't seem to find the way to access the properties of the controls on any given form.
When I look at the AccessApp object in my Watch Window (in vb6) I can see the objects (tables, queries, etc) but under the forms collection I see: [+]Item 1.....[+]Item 4 (my database has four forms so far).
Why in the world am I not seen the names of the forms (i.e. Login_frm) instead of "Item 1".
My question is then: How can vb6 access the properties of any control within any given MS Access form.
I've automated excel with ease, but the Access Object Collection seems to behave a little bit different, I'm kind of lost on this one.
I hope I provided all necessary info, please let me know if otherwise.
Any Ideas ne1?
Regards.
This is a VB6 program trying to get access to all the properties in a given MS Access Form's control (i.e. textbox.caption).
I can connect a variable to the MS Access Object Collection (set accessapp = createobject(access.application)), but can't seem to find the way to access the properties of the controls on any given form.
When I look at the AccessApp object in my Watch Window (in vb6) I can see the objects (tables, queries, etc) but under the forms collection I see: [+]Item 1.....[+]Item 4 (my database has four forms so far).
Why in the world am I not seen the names of the forms (i.e. Login_frm) instead of "Item 1".
My question is then: How can vb6 access the properties of any control within any given MS Access form.
I've automated excel with ease, but the Access Object Collection seems to behave a little bit different, I'm kind of lost on this one.
I hope I provided all necessary info, please let me know if otherwise.
Any Ideas ne1?
Regards.