Looking up and viewing MS Word documents from Access

[Lee B via AccessMonster.com]

I want to build a sermon database. I want to be able to find/open to view a
Word file containing the complete sermon, where the file name is recorded in
the database, by clicking on the file name or on a command button. The
objective is to eleminate paper files of sermons that are filed by subject
matter, key scripture verses and date preached in the database. Any ideas?
Thanks in advance!
Lee

 

[Mikal via AccessMonster.com]

If you make one field a hyperlink field by choosing "hyperlink" from the
field type combo box in table design view and, in datasheet view, or in a
form bound to the table, type in the path to the document you want then
clicking on that field will take you there and open the document. Example

c:\MySermons\Prodigal Son.doc

Hope this helps.

Mike

 

[Lee B via AccessMonster.com]

I want to build a sermon database. I want to be able to find/open to view a
Word file containing the complete sermon, where the file name is recorded in
the database, by clicking on the file name or on a command button. The
objective is to eleminate paper files of sermons that are filed by subject
matter, key scripture verses and date preached in the database. Any ideas?
Thanks in advance!
Lee

Mikal
Thanks! One more question.. Will this work where clicking on the hyperlink
would take me to a directory where I could chose the file I wanted to open?
There would be many sermons stored that I may want to review from time to
time.
Thanks
Lee

 

[Mikal via AccessMonster.com]

I sort of imagined the database to be the directory you are talking about.
However, if you do not specify a particular file, just stop with a folder
name, then Access will open up an instance of Windows Explorer with which you
can peruse the contents of the folder. I suppose you could categorize your
sermons and use category names for folders like maybe;

c:\MySermons\Brimstone

which could contain all the really hot stuff you might want to use or:

c:\MySermons\Consolation

which could contain the sort of thing you might want to say on the occaision
of somebody's death or somesuch.

However, these things could also be entries in a field called "txtCategory"
which you could query or filter to produce links to all these sorts of
sermons. You might note that if you open one Word document in a folder and
want to look at another in that same folder then when you click open you will
still be in that folder until you navigate to another one.

Hope this helps.

Mike

I want to build a sermon database. I want to be able to find/open to view a
Word file containing the complete sermon, where the file name is recorded in

[quoted text clipped - 3 lines]

Thanks in advance!
Lee

Mikal
Thanks! One more question.. Will this work where clicking on the hyperlink
would take me to a directory where I could chose the file I wanted to open?
There would be many sermons stored that I may want to review from time to
time.
Thanks
Lee