Friends, I was thinking of creating a form in Access and add a list
box that displays all my Word files I have saved in my C:\My
Documents\ folder.
Once a users selects the required file, it should automatically open.

Is this something possible to do with Access?

Thanks.

Access supplies you with the Dir() command, which you can use to build a
file/folder listing. Check online help for examples.

After selecting the file, you would automate Word to open your file:

<air code>
Dim wrd As Word.Application
Set wrd = New Word.Application

wrd.Documents.Open "PathToYourDocument"

etc etc
"Paolo" <jprma (AT) tin (DOT) it> wrote

Alternatively you could call a Windows file dialog with the arguments for
the folder and the file type..

I think an example is here: http://www.mvps.org/access/api/api0001.htm

--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response


"Scott McDaniel" <scott (AT) no (DOT) spam.thedatabaseplace.net> wrote