Find File Box

[scruffy1473]

Hello all,

I am new to Access VBA and I am trying to cr eate a database in which you can import different text files (without the headings). I have tried using macros and some of the scripts that I found on the web, however nothing that I have tried has worked. I need some type of find file box so that users can select a unique text file each time they use the database. I appreciate any help.

Thanks in advance!

[HiTechCoach]

I wuld recommend using teh Windwos Open File Dialog API. See: Call the standard Windows File Open/Save dialog box (http://access.mvps.org/access/api/api0001.htm)


I alos have an example database that shows how to use the API: Document Links (http://www.hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=7&Itemid=28)

Hope these help.

[scruffy1473]

Thank you so much.