Privateer
Registered User.
- Local time
- Yesterday, 23:23
- Joined
- Aug 16, 2011
- Messages
- 193
Years ago, I stored images in an Access table where they were converted to bitmap images. This caused the database to swell to 1.8 gig, just under the maximum of 2 gig. I want to replace these images with files on the hard drive; that process is working fine. To do this, I would like to be able to see the original image so I can replace it with the same one. Once I have the new image, I can delete the bitmap image in the table. Unless I am on that image looking at it, then I can't delete it. That's my problem. So, I would like a way to grab the original image using a record set, assign it to a variable, and assign the variable to the image on the form. This way the original record won't be locked, thus allowing me to delete it.
I have a record set which returns the field with the image, but I can't find the proper data type for the variable to handle an image. After some searching, I created the variable as a variant, and used PictureData on the field. But the code blew up when the transfer was being executed. It looks like this:
Dim PicImg As Variant
PicImg = ![BookCover].PictureData
When it comes to images, I really have no idea what I am doing. Any help would be greatly appreciated. Thanks.
I have a record set which returns the field with the image, but I can't find the proper data type for the variable to handle an image. After some searching, I created the variable as a variant, and used PictureData on the field. But the code blew up when the transfer was being executed. It looks like this:
Dim PicImg As Variant
PicImg = ![BookCover].PictureData
When it comes to images, I really have no idea what I am doing. Any help would be greatly appreciated. Thanks.