pictures as background to forms

[Rick Roberts]

I have several questions regarding the use of pictures as background to forms.

I have 3 unique gifs I would like to use as backgrounds for approx 50+
forms. If I go into each form and embed the appropriate gif for that form the
database size grows and grows. As I only have 3 gifs is there way to “embedâ€
these in the database ONCE and “link†to it?

I am assuming that I must use the picture as the background for the entire
form. What I would really like to do is to be able to use it as the
background for the detail section only. Is there a way to that? Somehow I
doubt it!

I am happy to use the link option for the background to the forms but that
leads to several other questions:

Can I use relative addressing? Specifically relative to the application
path? This will be a FE client and the location of where the FE will be
installed can vary.

When the application opens a form with a linked picture there is a brief
“Importing picture…†message flashed on the screen. Is there a way to
silence this message so that it does not appear (no matter how brief).


Thank you in advance,
Rick

 

[kingston via AccessMonster.com]

Since there are only three GIFs, have you tried creating a table with OLE
object fields? The database size might still be reasonable. You could also
use three main forms and create 50+ sub-forms. HTH.

 

[Rick Roberts]

To any who happen to need the same info...
What worked well for me is the following:

Link all pictures used as background to forms. Make the sure the links are
bitmap files "BMP" otherwise Access will need to import/convert them. If they
are bitmap files there is no "importing" message.

The good: No bloating
The bad: Your link has to have a fully qualified name. I could not get
relative addressing to work. Although if Access can't find the picture it
acts as if none were assigned. Which can be usefull.

I don't believe there is any way to use a background for a section only. It
must be for the whole form.

I hope this helps someone!