File "save as" or "open" Dialog Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there some predefined was in Access 2003 to open a dialog box with a file seclection feature. I wish to have the users “select†a file that already exists on the harddirve, but I do not want to hardcode the file name or location. Is there some code or an Active X object that is already there that I can just use?

I appreciate any feedback. I am new to Access programming.

Thanks,
Michael
 
You can use the FileDialog object in the Office 11 library for a FileOpen,
but not for a SaveAs. It also fails if you try to convert back to older
versions of Access, or if you try to use it in MDE/runtime.

For a reliable and flexible approach, use the API call in this link:
http://www.mvps.org/access/api/api0001.htm
It may look a little daunting if you have never worked with API calls, but
it is actually quite simple to implement.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Mike P. said:
Is there some predefined was in Access 2003 to open a dialog box with a
Click to expand...
file seclection feature. I wish to have the users "select" a file that
already exists on the harddirve, but I do not want to hardcode the file name
or location. Is there some code or an Active X object that is already there
that I can just use?
 
Back
Top