Q: retrieve control's properties of an external database from code

[Andrew Coyle]

Hi

I was wondering how could I can retrieve the properties of
a control located in an external database using VBA code.

I have found the following snippet of code for determining
if a form exists in the external database:

' See if the name is in the Forms collection.
If objectType = "acForm" Then
test = db.Containers("Forms").Documents
(objectName).Name
If Err <> NAME_NOT_IN_COLLECTION Then
DoesObjectExist = EXIST
End If

But I cannot figure out how to access the controls on that
form

Thanks in advance
A

 

[Marshall Barton]

Hi

I was wondering how could I can retrieve the properties of
a control located in an external database using VBA code.

I have found the following snippet of code for determining
if a form exists in the external database:

' See if the name is in the Forms collection.
If objectType = "acForm" Then
test = db.Containers("Forms").Documents
(objectName).Name
If Err <> NAME_NOT_IN_COLLECTION Then
DoesObjectExist = EXIST
End If

But I cannot figure out how to access the controls on that
form

The form must be opened before you can get to its
collections and properties. If you're using one mdb to, for
example, document another mdb, then open the form in design
view so you do not inadvertantly invoke any the form's event
propcedures.