Code to open windows open/select file dialog window

[LisaB]

I tried using the code for FindNorthwind in the solutions database to open
the windows Open dialog box, but nothing happens. I copied the following
functions to a module....and used a command button on a form to run the
FindNorthwind function which should put the resulting path in a text box on
the same form. So, the click event of the button look like this
Me![Text4] = FindNorthwind()

Function FindNorthwind
Function MSA_CreateFilterString
Function MSA_GetOpenFileName
MSAOF_tF(msaof As MSA_OPENFILENAME, of As OPENFILENAME)
OF_to_MSAOF(of As OPENFILENAME, msaof As MSA_OPENFILENAME)


The windows open file dialog box never opened.

---------------------------------------------------------------

In my application, I need the user to select a file from their network or c:
drive

I need to know the full path of the file they selected

Can anyone help

 

[Bruce M. Thompson]

The windows open file dialog box never opened.

---------------------------------------------------------------

In my application, I need the user to select a file from their network or c:
drive

I need to know the full path of the file they selected

You might have better luck with the code on the following page at The Access
Web:

API: Call the standard Windows File Open/Save dialog box
http://www.mvps.org/access/api/api0001.htm

 

[LisaB]

Thank You.

You might have better luck with the code on the following page at The Access
Web:

API: Call the standard Windows File Open/Save dialog box
http://www.mvps.org/access/api/api0001.htm