Object methods / properties

way2bord

Registered User.
Local time
Today, 02:58
Joined
Feb 8, 2013
Messages
177
Is there a standard method of obtaining an unfamiliar object's methods and properties?
 
I think you're going to have to give a better explanation than you have, in order for us to help you. What, exactly, does 'unfamiliar object' mean, in this context?

Linq ;0)>
 
I think you're going to have to give a better explanation than you have, in order for us to help you. What, exactly, does 'unfamiliar object' mean, in this context?

Linq ;0)>

:p* sorry...

I'm looking for Intellisense features for activeX objects that don't seem to have Intellisense. I have functions or classes in front of me...and I'm tired of scouring the internet for the white pages on this object while attempting to learn exact syntax for its properties, methods, etc.

How is Intellisense determining what comes after the dot (.) / bang (!) and can I reproduce a text list of intellisense data with a simple loop somehow?
 
What ActiveX Controls are we talking about, here? Adding 6 different ActiveXs (from the Ribbon) to a Form, in the Code Module all exhibited Intellisense. If you're asking where you can go for a listing of the properties/methods of a given ActiveX Control, I have no idea. I suspect that the appropriate properties/methods are sent to Access from the code within the Control itself, and I have no idea how to access this info. Sorry.

It should be noted that in Form Design View, when you select an ActiveX Control and go to Properties - Events, typically only a very few of its events are listed. For the full list of events you have to
  1. Go into the Form's code module
  2. From the top/leftmost dropdown box, select the given Control
  3. Pull down the top/rightmost dropdown box, and you'll see the entire list of events for that Control.
Linq ;0)>
 
A loop through their properties collection works for some ActiveX controls.

In the Immediate Window this will return a list of the names of the properties while the form is open in form view.
Code:
Set obj = Forms!formname.controlname: For n = 0 to obj.Properties.Count - 1: ? obj.Properties(n).Name: Next
 

Users who are viewing this thread

Back
Top Bottom