A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hyperlink datatype



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2010, 06:59 PM posted to microsoft.public.access.tablesdbdesign
Trini Gal
external usenet poster
 
Posts: 20
Default Hyperlink datatype

Hello,

I'm not sure if what I'm doing is right because my user keeps getting the
error "Unable to open V:...... .pdf. Cannot open the specified file."


My database is still Access 2003, I haven't upgraded it yet because I was
only recently upgraded to Access 2007. I have listed our systems and the
annual testing results in .pdf format (hyperlink datatype in the table). I
have given the users read only access to where the files are stored and have
listed it as a trusted location. I would like when they click on the system
ID, the report opens up and they are able to print.

My user keeps getting the above reference table.

Can someone let me know why this is happening please?

Thanks.

  #2  
Old June 1st, 2010, 10:56 PM posted to microsoft.public.access.tablesdbdesign
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Hyperlink datatype

See if this helps:
http://allenbrowne.com/func-GoHyperlink.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Trini Gal" wrote in message
...
Hello,

I'm not sure if what I'm doing is right because my user keeps getting the
error "Unable to open V:...... .pdf. Cannot open the specified file."


My database is still Access 2003, I haven't upgraded it yet because I was
only recently upgraded to Access 2007. I have listed our systems and the
annual testing results in .pdf format (hyperlink datatype in the table).
I
have given the users read only access to where the files are stored and
have
listed it as a trusted location. I would like when they click on the
system
ID, the report opens up and they are able to print.

My user keeps getting the above reference table.

Can someone let me know why this is happening please?

Thanks.



  #3  
Old June 2nd, 2010, 03:38 PM posted to microsoft.public.access.tablesdbdesign
Trini Gal
external usenet poster
 
Posts: 20
Default Hyperlink datatype

Hello Jeanette,

Thanks for your reply. After posting I found that information and tried it.
I have the following code on the On Click Event:

Private Sub Ctl2009_REPORT_Click()

Call GoHyperlink(Me.[Ctl2009_REPORT])

End Sub
When I click on the link I get a Microsoft Office Access Security Notice "A
potential security concern has been identified. Do you want to continue?" I
click "Yes" and get another error GoHyperlink() "Error 490: Cannot open the
specified file." I click "Ok" and then the file opens.

This is the first time I'm attempting this, what am I doing or not doing?

Thanks,



"Jeanette Cunningham" wrote:

See if this helps:
http://allenbrowne.com/func-GoHyperlink.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Trini Gal" wrote in message
...
Hello,

I'm not sure if what I'm doing is right because my user keeps getting the
error "Unable to open V:...... .pdf. Cannot open the specified file."


My database is still Access 2003, I haven't upgraded it yet because I was
only recently upgraded to Access 2007. I have listed our systems and the
annual testing results in .pdf format (hyperlink datatype in the table).
I
have given the users read only access to where the files are stored and
have
listed it as a trusted location. I would like when they click on the
system
ID, the report opens up and they are able to print.

My user keeps getting the above reference table.

Can someone let me know why this is happening please?

Thanks.



.

  #4  
Old June 2nd, 2010, 04:48 PM posted to microsoft.public.access.tablesdbdesign
Trini Gal
external usenet poster
 
Posts: 20
Default Hyperlink datatype

I updated teh code to:


Private Sub Ctl2009_REPORT_Click()

Dim myFile As String
myFile = Ctl2009_REPORT.Value

Call GoHyperlink("V:\Engineering\_Data\Engineering\FCC-CLI-320 Info\2009
Filings\FCC Form 320 Reports\" & myFile)

End Sub

Still getting the error.


"Trini Gal" wrote:

Hello Jeanette,

Thanks for your reply. After posting I found that information and tried it.
I have the following code on the On Click Event:

Private Sub Ctl2009_REPORT_Click()

Call GoHyperlink(Me.[Ctl2009_REPORT])

End Sub
When I click on the link I get a Microsoft Office Access Security Notice "A
potential security concern has been identified. Do you want to continue?" I
click "Yes" and get another error GoHyperlink() "Error 490: Cannot open the
specified file." I click "Ok" and then the file opens.

This is the first time I'm attempting this, what am I doing or not doing?

Thanks,



"Jeanette Cunningham" wrote:

See if this helps:
http://allenbrowne.com/func-GoHyperlink.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Trini Gal" wrote in message
...
Hello,

I'm not sure if what I'm doing is right because my user keeps getting the
error "Unable to open V:...... .pdf. Cannot open the specified file."


My database is still Access 2003, I haven't upgraded it yet because I was
only recently upgraded to Access 2007. I have listed our systems and the
annual testing results in .pdf format (hyperlink datatype in the table).
I
have given the users read only access to where the files are stored and
have
listed it as a trusted location. I would like when they click on the
system
ID, the report opens up and they are able to print.

My user keeps getting the above reference table.

Can someone let me know why this is happening please?

Thanks.



.

  #5  
Old June 2nd, 2010, 10:43 PM posted to microsoft.public.access.tablesdbdesign
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Hyperlink datatype

I avoid using hyperlink data types as I have had similar experiences.
I store the file name in one field and the path in another field.

When I want to open the file, I concatenate the path with the file name and
use the shell execute api instead to open files.

Here is a link to shell execute api
http://www.mvps.org/access/api/api0018.htm


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Trini Gal" wrote in message
...
Hello Jeanette,

Thanks for your reply. After posting I found that information and tried
it.
I have the following code on the On Click Event:

Private Sub Ctl2009_REPORT_Click()

Call GoHyperlink(Me.[Ctl2009_REPORT])

End Sub
When I click on the link I get a Microsoft Office Access Security Notice
"A
potential security concern has been identified. Do you want to continue?"
I
click "Yes" and get another error GoHyperlink() "Error 490: Cannot open
the
specified file." I click "Ok" and then the file opens.

This is the first time I'm attempting this, what am I doing or not doing?

Thanks,



"Jeanette Cunningham" wrote:

See if this helps:
http://allenbrowne.com/func-GoHyperlink.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Trini Gal" wrote in message
...
Hello,

I'm not sure if what I'm doing is right because my user keeps getting
the
error "Unable to open V:...... .pdf. Cannot open the specified file."


My database is still Access 2003, I haven't upgraded it yet because I
was
only recently upgraded to Access 2007. I have listed our systems and
the
annual testing results in .pdf format (hyperlink datatype in the
table).
I
have given the users read only access to where the files are stored and
have
listed it as a trusted location. I would like when they click on the
system
ID, the report opens up and they are able to print.

My user keeps getting the above reference table.

Can someone let me know why this is happening please?

Thanks.



.



  #6  
Old May 21st, 2011, 06:19 PM
Jim Griggs Jim Griggs is offline
Member
 
First recorded activity by OfficeFrustration: May 2011
Posts: 1
Arrow

We hyperlink thousands of PDFs without problem. A couple of things to note:
1. If the PDF filename in the Access field has spaces, you need to search and replace the spaces with %20.
2. You need to insure that the files are not moved from the original directory and that the directory is not renamed.
3. There are two programs available from pcmag.com that will help with bulk entry of hyperlinks. FileGrab (create a list of all PDFs in a directory) and MultiRename. You have to subscribe to pcmag.com downloads for $20 but well worth it.

Hope this helps

Jim


Quote:
Originally Posted by Trini Gal View Post
Hello,

I'm not sure if what I'm doing is right because my user keeps getting the
error "Unable to open V:...... .pdf. Cannot open the specified file."


My database is still Access 2003, I haven't upgraded it yet because I was
only recently upgraded to Access 2007. I have listed our systems and the
annual testing results in .pdf format (hyperlink datatype in the table). I
have given the users read only access to where the files are stored and have
listed it as a trusted location. I would like when they click on the system
ID, the report opens up and they are able to print.

My user keeps getting the above reference table.

Can someone let me know why this is happening please?

Thanks.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.