Using wildcards in path names

anns · Aug 18, 2008

We currently import a text file on opening a form using the TransferText
method. Everything works fine but I'm wondering if there is a way to use
wildcards in the path when finding the file. My concern is that IT may
change drive names, add directories etc. that would nullify the import.
Thanks.

Tom Wickerath · Aug 19, 2008

You can use a command button on a form to open a Common Dialog box, which
will allow you to browse to the file of your choice.

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

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

Using wildcards in path names

anns

Tom Wickerath