Solved

Microsoft Access 2010 Question

Posted on 2016-10-21
2
74 Views
Last Modified: 2016-10-21
How do I launch IE with a URL from Text field by Macro?
0
Comment
Question by:Hiroyuki Tamura
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 250 total points
ID: 41854049
you don't need a macro to open a URL, all you need to do is change the Data type of your Text field to Hyperlink
1
 
LVL 35

Assisted Solution

by:PatHartman
PatHartman earned 250 total points
ID: 41854062
I avoid the "Access" only data types.  If you use them, you will not be able to upsize without converting them to standard data types and all the code and query changes that entails.

Use the FollowHyperlink method.  It works on a text field that contains the name of a website or the full path to any file as long as the file extension is known to Windows.  So the same instruction can open a .jpg, doc, .docx,, .xlsx,  Http://, etc.

The FollowHyperlink method may or may not be a macro action.  If it isn't, it is only a single line of VBA and intellisense will help you build it.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

776 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