Hi
I have ACCESS 2010 application that, for some reason, had the user paste pictures to a picture box in a db form. A record is crated for each pic.
So now th db has many picutres as part of the db itself, and the size of the db is gone to 2 GB
I need to save/salvage the pasted pictures to a folder and then redesign the app so pictures are recognized via a link to location in a folder
Question:
- Given a access 2010 form that shows an imbedded pictures
- How do I access the picture box via vba and save the picture to the folder as jpeg or png.
- I basicall need the picture object to that I can pass on to folder path for saving
Please advise as best way to do this. An example would be greatly appreciated
Thank