running windows/start/run from within access

  • Thread starter Thread starter jeff
  • Start date Start date
J

jeff

I have been unable to open linked tiff image files in
access any version under WinXP. Is there a macro or code
within access that will start the windows-start-run
program. then i can simply enter the path and the image
will open. Thanks.
 
You can launch any file from word, to excel, to a .tif file by using:


Application.FollowHyperlink "c:\your path\test.tif"

The above should work for any application you want to launch....
 
Thank you very much Albert! You have been extremely
helpful and I appreciate it. The only hurdle that now
remains is one final message box under Microsoft Office
heading warning that "some files can contain
viruses...etc". This is probably only related to tiff
files because i don't think it happens with other image
files. also it only happens with winxp not win 98. Is
there a way to turn it off? Thanks again for all your help.
 
Probably just best to browse to any old .tiff file, and then double click on
it. I don't know what image viewer you have. I would think in the options
for that viewer there is some way to disable the msg. Since you are taking
about a new XP box, then it might even be the general secirty settings for
the browser, but I am not 100% sure.

It is certainly something that you can't control from ms-access anyway....
 
Back
Top