Trying something new and having issues

[Dave14867]

Hello all,



I am creating a new database and want to have a set up form where the user can select an image to use as the background for all of the forms and also put in a company name that will appear on the forms and reports. I don't know how to set that up and be able to tell it using VB that the image and company name needs to set the properties of each.

Does that make sense?

Thanks in Advance
Dave

[isladogs]

The easiest method is probably to have a settings table where the company name and image path will be stored as text.
Then use a template form as the basis for each form where
1. The company name is obtained using a DLookup in a textbox.
2. The image control source uses another DLookup
Or create a function for each that does the DLookup.
BUT I would advise using a small image control rather than having a background image for the form.
A large background image will probably need to be a large file or the quality may be poor.
If so, the form may be slow to load.

By using a template form as your starting point for all your forms you only need to write the code once

[Dave14867]

isladogs,

Thanks, I'll give that a try

Dave