Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Auckland, North Island, New Zealand
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    comdlg32.dll (Access 2003)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: comdlg32.dll (Access 2003)

    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.
    Charlotte

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: comdlg32.dll (Access 2003)

    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.
    Regards
    John



  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: comdlg32.dll (Access 2003)

    >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?
    Gre

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: comdlg32.dll (Access 2003)

    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>post 271,686</post: >. It encapsulates Windows API calls and will work in any version.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •