Open File/Browse Dialog VBA code

[Bryan]

Hi,

I want to write VBA code for a command button click event,
that will allow the user to find and open a file from
another location.

It could be a picture, spreadsheet, whatever, in any
location. I'm envisioning the the click event opening to
Windows Explorer.

Thanks, Bryan

 

[Cheryl Fischer]

You can browse for and select a file using the code found at:

http://www.mvps.org/access/api/api0001.htm

Also, there is code to select a folder at:

http://www.mvps.org/access/api/api0002.htm

 

[Guest]

Hi,

I have tried to use this page but I'm having an error at
this line - sub or function not defined.

ahtAddFilterItem and
ahtCommonFileOpenSave

Help!

 

[Bruce M. Thompson]

I have tried to use this page but I'm having an error at
this line - sub or function not defined.

ahtAddFilterItem and
ahtCommonFileOpenSave

Help!

Did you copy all of the available code into a standard (global) module (not a
module behind a form or report)?