Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

batch conversion using paint shop pro

Status
Not open for further replies.

macca007

Programmer
May 1, 2004
86
GB
Hi all,

My situation is to convert several images that are tiff from a folder to jpegs. Is it possible in access to call paintshop pro and do this conversion, since paintshop pro has batch processing facility incorporated. If so can anyone provide me with an example so to get me started.

I would like to use this functionality in my access form using a button.

Many thanks
 
This may be possible, but if it were possible, it may / would requrie a lot of work or the purchase of command line graphics conversition utility.

Whereas, you use PhotoEditor or over graphical application to do the same thing with very little fuss or bother.

Mircosoft Access is used for capturing data and reporting information, not converting file types.
 
Take a look at a FreeWare graphics viewer called IrfanView (website URL is
This supports command line options to convert image files.

In Access, you can use the Shell command in VBA, to call an external program and pass parameters to it.

Thus you would be able to:
-- Read a file name from a database record
-- Build a string containing the call to IrfanView and the file name;
-- Call the Shell command and pass this string to it

Using the Dir command in VBA, you can read file names from a folder.

I hope these notes will be of some help.



Bob Stubbs
 
You can use PSP9 to do this.
Create a script performing the conversion you want. Copy the code from faq705-1971 into your database and call it:
Code:
fHandleFile "C:\Path\To\Conversion.pspscript", WIN_NORMAL
and it will open PSP and run your script.

hth

Ben

----------------------------------------------
Ben O'Hara "Where are all the stupid people from...
...And how'd they get so dumb?"
rockband.gif
NoFX-The Decline
----------------------------------------------
Want to get great answers to your Tek-Tips questions? Have a look at F
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top