Open pdf or tif file from Access 2003 Form

[Dave Couch]

I want to be able to dbl-click on a field that shows a file name, tif or pdf,
and go to that file and open it the same as you would do if you dbl-clicked a
file in Windows explorer. The entire file name would consist of 2 fields,
the folder and the file name. Any help would be greatly appreciated.

 

[mscertified]

Ifd you make it a hyperlink to the full path of the file, it will open with
whatever program is registered to open that file extension.

-Dorian

 

[fredg]

I want to be able to dbl-click on a field that shows a file name, tif or pdf,
and go to that file and open it the same as you would do if you dbl-clicked a
file in Windows explorer. The entire file name would consist of 2 fields,
the folder and the file name. Any help would be greatly appreciated.

Does the Pathfile field include a final backslash character, i.e.
"c:\MyFolder\"?
Does the FileName field include the file type extension, i.e.
"FileName.pdf"?

If Yes on both, code the Double-click event of either or both
controls:
Application.FollowHyperlink [PathFileControl] & [FileNameControl]

If it does not include that final backslash and/or the extension,
then:
Application.FollowHyperlink [PathFileControl] & "\" &
[FileNameControl] & ".pdf"

 

[Dave Couch]

Fred, thanks very much for the help. That was exactly what I was looking
for. After a number of times correcting my typos, it worked perfectly.

I want to be able to dbl-click on a field that shows a file name, tif or pdf,
and go to that file and open it the same as you would do if you dbl-clicked a
file in Windows explorer. The entire file name would consist of 2 fields,
the folder and the file name. Any help would be greatly appreciated.

Does the Pathfile field include a final backslash character, i.e.
"c:\MyFolder\"?
Does the FileName field include the file type extension, i.e.
"FileName.pdf"?

If Yes on both, code the Double-click event of either or both
controls:
Application.FollowHyperlink [PathFileControl] & [FileNameControl]

If it does not include that final backslash and/or the extension,
then:
Application.FollowHyperlink [PathFileControl] & "\" &
[FileNameControl] & ".pdf"

 

[Dave Couch]

Fred, thanks again for the previous info. Now I am trying to do the same
thing from a sub-form. I have the references for the file name and location,
but I think I need to reference the form that the fields are in. The problem
is, I don't know the syntax for referencing the form name. The form name is
"frmCountySearch" and the field names are "filelocation" and filename". They
contain the slashes needed for the paths. Can you show me the correct
syntax?? It would be much appreciated.

I want to be able to dbl-click on a field that shows a file name, tif or pdf,
and go to that file and open it the same as you would do if you dbl-clicked a
file in Windows explorer. The entire file name would consist of 2 fields,
the folder and the file name. Any help would be greatly appreciated.

Does the Pathfile field include a final backslash character, i.e.
"c:\MyFolder\"?
Does the FileName field include the file type extension, i.e.
"FileName.pdf"?

If Yes on both, code the Double-click event of either or both
controls:
Application.FollowHyperlink [PathFileControl] & [FileNameControl]

If it does not include that final backslash and/or the extension,
then:
Application.FollowHyperlink [PathFileControl] & "\" &
[FileNameControl] & ".pdf"