MS Access - Display hyperlink target within a form...

Posted on 2003-02-27
Medium Priority
Last Modified: 2008-02-01
How can I make the target of a hyperlink display within a form?
Question by:jimcochran
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
  • 3
  • 2

Expert Comment

ID: 8036187
When drawing the form, choose any text, right click it and choose properties. In properties, one of the first ones is Hyperlink address. Type the webpage that you want, and you can do it from there.

To go to another webpage through the link, do the same thing, but type it under Hyperlink subaddress.

The last possibility is that there is a variable type hyperlink that you can use.


Author Comment

ID: 8036921
My orginal question may have been too ambiguous,or I may not be understanding your comment, Eric.  If its the latter, apologies up front...

I currently do have a hyperlink field in my table, and that field does appear on the form.  Also, I do understand how to embed a hyperlink address/subaddress into a text box.

Here's where I need help.  I want the target of the above hyperlink to display on the form.  The target in this case is a web page.  I want the actual web page to be visible on the form.

How do I make that happen?



Expert Comment

ID: 8041683
Well, in the help files for MS-Access 2000, I found this, but I don't have the time to test it.

Display a Web page on a form
Before you can add the Microsoft Web Browser control to a form, you must have Microsoft Internet Explorer version 3.0 or later installed. Learn about installing Microsoft Internet Explorer.

Open the form in Design view.

In the toolbox, click the More Controls tool .
A menu appears that lists all the registered ActiveX controls in your system.

On the menu of ActiveX controls, click Microsoft Web Browser.

On the form, click where you want to place the control.

Move and size the control if necessary.

I used a similar object with VisualC++, and found that you can actually imbed most windows objects in your web page, such as media player, or windows explorer.

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!


Author Comment

ID: 8041874
I have embedded the Microsoft Web Browser control before, but I do not know how to get it to display the url.  Do you have to create a Macro or VB?  That would be info needed to answer the question.


Accepted Solution

Bruce Cadiz earned 680 total points
ID: 8042680
After you add your ActiveX control (Microsoft Web Browser) create a button and give it the following code.
You could easily modiy this to be a select box the reads the URL text from your table.

Private Sub Command1_Click()
Me.ActiveXCtl1.Navigate "http://www.experts-exchange.com/"
End Sub

Author Comment

ID: 8059330
Thanks!  That's exactly what I needed.

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

764 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