How does one call up embedded hyperlink in a table

[hmachan]

Please share code for this:

The hyperlink to a word.doc file is embedded as field of record in a table.

I would like to be able to call up or activate that hypelink from a form with the end of opening the word.doc file.

thanks in advance...

 

[llkhoutx]

Use Access "Word Automation" it's widely documented.

 

[hmachan]

thanks for the reply llkhoutx....

however, what i need is how to activate / call up from a form, via a command button, a hyperlink that is embedded in a hyperlink field of a record in, say, table "A", that is not the database default of the form, say table "B", but the record in table "A" is related to the one on the form by customer code...

the hyperlinks in table "A" are linked to a quite lengthy word.docs

im not sure if im making any sense describing what the problem is.... id really appreciate any help...

many thanks.

 

[llkhoutx]

You're making perfect sense.

Like I said, "WORD AUTOMATION" is what you're looking for.

I have some code in a program at home. I'll send it this evening.

 

[llkhoutx]

My code was several computers ago and I couldn't find it.

Try this.

 

[jhillbh]

HMACHAN, I had to do something close to this except open an .exe. I couldn't use VBA to to it directly from the command button, so i used a hidden text box(Hyperlink) that had;

=DLookUp("[YourColumn]","YourTable","YourTable.[FieldNeededToMatch]=" & [FieldNeedToMatch])

Then in the ClickEvent of the Button I used;
Dim sFileName As String
sFileName = [Hyperlink]
If IsNull(sFileName) Then 'MsgBox "Sorry, Base Rate not Set Up!", vbOKOnly'
Else
Application.FollowHyperlink sFileName
End If

Hopefully that leads you in the right direction.

 

[hmachan]

THANK YOU SO MUCH JHILLBH...

With a few edits the code worked welll....

many many thanks...