Adding shortcut

[Fong]

Hi all,

I am new to Access and is trying to create a database to better organise my
computer files.

I have a lot of pdf and word files on my computer in different folders and
would like to create a database to make searching for them easier as well as
generating a summary of all the articles. These are articles on medicine.
Examples would be drugs used in the treatment of Parkinson's disease or
Features of motor neuron disease.

As such, they can be difficult to find even by creating may folders. I was
thinking of creating a database which has the title, author, date published,
categories (neurology) and subcategories (Parkinson's disease)

A field which include a shortcut to the file would be very useful. So that I
can open the file from Access.

Is that possible?

Thank you

 

[Douglas J. Steele]

Depending on exactly what the files are, you probably don't need shortcuts
just to open them from Access: you can use the FollowHyperlink method.

If strFile contains the full path to the file, try somethin like:

Application.FollowHyperlink strFile