A
AccessReportWriter
I posted the following question in the Reports Section on 5/6 but it was
never responded to -- perhaps I did not correctly ask the question.
I write custom reports for an accounting program which is now in the 2007
Format. In order to keep the size of the report database low I create a
Table called Image, and then place various Images in this table which are
then referred to on various reports using a DLookUp. This method has worked
very well; however I normally convert .jpg or .gif images to .bmp images
before storing them in the table. I would like to use the Attachement
Property but am having problems:
My standard DLookUp: =DLookUp("[Image]","[Image]","[Num]=1")
However, if i use the Attachement Property, instead of the image printing on
the report I get the file name such as LogoImage.jpg. Does my DLookUp have
to be altered to pull an Image when using the Attachment Property?
Because I am not in control of Table Design I am unable to relate the Images
Table to any other Tables; I am also unable to to add the Image Table to a
Query because there are no related fields -- this i why I use a DLookUp.
never responded to -- perhaps I did not correctly ask the question.
I write custom reports for an accounting program which is now in the 2007
Format. In order to keep the size of the report database low I create a
Table called Image, and then place various Images in this table which are
then referred to on various reports using a DLookUp. This method has worked
very well; however I normally convert .jpg or .gif images to .bmp images
before storing them in the table. I would like to use the Attachement
Property but am having problems:
My standard DLookUp: =DLookUp("[Image]","[Image]","[Num]=1")
However, if i use the Attachement Property, instead of the image printing on
the report I get the file name such as LogoImage.jpg. Does my DLookUp have
to be altered to pull an Image when using the Attachment Property?
Because I am not in control of Table Design I am unable to relate the Images
Table to any other Tables; I am also unable to to add the Image Table to a
Query because there are no related fields -- this i why I use a DLookUp.