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.Fol lowHyperlink "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.Fol lowHyperlink "http://www.websitename .com",,True

[my-wings]

"lylefair" <ly***********@ aim.com> wrote in message
news:11******** **************@ g44g2000cwa.goo glegroups.com.. .

Maybe this is just a typo

Maybe it's you problem

Application.Fol lowHyperlink "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.goo glegroups.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.Fol lowHyperlink "http://www.ffdba.com", , True

[my-wings]

"lylefair" <ly***********@ aim.com> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.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.Fol lowHyperlink "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_C lick()
Application.Fol lowHyperlink "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.Fol lowHyperlink 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******** *************@g 43g2000cwa.goog legroups.com...

Not really. I think we need help here.
I think Applciation.Fol lowHyperlink 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...hopef ully someone has one of those helpful
debugging links to the MS website....

Alice

[mike noel]

Have you tried

WebBrowser.Navi gate2 "http://www.websitename .com"

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

WebBrowser.Navi gate2 "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.Fol lowHyperlink "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