API for VBA in ACCESS?????

[Stuemper]

Hello,

I urgently need an API for VB(A) Objects in MS Access.

Where can I get the names of the Properties of Objects like Option Groups or List Fields from? It's a riddle each time.

I need an API like the follwing (general example)

object: optionGroup

property: Value -> value of the selected button

so --> Me.Controls.Item("Group1").Value


why is there nothing similar in MS Access?

 

[KenHigg]

Access vba help is quite extensive. Then there is the object browser. Seems all you would need. What exactly are you looking for? Maybe an example?

kh

 

[Stuemper]

example

Well, I have to know all the Fields and methods of Control - Objects like Option Group or List Fields.

For example I want to know which radio button in an Option Group is selected. The I have to check the value of the field 'Value' of the Option Group Object.

But I didn't find this information in the object browser or in the help file, it was just a guess. So I want to have an API like in Java. I can't work that way.

Help can't help me, because my access on the forms is over an array called 'Item'. When put a dot behind an array access, I get no help.

So please tell me about systematic search for information about vb objects.

 

[ecniv]

For example I want to know which radio button in an Option Group is selected. The I have to check the value of the field 'Value' of the Option Group Object.

Use a frame then the options inside, assign each option a value different to the rest. Rename the frame fra<something> where <something> is more relevant to you.

In VBA fraSomething is the value of the option selected. In design mode set a default value for the form. Also make sure that the right mouse click on it cannot be used to deselect a value of the frame...

Properties (like value) are listed in the .properties(number) method/property
Methods I'm not sure, but lal the ones you need to make a form and loop through the controls are available.

Perhaps a re-think on what you are trying to do.


As to making your own API for this, its probably possible, but since you can't even pull back the properties or methods now how are you going to write it?


Vince