[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

ActiveX Controls Documentation

In MS Access 2002, there is a list of ActiveX Controls. By looking at them, I can't tell what they do and how to make them work. Is there a publication or website that I can obtain descriptions of the controls and their usefulness?
0
stevensont
Asked:
stevensont
  • 3
  • 2
  • 2
  • +2
1 Solution
 
Steve BinkCommented:
Depends on the specific control you're trying to look at.  A good many of them have associated help files in Access already, if you have installed them.  Otherwise, you can try the MSDN documentation online (go to microsoft.com and search for your control in the knowledge base), but it's relatively difficult finding just the thing you need on that site.  Your other alternative is third-party sites, such as EE, which can help explain a control to you.  I'd be happy to do that, but I need to know which control you would like to know about.
0
 
Steve BinkCommented:
FYI, if you press Alt-F11 from the main Access window, you open up the VBA environment window.  Press F2 in that window, and you open up the object browser.  This window will show you all objects, collections, methods, etc., that are contained within any reference you have included in your project (see [Tools | References] for that list).  If Access has an associated help file for your control, you can locate it in the list, highlight it and press F1, and the help will open right to it.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Also be aware that the entire listing is NOT compatible with Access ... this is a listing of most/all Activex controls installed on your system by any program, and many of them will be runtime only controls.

Also, unless you own the Developer edition of Access, the controls you see listed will probably cause you some grief when used in Access (Access doesn't behave well with most Activex controls). If this is a single-user type app, you'll be okay, but if you plan on distributing this application to others then this can quickly become a pain.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
stevensontAuthor Commented:
Very informative suff. Is there a book or something I can read on ACCESS 2002 ActiveX controls? I see a whole list of controls, but which are ACCESS and what are their primary function. I know about the calendar control, but what are the others. Is it a try it and see sort of thing?
0
 
Steve BinkCommented:
AFAIK, experimentation is the order of the day.  I've seen sites dedicated to explaining ActiveX controls, but they generally handle specific or well-known controls, so you still need to know what you're looking for.  If you need specific functionality, explain your requirements and perhaps we can point you in the right direction.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Here's a list of controls supported in 2000. I'm almost certain the list didn't change from 2000 - 2003.  Most are pretty self-explanatory from the title (the Treeview obviously builds and displays a treeview, the Datagrid obviously builds and displays a grid control).

As you'll notice, only one control is available outside the Developer edition (the Calendar control, and it blows). If you want to play around with Activex, and you have a real, compelling need to do so, do yourself a favor and stay AWAY from the MS controls ... they are the very definition of DLL Hell ... you're much better off with 3rd party items.

http://support.microsoft.com/default.aspx?scid=kb;en-us;208283
0
 
puppydogbuddyCommented:
For anyone who is interested, there are activeX and type library documenter tools available to developers for free at the following link: I tried one with one of my access 2000 app and it worked as stated in the documentation.
               
                                     http://www.codestone.co.uk/
0
 
Jeffrey CoachmanCommented:
If what you want is a listing of what all (Approx 175) controls in "More Controls" do, then I would take LSMConsulting's advice and stick with the "Access" supported controls.

When I first started out I wanted to see what "All" of these cool sounding controls did.

Then I asked myself: "How often am I going to need the "Kodak Image Annotation Control"?

Good Luck!
:)
0
 
stevensontAuthor Commented:
Good point boag2000
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now