Handling images on forms

[Adrian Jansen]

Access 2002.

I wanted to link a common image file showing a company logo to all the forms
( and reports ) for a project, and so set an image on each form, with the
image source set to the path for an existing bitmap. Since I am using a
temporary image, I set the image type to 'linked', so that when I got the
final logo, I could just replace the temporary image with the real logo, and
all the forms would show the updated image. Sounds good so far..

However, when I deploy the app on a customers machine, the image path I set
while I was designing the form of course doesnt match the new path on the
customers machine(s), so the image wont load. Is there an easy way of
changing the path on all of the forms, on all of the machines ? I tried
just setting the image filename, assuming I could put the image in the same
directory as the app, but that didnt work - the image control seems to need
the full pathname.
I also tried using the 'Find and Replace' utility to change the image source
with a global edit, but that doesnt seem to be able to do it either.

I suppose I could point the image source to a pathname stored in a table,
and grab it during the form load event, but it seems a long-winded way of
doing it.

Any other ideas ?


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Kelvin Lu]

Try creating a table with 1 field set for OLE object. Then insert the
picture into this field. On your forms, set the source for the image to
this table containing the one image. Just update the image in the table
when you get the final iamge. Also, everyone will get the same image.

Kelvin

 

[Adrian Jansen]

Thanks Kelvin,

That sounds good, will try.


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Adrian Jansen]

Access 2002 on Windows 2000

I did notice one rather annoying thing.

I initially just put a bound object frame on a form, and used the dialog box
to link the frame to an image bitmap. BOING ! Complete system reset !

Worked ok when I set the data source to a table field holding the image as
an OLE though.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control