INSERT JPG IN OLE FIELD USING VB

M

MBoozer

Need syntax to insert bmp or jpg into field when code returns True. The bmp
or jpg file should be embedded (small size) and be called from a subdirectory
"pics" located in the directory that teh db is in: Code is:

If Len(Me!SupplierName & "") > 0 Then
Forms![ChemicalInventory].[EditSuppliers].Form!Dot = True
INSERT TRUE.JPG INTO TABLE SUPPLIER OLE FIELD DOTOLE?
Else
Forms![ChemicalInventory].[EditSuppliers].Form!Dot = False
INSERT FALSE.JPG INTO TABLE SUPPLIER OLE FIELD DOTOLE?
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top