Launching URLs from an MS-Access Table

I have a table, that I've built within Access 2013.  One of the fields contains a URL, that I've built, but when I click on it, it doesn't link.   It is basically a URL+ UPC code but the browser doesn't launch when clicking the link.  Is there a security setting I'm overlooking?
LVL 1
James PowellData Analyst / Online Retail DevelopmentAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kelvin SparksCommented:
Why are you interacting at a table level. You should do this at a form level, where you set an event to follow the link.


Kelvin
Dale FyeOwner, Dev-Soln LLCCommented:
agree with Kelvin.

Actually, I hate the hyperlink datatype in Access and never use it.  It makes it virtually impossible to edit in a textbox.  I prefer to store the link as text in a field defined as a text data type.  Then, I will put a command button next to the textbox on the form and use the click event of the command button and the Application.FollowHyperlink method to go to the URL.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BanthorCommented:
Both of the previous comments are on target. You can create a form that appears as a table but includes the button. Further you can embed a browser control on the form render the content on a control inside of the access application.

Other possibilities are that you can download the content into an object and parse that content for specific values and present only the desired information.

What are you trying to accomplish?
Get Blueprints for Increased Customer Retention

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

JLankfordIT Data AnalystCommented:
I tested this in both Access 2010 and 2013 and can confirm it works without having to adjust any settings/options. My 2013 instance was a completely new install on a new OS install as well. It works as expected; when I open a table and click on a hyperlink in a data column defined as a hyperlink data type, it opens my default browser to the URL as expected.

What happens when you click on a hyperlink in Word or Outlook? Does it open your default browser?

James
BanthorCommented:
Affirmative
James PowellData Analyst / Online Retail DevelopmentAuthor Commented:
Thanks all!  I'm going to try it.
Ultimately I'd prefer to use a "hyperlink" field type if possible.

Here's what I'm trying to do.
I have a field of UPC #.
I'm trying to concatenate those into a new field, similar to:  http://www.Anyplace.com/=UPC#

I've tested the "logic" of building that, and it works.

However, the resulting new field,  I can not click on.

If I subsequently go into the individual field on any given record, and do an F2 edit.
Backspace over one character, and replace it again....boom, the link works.

I'd rather just drop that field on my form, and have the link work, as that's just easiest for me.  If the program doesn't work as it should...that's another story...but just clicking on that link doesn't launch my browser.
Dale FyeOwner, Dev-Soln LLCCommented:
I think it all goes back to this:

"It is basically a URL+ UPC code"

unless your URL is defined appropriately to take you to a specific page, it is going to fail.

If you copy the value in this field and paste it in the URL line of your browser, does it take you where you expect it to?  Actually, that might not quite work, because hyperlink fields add a bunch of fluff around the actual URL, so you will need to cut all of that fluff out before attempting this.
Dale FyeOwner, Dev-Soln LLCCommented:
I think you will find if you use the FollowHyperlink method in the click event of a command button or something like that, you can build that new URL in your code and it will work just fine.
James PowellData Analyst / Online Retail DevelopmentAuthor Commented:
The cut and past of the new contents of the field, absolutely works, even with all the "fluff", which I've replicated, with no problem.

The text appears as a blue, underlined, link within the table, but clicking on it, does NOT launch the browser.  Making a single character edit to any individual line in that column...THEN, clicking the link launches the browser.
James PowellData Analyst / Online Retail DevelopmentAuthor Commented:
Thanks for the help all!  You got me on the right path.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.