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
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