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