Hyperlink datatype
in [Tables]
|
From: Trini Gal on 1 Jun 2010 13:59 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.
From: Jeanette Cunningham on 1 Jun 2010 17:56 See if this helps: http://allenbrowne.com/func-GoHyperlink.html Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Trini Gal" <TriniGal(a)discussions.microsoft.com> wrote in message news:B0844186-40D3-4765-9C0A-CAC5DD9E61A4(a)microsoft.com... > 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. >
From: Trini Gal on 2 Jun 2010 10:38 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" <TriniGal(a)discussions.microsoft.com> wrote in message > news:B0844186-40D3-4765-9C0A-CAC5DD9E61A4(a)microsoft.com... > > 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. > > > > > . >
From: Trini Gal on 2 Jun 2010 11:48 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" <TriniGal(a)discussions.microsoft.com> wrote in message > > news:B0844186-40D3-4765-9C0A-CAC5DD9E61A4(a)microsoft.com... > > > 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. > > > > > > > > > . > >
From: Jeanette Cunningham on 2 Jun 2010 17:43 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" <TriniGal(a)discussions.microsoft.com> wrote in message news:1042A524-FC67-4F1E-BABF-3A5646D73092(a)microsoft.com... > 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" <TriniGal(a)discussions.microsoft.com> wrote in message >> news:B0844186-40D3-4765-9C0A-CAC5DD9E61A4(a)microsoft.com... >> > 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. >> > >> >> >> . >>
|
Pages: 1 Prev: Let's pick a replacement for this (Access) newsgroup Next: My database loads but disabled? |