I need add a bitmap into a MS Access database (ver. 7.0) but the vbBinary format is not valid.
How do I add a picture into a record???
Printable View
I need add a bitmap into a MS Access database (ver. 7.0) but the vbBinary format is not valid.
How do I add a picture into a record???
Had similar problem.
Gave up!
In the end elected to store a string of path and file name of image in table. Then used the LoadPicture("path\filename") method to set image.
I have done this storing picture into MS-Access, I hope this would be helpful to you.
creat a OLE1 control into the form.
and create a Command button.
then include
Private Sub Command1_Click()
OLE1.InsertObjDlg
End Sub
Include Datacontrol to the form.
Assume the name Data1
and the Access database has a got field for BITMAP image named "PHOTO" which is of datatype OLE Object
then in the properties of Datacontrol
OLE1.Datasoure = Data1
OLE1.Datafield = PHOTO
You have to create field not with Binary but with OLE Object data type.
Best regards,
------------------
Serge
[email protected]
[email protected]
If you have any questions about AOL programming, e-mail me