easy hook to File Save As.. dialog

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

BTW, the attached zip file demonstrates a much simplified use of the Windows API functions (no multi-select capabilities).

Reply | Quote