Move Images FROM a Table TO a Folder

[Randomblink]

Ok...
I have a Table that has a thousand or so entries.
The purpose of this table is to list out City Owned properties and give basic data on them... (Address, Roofing Structures, etc..)

I built the table to fill-in until they were ready to hire out and have one professionally built. As I am technically just an Office Assistant I really didn't want to build the monster they want built, and since they couldn't contract me to do it (since I was already an employee) well, I put together a half-way and went my merry way.

I built a single table to hold ONE photo per location.
There are approximately 1500 locations listed now.

Well, they have changed their minds and they want a database that will hold roofing photos for each location, monitor the roofing status, as well as give them the sun and the moon in the meantime.

Well, I have realized I could build this (10+ years Access programming experience) AND I have agreed to. They had contractors offering $2500 to build this, because they already had one that they built... they would just customize it for the City. Or that is what I think... I wasn't privy to why they were not selected. ANYWAY!

I am trying to take the table with ALL those photos... one for each location... and run a query. What I want the query to do is:

Open a Record
- If there is a Photo / Image for that location... then...
1) Create a name for the image based on the location site number field in that Table
2) Save the image to a predetermined location on the server using the created name from step 1)
3) Create a link TO that image and put it in another field in the same table

I am wondering if ANYONE has done something like this before? Or what. I think this would probably require VB code versus a pure Query, but I am not sure. All of my work with databases has NOT gone in depth into working with OLE objects and/or images.

If you can help, PLEASE let me know... Thanks in advance

 

[Randomblink]

I found this answer on a Newsgroup

------------------------------------------------------------
You can't easily get them back out as Gif's but you can export the
Images as Bitmaps. You could then use a program like Paint Shop Pro to batch convert them to Gif's or whatever. I just batch converted over 50 files tonight with Paint SHop Pro. Worked the very first time, no mess, no fuss. I like that in a program.

Here is sample code to automate the process of exporting embedded Images to Bitmap files. It loops through every record in the table. Click Here for the main page.
Click Here for the Link to the OLE to Bitmap

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks

------------------------------------------------------------

SO I FOUND A WAY TO MAKE IT HAPPEN!

I had to go to the google Newsgroups search engine... but I did it.

For those of you interested in this tool, he has a newer version that will convert them to JPEG. What you do is

1) open a form
2) press a button and locate the database with the images...
3) Select the table with the images
4) Select the field name that holds the images
5) Select the field that you want to use to name the images
6) Select the folder where you want the images to go
7) Select the compression rate you want to dump the images at
8) Press a button and make it go

It is amazing boys and girls...
Flipped me out...