creating Automatic Hyperlink

[zachir]

I'm trying to create automatic hyperlink in a Form Control "hyper" - TextBox.
The control source of the "hyper" control is a Table field with Hyperlink DataType.
The files should be addressed from the hyperlinks are scanned PDF files of invoices.
The invoices are stored in a specific folder "h:\invoices".


Files are named with the "payment instruction no." which is also a table field And a Form control in tha same Form.
The hyperlink address has a prefix which is actualy the folder name "h:\invoices".
How can i create automatic hyperlink that is stored in the "hyper" control & filed from the prefix & "payment instruction no."?

Regards,
Zachi

[rpeare]

So you're trying to open an external file by building a string that will tell you the path/name of the file? or are you trying to display the contents of the file within your access application?

so let's say this is the file you want to open

h:\invoices\Instruction100000.pdf

so to open that file I'd do this in the ON CLICK (button would work fine)

Dim wshshell

Set wshshell = CreateObject("WScript.Shell")
wshshell.Run """h:\invoices\instruction100000.pdf"""
Set wshshell = Nothing

You just have to substitute in your file name on the fly for instance

Dim wshshell
Dim sFile As String

sFile = [FieldWithPath] & [FieldWithPaymentInstructionName] & ".pdf"

Set wshshell = CreateObject("WScript.Shell")
wshshell.Run "" & sFile & ""
Set wshshell = Nothing