how to paste a hyper link on a form

[john_gringo]

Hi!
I am new to access and my knowlege are limited and I am facing a probleme.
I have an access DB for a small company. I have an order table and an order form. I receive my orders by FAX on my PC as an image and I want to link each image with each order on the table.
I create a field in my table as a hyper link called FAXlink and also an text box caill FAXlink on my order form thinking that I could drag and drop the image on that text box as I do on a cell at excell. But I can't just Drag and drop an image on that text box is there other way to do it.
Please be as specific such I am not a programmer.

Regards

Jiannis
Access 2007

 

[apr pillai]

1. Right-Click on the HyperLink field (not on the text field).
2. Place the mouse pointer on the Hyperlink option on the shortcut menu.
3. Select Edit Hyperlink from the displayed options.
4. You may browse to the location of the file from the Look in: control and select the file.
5. Type a suitable discreption in the Text to Display control.
6. Click OK to insert the selected File's hyperlink in the field.

You cannot drag and drop a file into this field.

 

[Simon_MT]

If name the Faxfile the same as the Order then you can referentially access the Fax.

Function GetFaxPath()
    With CodeContextObject
        GetFaxPath = GetFaxDir & .[FaxFile]
    End With
End Function

Function GetFaxExist()
        If Dir(GetFaxPath) <> Empty Then
            GetFaxExist = -1
        Else
            GetFaxExist = 0
        End If
End Function

Function GetFaxPicture()
    With CodeContextObject
        If GetFaxExist = True Then
            .[ImageControl].Visible = True
            .[ImageControl].Picture = GetFaxPath
        Else
            .[ImageControl].Visible = False
        End If
    End With
End Function

Simon