attach and retrieve photographs from an Access or SQL database

[Janis F]

I would like to have photographs available for "cut and
paste" in a report in Microsoft Access or from a database
in SQL server.
Any suggestions?

 

[Arvin Meyer]

I would like to have photographs available for "cut and
paste" in a report in Microsoft Access or from a database
in SQL server.
Any suggestions?

Include an Image control in the report. Add the path to the file you want to
cut and paste in the report in a dialog box which opens the report. Code in
the report would read the path from the dialog box in the open or format
event of the report. Include error handling if there is no path supplied.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access