Access 2007 Attachment Field

A

AccountingLabs

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?
 

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

Similar Threads

Access 2007 Attachment Property / Images on Reports 0
2007 Attachment Property 2
Need to automatically resize pictures in a 2007 access report? 3
Report Image Control 0
Report that should show multiple image attachments only shows one. 0
Images in Grouped Header in A Report 0
Merge image file in Access 2007 attachment field into Word document 1
Lebans CreateBitmapFile 0

Top