Logos stored in database

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.
 
J

Jac Tremblay

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
 

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

Top