Alec,
If you are using the api from the access web called api 0001, then the
following will allow you to tell the dialog where to open
When you call this function in your code, use the code below.
' Now actually call to get the file name.
varFileName = ahtCommonFileOpenSave( _
OpenFile:=True, _
InitialDir:=varDirectory, _
Filter:=strFilter, _
Flags:=lngFlags, _
DialogTitle:=varTitleForDialog)
If Not IsNull(varFileName) Then
varFileName = TrimNull(varFileName)
End If
GetOpenFile = varFileName
On the line
InitialDir:=varDirectory, _
you can use (example)
InitialDir:="c:\documents and settings\all users\desktop", _
replace "c:\documents and settings\all users\desktop" with the path and
folder where you want it to open
Jeanette Cunningham
