Re: Cannot run a file from Access
- From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
- Date: Fri, 11 May 2007 07:07:01 -0400
\DIR\File.pdf isn't a complete reference to a file. You need either a drive
letter, or a \\server\share in front of that.
If you're trying to get to a subfolder of the folder the database is in,
try:
Application.FollowHyperlink CurrentProject.Path & "\DIR\File.pdf"
(Realistically, I'm surprised it worked in Access 97: you should have been
using FollowHyperlink there as well: Shell is only intended for executables)
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Ja" <jallen@xxxxxxxxxxxxx> wrote in message
news:eZlDt56kHHA.4516@xxxxxxxxxxxxxxxxxxxxxxx
I've converted a database from 97 to 2003 - it comes up with an error -
file
not found when i use shell "\DIR\File.pdf"
.
- Follow-Ups:
- Re: Cannot run a file from Access
- From: David W. Fenton
- Re: Cannot run a file from Access
- References:
- Cannot run a file from Access
- From: Ja
- Cannot run a file from Access
- Prev by Date: Re: contains missing reference OWC10.DLL
- Next by Date: from excel to access - a specific question
- Previous by thread: Re: Cannot run a file from Access
- Next by thread: Re: Cannot run a file from Access
- Index(es):
Relevant Pages
|
Loading