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??? 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.
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.
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.
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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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.
|
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...
|
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...
|
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...
|
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...
| |
by: Patrick.O.Ige |
last post by:
What are the best ways to hide hyperlinks from visitors?
Any ideas
|
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...
|
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?
|
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.
|
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...
|
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,...
| |
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...
|
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,...
|
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...
|
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...
|
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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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
| |