Folders/Drive Object for Form

[Chris]

Our organization had previously created an ocx object for
Access 2000 that gave us the ability to "path" around and
display "TXT" file and access them.

The "Code" used an "On Update" call:

=NewFileLocation(Forms![Data Import Menu])

to a Function that used a global string

Global strLocation As String

and sent the FormName

strLocation = FormName![GWAcctFiles].Path

However, this function doesn't seem to work in Office XP
Access. Does any one know how to change the "Function"
code so we get the same results?

 

[Allen Browne]

Best idea would be to use this API call if you want just a folder:
http://www.mvps.org/access/api/api0002.htm
or this one if you want a whole file name:
http://www.mvps.org/access/api/api0001.htm

Access 2002 does have a FileDialog object, but it is not very useful.
Requires a reference to the Office library. Doesn't work in MDE/runtime.
Doesn't work at all for SaveAs.