I want to display images in a Continuous Form
As has been well discussed in the forums holding the image as an OLE creates massive database bloat it is much better to hold the path to the image and display as required. This however does not work on the on current even on a Continuous Form, as the control is unbound.
My solution to this has been to insert the images to a Temp Table via the continious form this involves a for next loop inserting the images as required using
Me.Image.SourceDoc = Me![ImageFile]
Me.Image.Action = acOLECreateEmbed
(where Me![ImageFile] is the path to the image and Me![ImageFile] is THe bound OLE)
As this does not work when the Continuous Form is in a sub form I would like to append the required images to the temporary table using DAO/ADO
Does anyone know if this is possible; if so do you have a copy of the syntax
Many Thanks
Jimmy
As has been well discussed in the forums holding the image as an OLE creates massive database bloat it is much better to hold the path to the image and display as required. This however does not work on the on current even on a Continuous Form, as the control is unbound.
My solution to this has been to insert the images to a Temp Table via the continious form this involves a for next loop inserting the images as required using
Me.Image.SourceDoc = Me![ImageFile]
Me.Image.Action = acOLECreateEmbed
(where Me![ImageFile] is the path to the image and Me![ImageFile] is THe bound OLE)
As this does not work when the Continuous Form is in a sub form I would like to append the required images to the temporary table using DAO/ADO
Does anyone know if this is possible; if so do you have a copy of the syntax
Many Thanks
Jimmy
