Re: Cannot run a file from Access



\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"




.



Relevant Pages

  • Re: Scripting File Library Reference AutoComplete
    ... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... Reference to the Scripting library, and you've declared objFSO As Object, ...
    (microsoft.public.access.modulesdaovba)
  • Re: I just installed Office 2003...
    ... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... Your database or project contains a missing or broken reference to the ...
    (microsoft.public.access.setupconfig)
  • Re: Open .exe file
    ... Try using Shell then. ... "Katrina" wrote in message ... >>Doug Steele, Microsoft Access MVP ... >>(No private e-mails, please) ...
    (microsoft.public.access.modulesdaovba)
  • Re: Microsoft Office 12.0 Object Library Missing
    ... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... However I tried adding the Office 11.0 reference through the browsing ...
    (microsoft.public.access.modulesdaovba)
  • Re: vb access syntax query
    ... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... > use or where I can find reference to it. ...
    (microsoft.public.vb.database)

Loading