Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 125
  • Last Modified:

Microsoft Access 2010 Question

How do I launch IE with a URL from Text field by Macro?
0
Hiroyuki Tamura
Asked:
Hiroyuki Tamura
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
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
 
PatHartmanCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now