?
Solved

Access 2003 Hyperlinks in Forms

Posted on 2011-09-06
5
Medium Priority
?
226 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 48

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 48

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

770 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