How to open browser from link in Access

[my-wings]

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/

[lylefair]

Maybe this is just a typo

Maybe it's you problem

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

[my-wings]

"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

[lylefair]

You wrote html:// rather than http://.

[my-wings]

"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

[lylefair]

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

[my-wings]

"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

[lylefair]

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.

[my-wings]

"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

[mike noel]

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

[Dixie]

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/

[Dixie]

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/

[my-wings]

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/