Folders

[Jay Miller]

Hello,

I am working with MS Access 2002 on an XP workstation.
I've already created my database, but would like to be
able to do a coulple addition functions (if possible).

First, I would like to be able to display folders located
on our servers within my database form.

Second, Can I import Word documents into Access? If not,
how can I create functions that would open up Word
documents located on our fileserver?

I'm not well experienced with Access and your assitance
would be much appreciated.

Thank you.

 

[John Nurick]

Hello,

I am working with MS Access 2002 on an XP workstation.
I've already created my database, but would like to be
able to do a coulple addition functions (if possible).

First, I would like to be able to display folders located
on our servers within my database form.

If you want to let the user select a folder or file on the network, just
use the FileDialog() function (new in Access 2002) or the code at
http://www.mvps.org/access/api/api0001.htm (or
http://www.mvps.org/access/api/api0002.htm to just browse folders). If
you want to display a list of folders in a listbox or combobox on an
Access form it's possible but not so simple.

Second, Can I import Word documents into Access? If not,
how can I create functions that would open up Word
documents located on our fileserver?

You can but as a rule it's better not to. Instead, just store the
locations and names of the documents in your database. If you use a
Hyperlink field for this, (a) clicking on the field in a form or a
datasheet will launch the document in Word, and (b) you can just drag
the document from My Computer onto the field and the hyperlink will be
created automatically. (Needless to say, this works for all documents
that have applications associated with them, not just Word ones.)