By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,276 Members | 1,951 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,276 IT Pros & Developers. It's quick & easy.

How to open browser from link in Access

P: n/a
I'm hoping someone can tell me what I'm missing about how to open a browser
and go to a website from a button or a link in Access 2000.

I've tried designating a field as "Hyperlink type" and typing in an URL.
I've tried using the Hyperlink field on the Button Properties sheet, and
I've tried using Visual Basic:

Application.FollowHyperlink "html://www.websitename.com",,True

and in all cases, Access just locks up and has to be shut down via the task
manager.

I suspect I need to open an instance of the browser or something, but I'm
only just starting with VB (all learned on a "need to know" basis), so I'm a
little foggy on that.

More details, in case they are helpful: What I'm wanting to do is go to a
vendor's website and look up their description based on their part number. I
thought I would build the url based on the first part of the vendor's search
string (stored with the vendor record) concatenated with the part number
(stored on the part record). There are hundreds of parts, so I'd like to
build this hyperlink on the fly, probably using a button and concatenating
the URL in Visual Basic.

I appreciate any assistance or direction....

Alice
--
Book collecting terms illustrated. Occasional books for sale.
http://www.mywingsbooks.com/
Nov 23 '05 #1
Share this Question
Share on Google+
12 Replies


P: n/a
Maybe this is just a typo

Maybe it's you problem

Application.FollowHyperlink "http://www.websitename.com",,True

Nov 23 '05 #2

P: n/a

"lylefair" <ly***********@aim.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
Maybe this is just a typo

Maybe it's you problem

Application.FollowHyperlink "http://www.websitename.com",,True


I'm not sure I understand. The website isn't real...that was just an example
to show what I did in the code. Was there some other typo you saw?

Thanks.

Alice
Nov 23 '05 #3

P: n/a
You wrote html:// rather than http://.

Nov 23 '05 #4

P: n/a

"lylefair" <ly***********@aim.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
You wrote html:// rather than http://.


Ah...so I did. Well, that was just a typo. Probably resulting from
frustration at not being able to get anything to work!

Alice
Nov 23 '05 #5

P: n/a
Then give us a REAL address so that we can try to get IT to work.

For instance this works here in Canader.

Application.FollowHyperlink "http://www.ffdba.com", , True

Nov 23 '05 #6

P: n/a

"lylefair" <ly***********@aim.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
Then give us a REAL address so that we can try to get IT to work.

For instance this works here in Canader.

Application.FollowHyperlink "http://www.ffdba.com", , True

Sorry...wasn't trying to be difficult. Here is my complete code, attached to
the button named btnVendorDesc with the OnClick event and using the website
you suggested:

Private Sub btnVendorDesc_Click()
Application.FollowHyperlink "http://www.ffdba.com", , True
End Sub

Nothing happens. Access just locks up, and I have to close it with the
windows task manager. I know I have to be missing something simple, but I
just don't know what it is.

Any suggestions?

Thanks...
Alice

Nov 23 '05 #7

P: n/a
Not really. I think we need help here.
I think Applciation.FollowHyperlink uses Internet Explorer rather than
the default browser so if there were anything wrong with your IE that
would probably cause a problem.
And who knows if there is some other code problem that might be brought
up by this call; I expect you've tried doing a compile, perhaps even a
decompile first?
And today, firewalls and anti-viruses and internet-security can shut
down almost anything.
But I expect we have to wait for someone who has had this problem to
speak up.

Nov 23 '05 #8

P: n/a

"lylefair" <ly***********@aim.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
Not really. I think we need help here.
I think Applciation.FollowHyperlink uses Internet Explorer rather than
the default browser so if there were anything wrong with your IE that
would probably cause a problem.
And who knows if there is some other code problem that might be brought
up by this call; I expect you've tried doing a compile, perhaps even a
decompile first?
And today, firewalls and anti-viruses and internet-security can shut
down almost anything.
But I expect we have to wait for someone who has had this problem to
speak up.


Well, IE is my default browser, so that's not the problem. The browser just
isn't launching at all. I know there are a thousand things that could be
preventing this from working...hopefully someone has one of those helpful
debugging links to the MS website....

Alice
Nov 23 '05 #9

P: n/a
Have you tried

WebBrowser.Navigate2 "http://www.websitename.com"

replacing above "WebBrowser" with the name of your control? Or with
substitution something like

WebBrowser.Navigate2 "http://" & vendorURL & partNUM & Me.OpenArgs

my-wings wrote:
I'm hoping someone can tell me what I'm missing about how to open a browser
and go to a website from a button or a link in Access 2000.

I've tried designating a field as "Hyperlink type" and typing in an URL.
I've tried using the Hyperlink field on the Button Properties sheet, and
I've tried using Visual Basic:

Application.FollowHyperlink "html://www.websitename.com",,True

and in all cases, Access just locks up and has to be shut down via the task
manager.

I suspect I need to open an instance of the browser or something, but I'm
only just starting with VB (all learned on a "need to know" basis), so I'm a
little foggy on that.

More details, in case they are helpful: What I'm wanting to do is go to a
vendor's website and look up their description based on their part number. I
thought I would build the url based on the first part of the vendor's search
string (stored with the vendor record) concatenated with the part number
(stored on the part record). There are hundreds of parts, so I'd like to
build this hyperlink on the fly, probably using a button and concatenating
the URL in Visual Basic.

I appreciate any assistance or direction....

Alice

Nov 23 '05 #10

P: n/a
Me!YourButtonName.HyperlinkAddress = http://www.YourWebSite.com/index.htm

That one works for me.

dixie

"my-wings" <my******@TAKEOUTatt.net> wrote in message
news:P7*******************@bgtnsc05-news.ops.worldnet.att.net...
I'm hoping someone can tell me what I'm missing about how to open a
browser and go to a website from a button or a link in Access 2000.

I've tried designating a field as "Hyperlink type" and typing in an URL.
I've tried using the Hyperlink field on the Button Properties sheet, and
I've tried using Visual Basic:

Application.FollowHyperlink "html://www.websitename.com",,True

and in all cases, Access just locks up and has to be shut down via the
task manager.

I suspect I need to open an instance of the browser or something, but I'm
only just starting with VB (all learned on a "need to know" basis), so I'm
a little foggy on that.

More details, in case they are helpful: What I'm wanting to do is go to a
vendor's website and look up their description based on their part number.
I thought I would build the url based on the first part of the vendor's
search string (stored with the vendor record) concatenated with the part
number (stored on the part record). There are hundreds of parts, so I'd
like to build this hyperlink on the fly, probably using a button and
concatenating the URL in Visual Basic.

I appreciate any assistance or direction....

Alice
--
Book collecting terms illustrated. Occasional books for sale.
http://www.mywingsbooks.com/

Nov 23 '05 #11

P: n/a
I might need to expand on that previous post. In the buttons On Click
event, type =set_my_link()
Now, in the form module, add the following.

Private Function set_my_link()
Me!YourButtonName.HyperlinkAddress = http://www.YourWebSite.com/index.htm
End Function

That should work for that address.

dixie

"Dixie" <di***@dogmail.com> wrote in message
news:43********@duster.adelaide.on.net...
Me!YourButtonName.HyperlinkAddress = http://www.YourWebSite.com/index.htm

That one works for me.

dixie

"my-wings" <my******@TAKEOUTatt.net> wrote in message
news:P7*******************@bgtnsc05-news.ops.worldnet.att.net...
I'm hoping someone can tell me what I'm missing about how to open a
browser and go to a website from a button or a link in Access 2000.

I've tried designating a field as "Hyperlink type" and typing in an URL.
I've tried using the Hyperlink field on the Button Properties sheet, and
I've tried using Visual Basic:

Application.FollowHyperlink "html://www.websitename.com",,True

and in all cases, Access just locks up and has to be shut down via the
task manager.

I suspect I need to open an instance of the browser or something, but I'm
only just starting with VB (all learned on a "need to know" basis), so
I'm a little foggy on that.

More details, in case they are helpful: What I'm wanting to do is go to a
vendor's website and look up their description based on their part
number. I thought I would build the url based on the first part of the
vendor's search string (stored with the vendor record) concatenated with
the part number (stored on the part record). There are hundreds of parts,
so I'd like to build this hyperlink on the fly, probably using a button
and concatenating the URL in Visual Basic.

I appreciate any assistance or direction....

Alice
--
Book collecting terms illustrated. Occasional books for sale.
http://www.mywingsbooks.com/


Nov 23 '05 #12

P: n/a
Thanks to everyone for their help. It WAS a simple solution, and lylefair
had it right.... it was my firewall, which used to tell me when it was
blocking a new application, but doesn't seem to do so after the last update.

Sorry to have taken up everyone's time...the solution was on my own PC after
all!

Alice
"Dixie" <di***@dogmail.com> wrote in message
news:43********@duster.adelaide.on.net...
Me!YourButtonName.HyperlinkAddress = http://www.YourWebSite.com/index.htm

That one works for me.

dixie

"my-wings" <my******@TAKEOUTatt.net> wrote in message
news:P7*******************@bgtnsc05-news.ops.worldnet.att.net...
I'm hoping someone can tell me what I'm missing about how to open a
browser and go to a website from a button or a link in Access 2000.

I've tried designating a field as "Hyperlink type" and typing in an URL.
I've tried using the Hyperlink field on the Button Properties sheet, and
I've tried using Visual Basic:

Application.FollowHyperlink "html://www.websitename.com",,True

and in all cases, Access just locks up and has to be shut down via the
task manager.

I suspect I need to open an instance of the browser or something, but I'm
only just starting with VB (all learned on a "need to know" basis), so
I'm a little foggy on that.

More details, in case they are helpful: What I'm wanting to do is go to a
vendor's website and look up their description based on their part
number. I thought I would build the url based on the first part of the
vendor's search string (stored with the vendor record) concatenated with
the part number (stored on the part record). There are hundreds of parts,
so I'd like to build this hyperlink on the fly, probably using a button
and concatenating the URL in Visual Basic.

I appreciate any assistance or direction....

Alice
--
Book collecting terms illustrated. Occasional books for sale.
http://www.mywingsbooks.com/


Nov 23 '05 #13

This discussion thread is closed

Replies have been disabled for this discussion.