Q: Bradley Welland writes to ask if there is any information available on using ActiveX controls in Access.
A: This continues to be a sore point, even in Office 2007. ActiveX controls (other than the few native ones) can’t be depended on to work the same in Access as in other hosts (such as VB), or indeed to work at all. If you look for help on an ActiveX control you are thinking of using in Access, you may get a Help topic for C++, VB or VBScript, which is not helpful for working with Access VBA. The last time I wrote about this topic was for the release of Office 2000, and things haven’t changed since then, except indirectly (Office XP and higher now has its own FileDialog control, which eliminates the need to use the cranky CommonDialog ActiveX control). You can download my White Paper on the Microsoft Office Developer (MOD) edition of Office 2000, which includes information on using ActiveX controls.
