Change the colour of the background

[danielgraham]

How do i change the background of the access database.

 

[sparx]

Are you trying to change the background of a form??

 

[Kevin_S]

Daniel -

If you are trying to change the background of the application (It is the standard grey background you see behind the forms/db window/etc.) then you can use the example posted on Stephen Lebans site to change the background to a different color or even set it as a bitmap image. It works really good and is even deployable so it will go with the application when you deploy it (some other options are for your machine only and have to be set on each machine)

Link:
http://www.lebans.com/changemdibackground.htm

HTH,
Kev

 

[kybb1]

hmmmm

I've recently tried this very same sample, and I know I'm the dummy here, but.....

it works great...until you close and re-open it. Once you re-open it, the image or color needs to be reloaded all over again.

Again, I'm probably the dummy here.

 

[Kevin_S]

kybb1 -

You have to import the modules in the sample into your db and then set up your db's splash form (if you have one or your start up form) to call the module with the correct requirements (be it color or bitmap) - if bitmap you have to include it in with your program...

HTH,
Kev

 

[ghudson]

You need to reload your background option each time the db is opened. I use the OnOpen event of my main form to do this. I posted a sample db a couple of weeks ago using Lebans code when I want to change the background color of the Access application near the bottom of this thread...

changebackgroundcolor.zip

HTH

 

[kybb1]

OK....

Well after much reading of the code....I was able to determine how to make the image stay in the db. Very easily accomplished (once all the reading was done) and only cuz I'm new to classing...at any rate....

Once you've imported all the mod's and classes into your current project do the following. (There isn't any need in calling the dialog in the SetMDIBackGroundImage.)

In the ChangeMidi mod:

In the section --SetMDIBackGroundImage, Dim the Image Name as a string (i.e. strImageName as String) .

In the section--If Len(fName & vbNullString) = 0 Then, rem out fName = ds.FileDialog(True)

Set strImageName to the Path of the Image.
Then set fName=strImageName.
*************************************
In the OnOpen event of Splash/Main form: SetMDIBackGroundImage

All done. Takes 1 min to do.

Took 2 hours to figure out.....Best of luck to all and thanks to all for the suggestions.

 

[danielgraham]

Ok thanks. Ive now worked it out to stay with the colour...But it wont work with colours like FFFFFF only with 000000 so how do i add a picture instead. like a background image. many thanks for your help.

 

[danielgraham]

I want to imbed an external image so that it looks for it. i dont want to have a menu. please tell me the code!!!!!!!!!!

 

[kybb1]

hmmmm.....

read my previous post...I gave the solution there.