Using .bmp files

[UT227]

I'm trying to make a simple way for the user to enter pictures. I found that Access will allow OLE with .bmp files. I make a system defaults table to hold the information so that different forms and reports can use the information. However, when I try to use the DLOOKUP to use the .bmp files, it won't bring it into the form I'm trying to bring it into. Is there a way to do this?

[ranman256]

You wouldn't DLOOKUP, you'd open the form directly, via the key.
docmd.openForm "myForm",,,"[id]=" & me.ID

the form would have the image on it.

[UT227]

Open the form directly? I want the system defaults to stay in the background. I only want to call up the pictures embedded into the table to use in other forms.

[ranman256]

The form shows the picture. You can't see pictures in a table.

[UT227]

I'm not quite following. I shouldn't do a DLOOKUP. Which means I need to have the form open to get the value from that form. I did tried to get the picture from the form while open (=Forms![SystemDefaults]![Logo4]) Even with the form open, it didn't pull up the picture. The form it's on is called [SystemDefaults]. The field name is {logo4].

[AccessPower]

How many images are being used and what is the criteria that causes them to change. There may be a simpler way to do this.

[UT227]

I created a default table [tblSystemDefaults]. I made a a form for it [frmSystemDefaults]. I made simple entries (Name, address, phone, etc.) I have 4 pictures and 4 captions for each.

[AccessPower]

So why not do this for your setup

tblSystemDefaults:
FullName
Address
Phone
ImageGroup

tblImageGroups:
jncImageGroup (related to the table above)
GroupImage (Attachment field that stores an image)

Now you can set your records so that they display the required group image. OLE is an older technology, so use attachment fields.