[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Access 2003 Hyperlinks in Forms

Posted on 2011-09-06
5
Medium Priority
?
233 Views
Last Modified: 2012-05-12
I'm calculating a hyperlink that gets written to a file being imported into my access table.
The field is of type Hyperlink

I then created text object on the form that points to the hyperlink field.

Clicking on the hyperlink in the form gives me the wonderful satisfaction of having clicked on it, but it doesn't launch IE :)

Can someone give me some additional steps? I'd imagine that the object is not the correct type?
0
Comment
Question by:OnsiteSupport
5 Comments
 
LVL 49

Accepted Solution

by:
Dale Fye earned 1000 total points
ID: 36489334
Try the Followhyperlink method in the click event.

Personally I don't like "hyperlink fields", preferring to store the hyperlink as text and use the Followhyperlink method.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 1000 total points
ID: 36489508
I'm with fyed.

As cool as a "hyperlink Field" sounds, most of what they do can be replicated with a simple text field.

In any event:
<I then created text object on the form that points to the hyperlink field.>
No really clear on what this means, or why it was needed, ...?

But if you create the form using the form wizard, you can select the table that contains the HL field, and the hyperlink field will come into the form automatically, and should work fine when clicked.

So again, I am not sure what you did there with your "Text Field"...?


JeffCoachman
0
 

Author Closing Comment

by:OnsiteSupport
ID: 36529389
Thanks guys.  Follow Hyperlink works.  However, not with Text Field.  It works as expected if the field type is Hyperlink.
0
 
LVL 49

Expert Comment

by:Dale Fye
ID: 36529825
Can you describe what you were doing that it didn't work with a text field?

I usually do one of two things.
1.  add a button to the right of the text box and use the click event do to something like:

Private Sub cmd_Hyper_Click

    application.FollowHyperlink me.txt_URL

End Sub

2.  Use the double-click event of the textbox with similar code.
0
 
LVL 21
ID: 36531116
<<Thanks guys.  Follow Hyperlink works.  However, not with Text Field. >>

I only use text files. I never use the hyperlink data type.

I created an example that may help: Document Links 2
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

830 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