Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am using a rather complex API-based method for spawning the file save as... dialog. the access application that does this is the only one that has had problems in field testing: many users cannot get it to open directly (meaning, double-click on the access file in Windows Explorer) - the work-around there is to open Access, then navigate to the app and open it. one user that i know of gets reference errors at this point. i suspect it is because of the API calls.

    is there some more lightweight way to implement File Save As...? also, is there an option to select multiple files in any general method?

    TIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Although VBA in Access 2002 and later has Application.FileDialog, Microsoft didn't implement the Save As dialog. You can use it to let the user select multiple files though.

    The Windows API method described in API: Call the standard Windows File Open/Save dialog box doesn't need any references, it should work in any version of Access and under any version of Windows.


  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    BTW, the attached zip file demonstrates a much simplified use of the Windows API functions (no multi-select capabilities).

    [attachment=86830:FileDialogs.zip]

    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
  •