Using wildcards in path names

[anns]

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]

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
__________________________________________