Link a Word Document to Access

S

Shep99

I have a database that i want to include user help notes. I want to have an
option on the Menu which if clicked, will open up my word document (user
notes).

I know how to add a new function to the switchboard but not sure how to link
'Word' document to the database

Any idea's?

I have gone into the switchboard and gone into the option i want to edit e.g.
'help'

I have gone into command and the only options i have are:

Go to Switchboard
Open form in add mode
open form in edit mode
open report
design application
exit application
run macro
run code

Which option do i select?

Thanks
 
F

FinRazel

I don't know exactly what you should do at this point, but here is some
general information that might help:

Open your form in design view, Highlight the Detail area (if that is where
you want your link to appear) Then, click Insert -> Hyperlink->edit
hyperlink. This opens the Insert Hyperlink window, where you can find and
highlight your help Word Document. The hyperlink will appear in the upper
left-hand corner of your form. Now, move it where you want.
 
F

fredg

I have a database that i want to include user help notes. I want to have an
option on the Menu which if clicked, will open up my word document (user
notes).

I know how to add a new function to the switchboard but not sure how to link
'Word' document to the database

Any idea's?

I have gone into the switchboard and gone into the option i want to edit e.g.
'help'

I have gone into command and the only options i have are:

Go to Switchboard
Open form in add mode
open form in edit mode
open report
design application
exit application
run macro
run code

Which option do i select?

Thanks
Click to expand...

You are using the built in Switchboard manager which greatly limits
your options and control over what you want it to do. A better
solution would be to create your own switchboard using unbound forms
and command buttons.

To do what you want using your existing switchboard, first create a
new Module.
Click on Module in the Main database window.
Select New.
When the window opens, click on Insert.
Select Procedure
Write:
GetWord
in the Name dialog box.
Select Sub.
Click OK

Then write between the 2 already existing lines of code:
Application.FollowHyperlink "c:\FolderName\DocumentName.doc"

Note: Change "c:\FolderName\DocumentName.doc" to whatever the actual
path and document names are. Keep the quotes.

Save the code and name the module mdlWordDoc

Then open the switchboard manager and edit the switchboard to
Run Code
Write
GetWord
in the dialog box.
Save the change
That should be all you need do.

It's a long way around for a simple procedure.
 
Top