• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1333
  • Last Modified:

How to edit hyperlink in runtime (Access 2007)?

How do I edit a hyperlink in runtime when I have no right mouse click?

Hyperlink is a field that links PDFs located in the same folder as the app.
0
notpandora
Asked:
notpandora
  • 3
  • 2
1 Solution
 
Jeffrey CoachmanCommented:
Edit it how?

You can edit any hyperlink by editing it directly in the table.
In a form, you can Tab into the Hyperlink field and change it.

Or you can do this in a form via code with something like this:

    me.YourHyperlinkControl.SetFocus

;-)

JeffCoachman
0
 
notpandoraAuthor Commented:
In full Access I just right mouse click on the form field and click Hyperlink / Edit Hyperlink and I can browse for the file and link it. In runtime I have no right click so can't access this menu....
0
 
Jeffrey CoachmanCommented:
I try to avoid using these "Access Only" Fields (Hyperlink, OLE, attachment, ...etc)
They will not translate into other formats like SQL server, and they have issues like the on you are having.

Here is a very simple example of what I use to do this.

I am sure you can adapt it to work in your database

;-)

JeffCoachman
Access-EEQ-26464463-LinkedPDFDia.mdb
0
 
notpandoraAuthor Commented:
Thanks Jeff, got it working in the end. Thanks again...fc
0
 
Jeffrey CoachmanCommented:
;-)
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now