Solved

How to edit hyperlink in runtime (Access 2007)?

Posted on 2010-09-10
5
1,217 Views
Last Modified: 2013-11-27
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
Comment
Question by:notpandora
  • 3
  • 2
5 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33646722
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
 

Author Comment

by:notpandora
ID: 33646828
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
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
ID: 33647468
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
 

Author Closing Comment

by:notpandora
ID: 33652561
Thanks Jeff, got it working in the end. Thanks again...fc
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33667487
;-)
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question