>>>Howdy Mr. Pikman!
>>>
>>>Here is a description of the environment that I am working in.
>>>
>>>I work on a research project under the anacronym ALERT standing for Advanced Law Enforcement Response Technology. If you would like to learn more about this project you are welcome to go to our web page at:
>>>http://alert.tamu.edu.
>>>
>>>My task is to produce the software applictaions that will run on the officers workstation. These include law enforcement information(LEI) queries, gps mapping, e-messaging, and last but not least databases. Of these tasks I am creating the LEI and databases and integrating the other applications.
>>>
>>>Citation or any relevant data is entered on a handheld computer and saved as an access database and seperate .bmp images. Digital images are also captured from a Kodack camera and associated with the record. The images are captured signature images and notes that the officer may make. These files are transfered via wireless communications to the vehicle. Then the vehicle sends that information back to the base computer where I import the information, images and all. The need arose to export the images for legal and insurance purposes thus I need to extract select images.
>>>
>>>While they are in one of my forms viewing the images they may hit a button that will bring up a save as prompt. When they decide upon a filename then hit save as, I call the code that you have provided. Unfortunately I have not had any success at opening the .fpt file. After the file is saved 'filename.fpt' I rename it to 'filename.bmp' but am not able to open it with paintbrush, etc.
>>>
>>>I hope that this is enough background information for you. Oh, my programming experience is as follows:
>>>2 years MS Access Database - single user application.
>>>1 year MS Visual Basic
>>>2 months VFP.
>>>
>>>Here again is the code snippet that I am using.
>>>
>>>SELECT citations
>>>SET ORDER TO citation_n
>>>CitationNumber = INT(VAL(CitationNumber))
>>>SEEK CitationNumber
>>>COPY FIELD citation_images_signature NEXT 1 TO &Filename
>>>
>>>Once again thank you for your time and advice, it is nice to know that there are people who help struggling programmers.
>>>
>>>David Kappler
>>
>>Hi, David.
>>
>>I tested this case and found that MS Paintbrush really doesn't recognize fpt file as bitmap. As you remember, I used specific OCX to do this job, and you could proceed this way too. However, I guess you could avoid this (OCX is expensive enough) and store just bmp file names in VFP tables (the same way as you do this in Access).
>
>
>Howdy Mr. Pikman!
>
>Thanks for the information. If you don't mind, what OCX are you using and how easy is it to use? If it works with all image formats, it will necessary for me to purchase it. I unfortunately do not have the option to store just the links in the database. Thank you for all of your help thus far.

I got imaging experience working with Lead Techology OCX. You can check their website (www.leadtools.com) for more information.