I like the sound of that! I only have 5 pictures so far
and they are slow to load.

I want to try it! I created a new text field (FilePath) in
table Animals. My file path for the 1st picture is
C:\My Documents\My Pictures\Dog1
so I enter the above path in the Animals table, FilePath
field for Dog1's record. Correct? Do I need the file
path in quotes?

How do I create an unbound image control on the form? I
see the tool bar offers "image", "unbound object frame"
and a "bound object frame"- all of which want me to select
the image now. What am I missing to get an unbound image
control?

I'm confused about: Me.Image7.Picture = Me!FilePath
Does Image7 mean something? Is that the name of your
image in the record? If so, how does the record know
which picture to show for which record- must be by the
file path name...

You said "When you click the image control, the user
browses to the picture they want to assign to the current
record."- that sounds cool! So I set up the unbound image
control once in the table and then the user gets to choose
the picture, so that the user is never in the table-
correct? That would be excellent!

Thanks for the guidance!
Michelle

-----Original Message-----
I used to have an ID badge database that stored the
digital pictures in an
OLE field. There was an OLE control on the form which,
when clicked, would
let you browse to select the file. With only 100 or so
employee records, the
database bloated to over 200Mb. I have since modified
the database to get
rid of the OLE field and control. I'm now storing the
path to the picture
in a text field called FilePath and the database is under
200Kb. I've got
an unbound image control on the form, and in the form's
OnCurrent event I
have:

Me.Image7.Picture = Me!FilePath

which will change the picture to match the picture you
assigned to the
current record. When you click the image control, the
user browses to the
picture they want to assign to the current record. It
works with both JPG
and BMP files.

"Michelle" wrote in
message
...
Sorry about that!
I have form that I want to show a digital camera
picture.
I have the table field set up as an OLE Object.

Can I load the picture from the form, or do I need to go
to the table, find the correct record for the field,
select Insert object and the browse to the correct
digital
camera picture? There's got to be an easier way for
end-
users!

I see that bitmap is an option, but my digital camera
pictures are jpg. How do I upload these?

Thanks,
Mich


.