Avatar of saxophobe60
saxophobe60

asked on 

Save file from Attachment type data field

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.
Microsoft Access

Avatar of undefined
Last Comment
saxophobe60
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of saxophobe60
saxophobe60

ASKER

AWESOME!  that code worked perfectly.  Way better than i expected!
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo