Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    173

    Unanswered: Common File Dialog Box in Access 2K

    I need a file dialog box to return a path to a file I need to import. How do I go about setting this up on a form. I've heard that in A2K it requires API calls. I've done this no sweat in VB6. Any body got ideas. TIA

  2. #2
    Join Date
    Jul 2004
    Posts
    125
    Common dialog code with the API calls for VB (VBA) is available from the Microsoft website. Unfortunately, Windows has about 6 different common dialogs and 2 folder dialogs (at least). Without the developer edition, (with API support), I haven't been able to standardize which style of dialog box I get. One is stuck with what is displayed. The procedures work in Windows 98, NT, 2000 and XP. If you like, I can upload the code later this afternoon (in about 2 hours). Let me know.

  3. #3
    Join Date
    Apr 2004
    Posts
    173
    That would be great. I don't need anything real fancy, I just need to return a path string. I tried out some cut and paste code from the Access web that seems to work well, but I would like to see what you have. Thanks.

  4. #4
    Join Date
    Jul 2004
    Posts
    125
    It is originally from the MS website, and I tweked it a little, nothing fancy. Will upload it later.

  5. #5
    Join Date
    Jul 2004
    Posts
    125
    Attached please find the 'Find data' comon dialog procedure I mentioned earlier.
    Attached Files Attached Files

Posting Permissions

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