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

Hyperlinks to IE won't open

P: n/a
I have a wierd problem that I can't find any reference to in the
knowledge base. I develop simple databases at the company where I
work, and many of them are used by hundreds of employees. We all have
the same basic computers with the same base image. The problem is,
whenever I create a hyperlink object in the database, I'm able to
click on it from my PC and it works just fine. All other users click
on it and Access just sits there with the busy hourglass. If they
manually open IE, then Access will follow the hyperlink as intended.
Does anyone have any suggestions as to why this is happening?

This is the code I'm using to create a hyperlink in one DB. (This is
an intranet address, but it initiates an IE redirect page prior to
loading the actual P&ID requested. Also, if I just have it create a
link to http://www.google.com it does the same thing.)

Private Sub cmdCreateHyperlink_Click()
Me.PIDHyperlink = Me.Description &
"#http:\\ecdtexweb\TEX\OSQuery.asp?partid=" & Me.PartID & "#"
End Sub

I just don't understand why it works fine on my machine and won't work
on anyone else's (very similar) machine???
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
John Warner wrote:
I have a wierd problem that I can't find any reference to in the
knowledge base. I develop simple databases at the company where I
work, and many of them are used by hundreds of employees. We all have
the same basic computers with the same base image. The problem is,
whenever I create a hyperlink object in the database, I'm able to
click on it from my PC and it works just fine. All other users click
on it and Access just sits there with the busy hourglass. If they
manually open IE, then Access will follow the hyperlink as intended.
Does anyone have any suggestions as to why this is happening?

This is the code I'm using to create a hyperlink in one DB. (This is
an intranet address, but it initiates an IE redirect page prior to
loading the actual P&ID requested. Also, if I just have it create a
link to http://www.google.com it does the same thing.)

Private Sub cmdCreateHyperlink_Click()
Me.PIDHyperlink = Me.Description &
"#http:\\ecdtexweb\TEX\OSQuery.asp?partid=" & Me.PartID & "#"
End Sub

I just don't understand why it works fine on my machine and won't work
on anyone else's (very similar) machine???


What happens if you add a hyperlink on their machine. Does it work on
theirs and not on yours?

Hmmm...I opened up Word and entered http://www.google.com. I
double-clicked on it. I was asked if I wanted to allow this program to
access the internet. I said No. So I could not access it. I then
reopened Word and it again asked me if I wanted to access the internet.
I said Yes and I went to Google. Maybe these other folks have a
firewall set up that doesn't allow access to initiate the call.
Nov 13 '05 #2

P: n/a
Salad <oi*@vinegar.com> wrote in message news:<2E***************@newsread3.news.pas.earthli nk.net>...
John Warner wrote:
I have a wierd problem that I can't find any reference to in the
knowledge base. I develop simple databases at the company where I
work, and many of them are used by hundreds of employees. We all have
the same basic computers with the same base image. The problem is,
whenever I create a hyperlink object in the database, I'm able to
click on it from my PC and it works just fine. All other users click
on it and Access just sits there with the busy hourglass. If they
manually open IE, then Access will follow the hyperlink as intended.
Does anyone have any suggestions as to why this is happening?

This is the code I'm using to create a hyperlink in one DB. (This is
an intranet address, but it initiates an IE redirect page prior to
loading the actual P&ID requested. Also, if I just have it create a
link to http://www.google.com it does the same thing.)

Private Sub cmdCreateHyperlink_Click()
Me.PIDHyperlink = Me.Description &
"#http:\\ecdtexweb\TEX\OSQuery.asp?partid=" & Me.PartID & "#"
End Sub

I just don't understand why it works fine on my machine and won't work
on anyone else's (very similar) machine???


What happens if you add a hyperlink on their machine. Does it work on
theirs and not on yours?

Hmmm...I opened up Word and entered http://www.google.com. I
double-clicked on it. I was asked if I wanted to allow this program to
access the internet. I said No. So I could not access it. I then
reopened Word and it again asked me if I wanted to access the internet.
I said Yes and I went to Google. Maybe these other folks have a
firewall set up that doesn't allow access to initiate the call.


All of the computers share the same firewall settings, and as users,
we are not allowed to change them. Also, they are not getting prompts
to allow internet access. Access just sits there with the busy
hourglass and does nothing on their machines. Once they manually open
an instance of IE, it works as it should. There must be some setting
somewhere that controls this behavior, but I have no idea what it is.
Nov 13 '05 #3

P: n/a
This is just an idea:

Use the shell command to open IE. You can probably pass a link in with
that or if you cant use the shell followed by your code that works
after they have manually opened IE.

Lincoln
Sydney

pr*****@gmail.com (John Warner) wrote in message news:<30**************************@posting.google. com>...
Salad <oi*@vinegar.com> wrote in message news:<2E***************@newsread3.news.pas.earthli nk.net>...
John Warner wrote:
I have a wierd problem that I can't find any reference to in the
knowledge base. I develop simple databases at the company where I
work, and many of them are used by hundreds of employees. We all have
the same basic computers with the same base image. The problem is,
whenever I create a hyperlink object in the database, I'm able to
click on it from my PC and it works just fine. All other users click
on it and Access just sits there with the busy hourglass. If they
manually open IE, then Access will follow the hyperlink as intended.
Does anyone have any suggestions as to why this is happening?

This is the code I'm using to create a hyperlink in one DB. (This is
an intranet address, but it initiates an IE redirect page prior to
loading the actual P&ID requested. Also, if I just have it create a
link to http://www.google.com it does the same thing.)

Private Sub cmdCreateHyperlink_Click()
Me.PIDHyperlink = Me.Description &
"#http:\\ecdtexweb\TEX\OSQuery.asp?partid=" & Me.PartID & "#"
End Sub

I just don't understand why it works fine on my machine and won't work
on anyone else's (very similar) machine???


What happens if you add a hyperlink on their machine. Does it work on
theirs and not on yours?

Hmmm...I opened up Word and entered http://www.google.com. I
double-clicked on it. I was asked if I wanted to allow this program to
access the internet. I said No. So I could not access it. I then
reopened Word and it again asked me if I wanted to access the internet.
I said Yes and I went to Google. Maybe these other folks have a
firewall set up that doesn't allow access to initiate the call.


All of the computers share the same firewall settings, and as users,
we are not allowed to change them. Also, they are not getting prompts
to allow internet access. Access just sits there with the busy
hourglass and does nothing on their machines. Once they manually open
an instance of IE, it works as it should. There must be some setting
somewhere that controls this behavior, but I have no idea what it is.

Nov 13 '05 #4

P: n/a
I've done that on another database I built, and it works fine. The
problem is, it's just more code to deal with, and I'm really curious
why the hyperlinks won't open as intended on anyone's PC but mine.
There shouldn't be anything on my PC that's fundamentally different
from anyone else's here at the plant, so what works on mine should
work on theirs.
I'm wondering if it has to do with the fact that the db was developed
on my PC. That shouldn't affect it, but that's the only real
difference I can see.

us@yours.com (Jack) wrote in message news:<8e**************************@posting.google. com>...
This is just an idea:

Use the shell command to open IE. You can probably pass a link in with
that or if you cant use the shell followed by your code that works
after they have manually opened IE.

Lincoln
Sydney

pr*****@gmail.com (John Warner) wrote in message news:<30**************************@posting.google. com>...
Salad <oi*@vinegar.com> wrote in message news:<2E***************@newsread3.news.pas.earthli nk.net>...
John Warner wrote:

> I have a wierd problem that I can't find any reference to in the
> knowledge base. I develop simple databases at the company where I
> work, and many of them are used by hundreds of employees. We all have
> the same basic computers with the same base image. The problem is,
> whenever I create a hyperlink object in the database, I'm able to
> click on it from my PC and it works just fine. All other users click
> on it and Access just sits there with the busy hourglass. If they
> manually open IE, then Access will follow the hyperlink as intended.
> Does anyone have any suggestions as to why this is happening?
>
> This is the code I'm using to create a hyperlink in one DB. (This is
> an intranet address, but it initiates an IE redirect page prior to
> loading the actual P&ID requested. Also, if I just have it create a
> link to http://www.google.com it does the same thing.)
>
> Private Sub cmdCreateHyperlink_Click()
> Me.PIDHyperlink = Me.Description &
> "#http:\\ecdtexweb\TEX\OSQuery.asp?partid=" & Me.PartID & "#"
> End Sub
>
> I just don't understand why it works fine on my machine and won't work
> on anyone else's (very similar) machine???

What happens if you add a hyperlink on their machine. Does it work on
theirs and not on yours?

Hmmm...I opened up Word and entered http://www.google.com. I
double-clicked on it. I was asked if I wanted to allow this program to
access the internet. I said No. So I could not access it. I then
reopened Word and it again asked me if I wanted to access the internet.
I said Yes and I went to Google. Maybe these other folks have a
firewall set up that doesn't allow access to initiate the call.


All of the computers share the same firewall settings, and as users,
we are not allowed to change them. Also, they are not getting prompts
to allow internet access. Access just sits there with the busy
hourglass and does nothing on their machines. Once they manually open
an instance of IE, it works as it should. There must be some setting
somewhere that controls this behavior, but I have no idea what it is.

Nov 13 '05 #5

P: n/a
Well, I finally figured out the problem. Our company sets up our
computers with an automatic configuration script in IE. The first
thing I do when I get a new computer or a new image is disable this
script (It slows IE down). I disabled it on another user's PC and the
hyperlink worked as intended.
Thanks for the replies.

pr*****@gmail.com (John Warner) wrote in message news:<30**************************@posting.google. com>...
I've done that on another database I built, and it works fine. The
problem is, it's just more code to deal with, and I'm really curious
why the hyperlinks won't open as intended on anyone's PC but mine.
There shouldn't be anything on my PC that's fundamentally different
from anyone else's here at the plant, so what works on mine should
work on theirs.
I'm wondering if it has to do with the fact that the db was developed
on my PC. That shouldn't affect it, but that's the only real
difference I can see.

us@yours.com (Jack) wrote in message news:<8e**************************@posting.google. com>...
This is just an idea:

Use the shell command to open IE. You can probably pass a link in with
that or if you cant use the shell followed by your code that works
after they have manually opened IE.

Lincoln
Sydney

pr*****@gmail.com (John Warner) wrote in message news:<30**************************@posting.google. com>...
Salad <oi*@vinegar.com> wrote in message news:<2E***************@newsread3.news.pas.earthli nk.net>...
> John Warner wrote:
>
> > I have a wierd problem that I can't find any reference to in the
> > knowledge base. I develop simple databases at the company where I
> > work, and many of them are used by hundreds of employees. We all have
> > the same basic computers with the same base image. The problem is,
> > whenever I create a hyperlink object in the database, I'm able to
> > click on it from my PC and it works just fine. All other users click
> > on it and Access just sits there with the busy hourglass. If they
> > manually open IE, then Access will follow the hyperlink as intended.
> > Does anyone have any suggestions as to why this is happening?
> >
> > This is the code I'm using to create a hyperlink in one DB. (This is
> > an intranet address, but it initiates an IE redirect page prior to
> > loading the actual P&ID requested. Also, if I just have it create a
> > link to http://www.google.com it does the same thing.)
> >
> > Private Sub cmdCreateHyperlink_Click()
> > Me.PIDHyperlink = Me.Description &
> > "#http:\\ecdtexweb\TEX\OSQuery.asp?partid=" & Me.PartID & "#"
> > End Sub
> >
> > I just don't understand why it works fine on my machine and won't work
> > on anyone else's (very similar) machine???
>
> What happens if you add a hyperlink on their machine. Does it work on
> theirs and not on yours?
>
> Hmmm...I opened up Word and entered http://www.google.com. I
> double-clicked on it. I was asked if I wanted to allow this program to
> access the internet. I said No. So I could not access it. I then
> reopened Word and it again asked me if I wanted to access the internet.
> I said Yes and I went to Google. Maybe these other folks have a
> firewall set up that doesn't allow access to initiate the call.

All of the computers share the same firewall settings, and as users,
we are not allowed to change them. Also, they are not getting prompts
to allow internet access. Access just sits there with the busy
hourglass and does nothing on their machines. Once they manually open
an instance of IE, it works as it should. There must be some setting
somewhere that controls this behavior, but I have no idea what it is.

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.