Is there a way in Access 2007 using vba to export or save the attachment files from a field that has field type "Attachment" to a hard drive location? The file type is always jpg.
I have form where the user selects the record which contains the following fields...
item name
item description
price
category1
attachment (jpg image)
I need to export the record information into a txt file (i dont need help with that part) and i need to save (ideally ftp the jpg image to the web server). If i can at least save the image to a hard drive location, i can then run a script to upload it via ftp. Hope this is enough info.
ASKER