DataBase - Windows Photo Viewer

Asked By ulrich1947

12-Nov-09 11:41 AM

Hi, everybody

I want to show a ".jpg" pic in Windows Photo Viewer in Access 2000 by Shell
Command. Now I do it by using

BildErgebnis = Shell("C:\Program Files\IrfanView\i_view32.exe " &
allgKZalph1, 1)

which opens the file (Full Path contained in allgKZalph1) by Irfan View. How
do I change that to have it opened by Photo Viewer? By the way, I use Windows
7.

Anyone can help ? Thanks in advance.

Ulrich

14-Nov-09 03:36 AM

Hi,
try using ShellExecute API:
http://www.mvps.org/access/api/api0018.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

14-Nov-09 07:08 AM

Won't that only work if the jpg file extension has been linked to Windows
Photo Viewer?

To guarantee that Photo Viewer is used, you would  need to replace "C:\Program
Files\IrfanView\i_view32.exe  " in the code below with the full path to
Photo Viewer. Unfortunately, I do not have Photo Viewer installed on this
machine, so I cannot tell you the name of the executable.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

14-Nov-09 09:36 AM

Hi Doug,
you right, I am assuming that jpg linked to photo viewer, like on default
installation

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

14-Nov-09 11:14 AM

Hi, again !
Thanks for trying to help me. jpg file extension is linked to Windows Photo
Viewer. When I click on a files name in the file directory, it uses
automatically that application. So I first tried the command

BildErgebnis = Shell("C:\subLW\ARCHIV\ConSy\Food\303\9377-8.jpg", 1)

but that leads to Error No. 5 (invalid procedure or argument). My problem
is, i do not know any path to Photo Viewer. I cannot find any .exe file in
Windows 7 for it. The only thing I can trace is C:\Program Files\Windows
Photo Viewer\ImagingDevices.exe which is not what I want nor need. (has
something to do with connecting a scanner or cam).

I wonder whether the API Function will work instead. I will try soon.

However, thanks a lot.

Ulrich

29-Dec-09 01:13 PM

you could possibley do it by just going to the folder where the .jpg is and
right clicking it and going to >Open with>Choose Default Program Then it
should be in a list of programs to use.... if it doesnt show up in the list
then you gotta find it the program manually but once again i also do not know
where the .exe is truley located (also have tried to find for different
reasons) so if it doesnt show up in the list I am not sure how to proceed from
there :(