obtainability/ description of Active X controls for Access prog.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am developing programs in Access. I need to understand Active X controls
and would like to purchase these from a source which explains these controls
in detail so that a novice user can use these effectively.
 
ActiveX controls are obtainable from many sources. Many if not most
commercial ones are catalogued in detail at http://www.componentsource.com.

But go carefully. Access forms are different from VB forms and VBA
userforms, and not all ActiveX controls will work reliably - or at all - on
an Access form. So make sure that any controls you download are designed and
tested for use with Access.

If you're a newcomer to Access and database programming as well as to
ActiveX, I strongly recommend that you master the former before you try the
latter.
 
John Nurick said:
If you're a newcomer to Access and database
programming as well as to ActiveX, I strongly
recommend that you master the former before
you try the latter.

Excellent advice, to which I would add, many Access developers find that
they are able to satisfy the business requirements of the application using
only the built-in Controls that are included with Access. That can save a
lot of hassles because you don't have to distribute and install ActiveX
controls along with your database.

I've been doing Access since 1993, and just once in that time has a client
said they want to solve problem "x" and do it using ActiveX control "y". It
turned out not to be a problem to accommodate that desire, because it was
one of the Windows controls that is included in the Office XP Developer
Edition, and that company already has a procedure for ensuring that ActiveX
controls are distributed and installed.

Larry Linson
Microsoft Access MVP
 
Back
Top