Common Dialog Problems

[orbic1]

Does anyone know the reason why on most machines, the common dialog box opens when called, but not on other systems.

I'm calling:
MSComDlg.CommonDialog.1

However, when edited, it comes up with an error stating: There is no object in this control. This only occurs on a handful of machines. Is there a patch that I haven't installed or something?

It occurs on: Windows XP, Office XP and Office 2003, AC2k DB

 

[ghudson]

I belive that the common dialog control must be set to the correct referrence for the version of Access the user has installed. Sounds like a reference problem for the offending PCs.

I prefer to use an API for allowing the user to select a file or directory. That will eliminate those types of problems.

Check out these APIs for calling the standard windows "File Open" and "Browse Folder" using VBA...

API: Call the standard Windows File Open/Save dialog box
http://www.mvps.org/access/api/api0001.htm

API: BrowseFolder Dialog
http://www.mvps.org/access/api/api0002.htm

 

[orbic1]

Thanks - I will endeavor to build this into future apps. Is there a way of still using my present way and getting it working on those rogue systems?

 

[ghudson]

You will have to manually reconnect the reference on each PC.