comdlg32.dll (Access 2003)

Topic

New Reply

A system which was OK is now having broken reference problems , both on a network and on my home machine.
I have tried to attach a word doc which shows two screen shots to demonstrate my problem but it is too big to upload, so I will try to describe:
When I go into “References”, I have a missing: Microsoft Common Dialog Box 6.0(SP3). The location is C:WINNTSystem32comdlg32.dll. Being WinXP the computer only has a WINDOWS directory, not WINNT. When I browse to sort out the problem, a Microsoft Visual Basic Error appears, “Can’t add a reference to the specified file.”
The Help at that point is no help at all!!
There has been a suggestion that a recent Windows security update may have caused the problem but I can’t find any reference to it.
Thanks
John

Reply | Quote

Replies

Try unchecking the missing reference and closing the references dialog. Then reopen it and try to set the reference to the correct version of the the file. Personally, I avoid using the common dialog control in Access, although it works nicely in VB. If you aren’t using the dialog, you don’t need the reference.

Reply | Quote

>Personally, I avoid using the common dialog control in Access

No doubt there are very good reasons for this.

Presently, I am looking at an application which consolidates log file data. Once an old log file is archived, the user gets prompted for the name of the new log file. I had thought of using the Common Dialog Control to open the log file folder – to replace the present Input Box. What would be your workaround?

Reply | Quote

Which versions of Access will be used? Starting with Access 2002, you can use Application.FileDialog to display Open, Save As and Pick Folder dialogs.

If your database will also be used in Access 2000 and/or 97, you can use the class module from the database attached to post 271,686. It encapsulates Windows API calls and will work in any version.

Reply | Quote

Try unchecking the missing reference and closing the references dialog. Then reopen it and try to set the reference to the correct version of the the file. Personally, I avoid using the common dialog control in Access, although it works nicely in VB. If you aren’t using the dialog, you don’t need the reference.

Reply | Quote

Are you sure that reference is supposed to be to for comdlg32.dll and not comdlg32.ocx ?

I get the same error as you if I try to set a reference to comdlg32.dll but I can set one for comdlg32.ocx ok.

When you click browse, change the file type filter.

Reply | Quote

Are you sure that reference is supposed to be to for comdlg32.dll and not comdlg32.ocx ?

I get the same error as you if I try to set a reference to comdlg32.dll but I can set one for comdlg32.ocx ok.

When you click browse, change the file type filter.

Reply | Quote