Making Word Documents available

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On Access97 at work. Trying to put together a complete library of
policy/procedure and form documents for our Hospital Laboratory. Contents now
in umpteen thousand notebooks. I've set up the basics with macros back and
forth to the 14 areas of interest. I've made tables of the various Tables of
Contents for each. But how do I set it up so the neophyte can click on the
TOC item and get to the WORD document listed? Any help MUCH appreciated! Susan
 
Susan said:
On Access97 at work. Trying to put together a complete library of
policy/procedure and form documents for our Hospital Laboratory.
Contents now in umpteen thousand notebooks. I've set up the basics
with macros back and forth to the 14 areas of interest. I've made
tables of the various Tables of Contents for each. But how do I set
it up so the neophyte can click on the TOC item and get to the WORD
document listed? Any help MUCH appreciated! Susan
Click to expand...

Store the full network path to the document in a field of your table and then
use...

Application.FollowHyperlink Me!FieldName

The above would be code executed in a form based on your table. You cannot do
this from the table directly unless you want to use hyperlink fields and set
them up for each entry.
 
Thanks Rick. I'm sorry to be so dense, but I need more detail. If I use your
first idea, then isn't the user confronted with one humongous file of every
document in the area of interest? So if I use your second idea for direct
access from the table to the specific document, how do I create a hyperlink
field? Can all of this travel as an ACCESS package, or would I need to
install all the WORD files in a separate package?
 
What Rick is saying is

1- setup a table in which you will have a field named FilePath where you
will store the complete file path and file name as text.

2- create a form to access the information within this table and setup an
event (could be a button or something else depending on your needs) that
would execute a Application.FollowHyperlink action. This action would in
fact open the word document in your word editor.

The beauty of this is the fact that your documents can reside anywhere
throughout the network and you simply create hyperlinks to them.

Basically to achieve what he is suggesting you would need to create a table
and setup a basic form with some programming.

Daniel
 
Thanks Daniel and Rick! I'll try this out at the hospital tomorrow and see if
I can do it. I really appreciate you taking the time to help me out. Susan
 
12/27 Update: So for each of 14 sections I now have a form that includes a
List Box populated by the table that is basically a Table of Contents. It
includes the subject matter and a FilePath field. I've added a "Go to It"
control to the form, the Macro for which has me stumped. First I say to Open
Table. Then I say RunApp but I don't know how to write the line that says to
go to the highlighted record and follow the Hyperlink.

A secondary question is that I don't want everyone able to edit the WORD
document - just myself and the Laboratory Manager. What started me thinking
about this was Daniel's reference to the document showing up in the word
editor. How do I make the documents read only, except for key people?

I hope I'm not driving you crazy. Conquering this really means a lot to me
and I'm very grateful for your patience! Susan
 
Daniel - Could you or Rick or someone take a look at my 12/27 post on this
thread. I'm stuck and really need help. Thanks, Susan
 
Susan said:
12/27 Update: So for each of 14 sections I now have a form that
includes a List Box populated by the table that is basically a Table
of Contents. It includes the subject matter and a FilePath field.
I've added a "Go to It" control to the form, the Macro for which has
me stumped. First I say to Open Table. Then I say RunApp but I don't
know how to write the line that says to go to the highlighted record
and follow the Hyperlink.
Click to expand...

You do not need to open a table (ever). Your ListBox should contain the path in
a hidden column (as long as it will be less than 255 characters). Your button
code (no macros) would be like...

Application.FollowHyperlink Me.ListBoxName.Column(n)

....where n is the number of the column containing the path (column numbers start
at zero).
A secondary question is that I don't want everyone able to edit the
WORD document - just myself and the Laboratory Manager. What started
me thinking about this was Daniel's reference to the document showing
up in the word editor. How do I make the documents read only, except
for key people?
Click to expand...

That can be handled by network permissions. If you only give people read only
permissions to the folder and all files then that is all they will be able to do
(unless they make a copy).
 
Susan said:
Rick: Do I feel stupid or what!!!! I created the control button and
wrote as code Application.FollowHyperlink Me.ListBoxList8.Column4.
The response is "Compile error: Method or data member not found."
I've double tested the pathway via "run" on Windows 95 and it works.
But I'm obviously missing something from your response earlier this
AM - for which I give you three gold stars for incredible patience.
Susan
Click to expand...

Application.FollowHyperlink Me.ListBoxList8.Column(4)

The parenthesis are required.
 
Rick: So I put the parentheses in, and now I hit the command button and
absolutely nothing happens. No error message, no nothing. I think I best take
the day off from this and attend to the regular work I'm usually doing. Then
I'll go back and tackle it this weekend when the hospital is quiet.
Meanwhile, have a great New Years and accept my gratitude for your patience
with someone who's obviously in way over her head. I'll let you know as soon
as I finally get the damned thing to work. I'm so close I can taste it - but
no cigars yet! Susan
 
Back
Top