473,657 Members | 2,450 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Hyperlinks to IE won't open

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 cmdCreateHyperl ink_Click()
Me.PIDHyperlink = Me.Description &
"#http:\\ecdtex web\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
5 3773
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 cmdCreateHyperl ink_Click()
Me.PIDHyperlink = Me.Description &
"#http:\\ecdtex web\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
Salad <oi*@vinegar.co m> wrote in message news:<2E******* ********@newsre ad3.news.pas.ea rthlink.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 cmdCreateHyperl ink_Click()
Me.PIDHyperlink = Me.Description &
"#http:\\ecdtex web\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
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.c om (John Warner) wrote in message news:<30******* *************** ****@posting.go ogle.com>...
Salad <oi*@vinegar.co m> wrote in message news:<2E******* ********@newsre ad3.news.pas.ea rthlink.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 cmdCreateHyperl ink_Click()
Me.PIDHyperlink = Me.Description &
"#http:\\ecdtex web\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
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.go ogle.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.c om (John Warner) wrote in message news:<30******* *************** ****@posting.go ogle.com>...
Salad <oi*@vinegar.co m> wrote in message news:<2E******* ********@newsre ad3.news.pas.ea rthlink.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 cmdCreateHyperl ink_Click()
> Me.PIDHyperlink = Me.Description &
> "#http:\\ecdtex web\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
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.c om (John Warner) wrote in message news:<30******* *************** ****@posting.go ogle.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.go ogle.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.c om (John Warner) wrote in message news:<30******* *************** ****@posting.go ogle.com>...
Salad <oi*@vinegar.co m> wrote in message news:<2E******* ********@newsre ad3.news.pas.ea rthlink.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 cmdCreateHyperl ink_Click()
> > Me.PIDHyperlink = Me.Description &
> > "#http:\\ecdtex web\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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
6148
by: scoop_77 | last post by:
I'm looking for some software that would allow me to point to a folder in Windows Explorer, and have it output an html file with hyperlinks to all of the files within that folder and all of the sub-folders. I have many folders with several dozen files and sub-folders and would like to avoid hand-coding all of the hyperlinks. Does anyone know if such software exists? Thanks in advance.
9
2668
by: middletree | last post by:
I have a page which takes data in an HTML table, and exports it to an Excel file. It works fine, but I want several things about the spreadsheet to look different from the HTML version. Things like fonts and colors. I think I can use a style sheet for the latter, but I haven't figured out how to remove hyperlinks from some of the items. On the HTML page, the hyperlinks are useful, but I don't want the spreadsheet to have them. So on my...
6
3952
by: Colleyville Alan | last post by:
I have an application that has an Access table that stores the locations of slides in a Powerpoint file. This used to work fine when there were about 4 files and 200 slides. The database would open all four PPT files at once, and would loop through queriers for ever client and create custom presentations. Now there are 8 files, nearly 500 slides and the computer is bogging down with trying to open them all at once. I know that Access...
1
4935
by: Darryl Neale | last post by:
I have been tasked with reviving an old database that stopped working about 3 years ago :( On one of the tabs is a list of links to other databases utilising the Hyperlink feature of MS Access and one of the problems with this database is that all these files moved to new locations when a big server "move round" occured about a month ago. Whenever i right click the button that opens the page and select "Edit Hyperlink" i get a new...
1
7931
by: Tom | last post by:
I have a project database in which I use hyperlinks to call up various related supporting documents (e.g., proposals, contracts, reports, site photos, etc.). The documentes are in Word, Excel, PDF and JPG formats and are all stored in a documents subfolder on my computer. I use a form with several Hyperlink text boxes (one for each type of document) which are bound to a table that stores the hyperlinks. I want the text box to respond to...
5
1458
by: Patrick.O.Ige | last post by:
What are the best ways to hide hyperlinks from visitors? Any ideas
1
3638
by: Janna | last post by:
Hello tech savvy gurus! I hope someone can help me! THE PROBLEM: "Cannot open specified file" when I click on a hyperlink in an Access database when it is located on our server. THE BACKGROUND: I created a folder "Document Library" on my local drive, which contains document sub-folders and the database. For referential integrity, I designed the database with relative hyperlinks (e.g. Folder\File.pdf). The hyperlinks worked perfectly...
3
1923
by: =?Utf-8?B?UmlkZ2V3YXk=?= | last post by:
I am using PowerPoint 2000 with a very large presentation with many Hyperlinks, mostly to other slides but many also to Internet links. Recently, some of them are not working. I correct them on the live presentation and get them to work then, when saved and re-loaded the same ones do not work again. I wonder, is there a maxiumum of hyperlinks allowed which I have perhaps exceeded? If so, can I increase this and if so, how?
92
5127
by: Erwin Moller | last post by:
Hi group, I encoutered page validation error, but I don't know a way around. The page has the following doctype: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> Some hyperlinks need to open to a new window, so I used the (wrong) target="" attribute.
0
8421
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8325
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8742
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8518
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8621
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6177
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5643
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4330
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2743
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.