Edit Hyperlink Properties in Access Runtime (1 Viewer)

[mjm01]

I have an Access database that is accessed by users via Access Runtime (2000) over Citrix ie user do not have the full Access 2000 client installed on thier PCs.

I want to be able to create a hyperlink field on a form that links to files on the network based on the user input.

I can achieve this via a full Access client by:

- create a hperlink field
- open the form to edit
- type a decription into the field
- right click on the description and select EDIT - HYPERLINK
- specify file type and location

However, in the Runtime environment, there is no right click menu available


Is there any way to achieve the desired results in this case?

Mark M

 

[mjm01]

Anyone ??

 

[epiek]

I would also like to know!!

 

[Simon_MT]

You could create a dialog box with an unbound to change the hyperlink with an Change Button and update the hyperlink with the edited information on the Dialog Box.

Simon

 

[epiek]

Thanks for the reply. How do I go about this?

 

[Simon_MT]

Create a new Form:

Function Hyperlink_Edit()
        
    With CodeContextObject
        DoCmd.OpenForm "New_Form_Name", acNormal, , , acFormEdit, acWindowNormal
        Forms![New_Form_Name]![H_Link] = .[H_Link]
    End With
End Function

Then an Accept Button

Function H_Link_Accept()

    With CodeContextObject
        If IsNull(.[H_Link]) Then
            DoCmd.GoToControl "Close"
            Exit Function
        End If
            Forms![Original_Form_Name]![H_Link] = .[H_Link]
            DoCmd.Close acForm, "New_Form_Name"
        End If
    End With
End Function

Here is something to play with

Simon

 

[epiek]

Thanks a lot for this!