Browsing Folder in Access

[lalexander]

Is there a way to browse a folder and open files within that folder in
access

 

[Guest]

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

 

[lalexander]

Thanks for the response.

I will try this

Regards.

 

[Guest]

I got it here and it works great.

Good Luck

Thanks for the response.

I will try this

Regards.

 

[lalexander]

Could you gave me a sample of what you did.

I'm not to familiar with the functions command and how to implement it.


Thanks

 

[Guest]

strDefaultDir = "\\rsltx1-bm01\busmgmt\Vought " & strCurrYear & "\" &
strCurrYear _
& " Actuals\" & strCurrMonth & "\"
varGetFileName = "Vought Invoice " & strCurrMonth & " " & strCurrYear &
".xls"

varGetFileName = ahtCommonFileOpenSave(ahtOFN_OVERWRITEPROMPT, _
strDefaultDir, "Excel Spreadsheets (*.xls) *.xls", , _
"xls", varGetFileName, "Import Adjusted Actuals", , True)
Me.Repaint
If varGetFileName = "" Then 'User Clicked CANCEL
GoTo LoadAdjustedActuals_Exit
End If

 

[PC Datasheet]

Take a look at www.mvps.org/access in the API section. The first example
does exactly that.