Logos stored in database

  • Thread starter Thread starter Jac Tremblay
  • Start date Start date
J

Jac Tremblay

Hi,
I know that one should not store images in a database. I read all the posts
about the question and the related links. But the Access 2007 application I
am trying to develop is special. I need to use 6 small logos to identify some
special orders.
There will never be more than 6 and the logos are big like an icon on a
toolbar (that is very small).
I designed a logo table with an IdLogo, NameLogo and ImageLogo.
I designed a form to insert and display the logos. That works fine.
Now, I created a new form that is supposed to allow me to link a logo to a
specific order. This simple form contains a list of the orders to select from
and a combo of the available logos (Id an Name). When the user selects a logo
from the combo, a field calle txtIdLogo if filled with the correspnding
IdLogo. Now, I want the image to be displayed as well in a field called
ImgLogo. I can't get it to work.
I tried to set the imgLogo Control source to
=DLookUp([ImageLogo];[tblLogo];[IdLogo]=[me].[IdLogo])
but nothing shows up.
What do I do wrong? What can I do?
Thanks for any help.
 
I wrote a DLookup function to get the image from the database but I do not
how nor where to use it. It is not possible to set the Control Source of an
Image Control through VBA. What can I do?

In the Row Source property of an image control, I get an error (too long!)...

The function goes like this:
DLookup("[tblLogo]![ImageLogo]", "[tblLogo]", _
"[tblLogo]![IdLogo] = " & CInt(Me.txtIdLogo))

Thanks
 
Back
Top