Set the Access window to a bmp

[Kiers]

Hi,

I am running A2K7 and want to set the Access window/desktop of my
application to the logo of the Company. is this possible?. If yes any
pointers would be appreciated

TIA

Kiers

[jonceramic]

On Aug 11, 11:46*am, Kiers <kie...@leasema nager.co.ukwrot e:

Hi,

I am running A2K7 and want to set the Access window/desktop of my
application to the logo of the Company. is this possible?. If yes any
pointers would be appreciated

TIA

Kiers

Unless it's changed (I don't have A2K7), it was Tools->Startup...-

>Application Icon.

If you'd just like a background image, you just put that on your form
in the proper spot. Make sure it's set behind your controls by going
to "Format" on the toolbar and choosing "Send to Back".

Thanks,

Jon

[Kiers]

On 11 Aug, 21:14, jonceramic <joncera...@gma il.comwrote:

On Aug 11, 11:46*am, Kiers <kie...@leasema nager.co.ukwrot e:

Hi,

I am running A2K7 and want to set the Access window/desktop of my
application to the logo of the Company. is this possible?. If yes any
pointers would be appreciated

TIA

Kiers

Unless it's changed (I don't have A2K7), it was Tools->Startup...-

Application Icon.

If you'd just like a background image, you just put that on your form
in the proper spot. *Make sure it's set behind your controls by going
to "Format" on the toolbar and choosing "Send to Back".

Thanks,

Jon

Hi Jon,

thanks for responding, though just to clarify: i don't want to put the
logo on a form, but rather the background of the Access window so it
is visible when no forms/reports are open.

Thanks

Kiers

[Stuart McCall]

"Kiers" <ki****@leasema nager.co.ukwrot e in message
news:b1******** *************** ***********@r66 g2000hsg.google groups.com...
On 11 Aug, 21:14, jonceramic <joncera...@gma il.comwrote:

On Aug 11, 11:46 am, Kiers <kie...@leasema nager.co.ukwrot e:

Hi,

I am running A2K7 and want to set the Access window/desktop of my
application to the logo of the Company. is this possible?. If yes any
pointers would be appreciated

TIA

Kiers

Unless it's changed (I don't have A2K7), it was Tools->Startup...-

Application Icon.

If you'd just like a background image, you just put that on your form
in the proper spot. Make sure it's set behind your controls by going
to "Format" on the toolbar and choosing "Send to Back".

Thanks,

Jon

Hi Jon,

thanks for responding, though just to clarify: i don't want to put the
logo on a form, but rather the background of the Access window so it
is visible when no forms/reports are open.

Thanks

Kiers

AFAIK it's not possible to put a bitmap on the mdi background. You need to
use API code to even just change the colour.

However there is a way using a form and a bit of code to _simulate_ what you
want.

Create a new unbound form. Call it say 'Background'. Set the form's
borderstyle to 'None'. Set it's Picture property to your logo bitmap. Then
grab this piece of code:

http://www.smccall.demon.co.uk/Windows.htm#WinManip

Open the background form in design view and put this code into the OnOpen
event procedure:

SizeFormToWindo w Me

Open this form before whatever you normally load up first. The user will not
be able to affect the background form in any way because it has no title bar
(and hence no system menu or close button).

HTH

[Kiers]

Hi Stuart,

this helps a real lot - almost there now - thank you.

just a couple of questions;

despite the fact that i have disabled scroll bars they still apear -
do you know why? and secondly, if the user resizes the Access window,
is it possible to automatically resize the form, otherwise if the
window is made larger i get an unwanted border (back to the default)?

Thanks Again.

Kiers

[Stuart McCall]

Comments inline:

"Kiers" <ki****@leasema nager.co.ukwrot e in message
news:54******** *************** ***********@a1g 2000hsb.googleg roups.com...

>
Hi Stuart,

this helps a real lot - almost there now - thank you.

just a couple of questions;

despite the fact that i have disabled scroll bars they still apear -
do you know why?

Probably because your bitmap is too big. Try reducing the size a bit (if you
have the wherewithall)

and secondly, if the user resizes the Access window,
is it possible to automatically resize the form, otherwise if the
window is made larger i get an unwanted border (back to the default)?

No, unfortunately there's no event fired when Access resizes (TTBOMK). I
should have mentioned before that this technique only works well if Access
is run maximized.

It's by no means an ideal solution, but it works well within its limits.

>
Thanks Again.

Kiers

[Stephen Lebans]

See:
http://www.lebans.com/changemdibackground.htm
Updated May 03,2003 Now allows you to select a Bitmap Image to place in the
background of the MDI window. No Subclassing required

ChangeMDIBackGr ound.zip is a database containing a function to allow you to
specify a color or Bitmap Image for the background of the main Access MDI
window. NO SUBCLASSING REQUIRED!

Release Notes:

Version 3

Added support to allow you to specify a Bitmap Image to be placed into the
background of the MDI window.

Version 2

Added support to change the Background and Text colors for the Access Status
Bar.

Version 1

Initial Release. Only supports solid colors.

Search Keywords:

MDI Document window Bitmap Status Bar color
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"Kiers" <ki****@leasema nager.co.ukwrot e in message
news:49******** *************** ***********@26g 2000hsk.googleg roups.com...

Hi,

I am running A2K7 and want to set the Access window/desktop of my
application to the logo of the Company. is this possible?. If yes any
pointers would be appreciated

TIA

Kiers

[Stuart McCall]

Hi Stephen

I had an idea you'd have something for this. Thanks for jumping in. I'll
take a look at your database soon.

[Kiers]

Hi Stephen,

I downloaded the db and copied in the modules/forms as instructed, but
couldnt get it to work in either A2K3 or A2K7.

In A2K3, it looks like it works, in that the bitmap is displayed, but
when the db is reopened it has disappeared.

In A2K7, the bitmap selected just doesnt apear in the MDI when
selected.

Have i missed something?

Thanks for your help.

Rgds

Kiers

[Stephen Lebans]

You have to set the background for the MDI window each time your MDB is
started. Most folks place the required code inthe Load event of the first
form they open.

I have no idea as to whether it will work in A2007 or not.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Kiers" <ki****@leasema nager.co.ukwrot e in message
news:cc******** *************** ***********@m36 g2000hse.google groups.com...

Hi Stephen,

I downloaded the db and copied in the modules/forms as instructed, but
couldnt get it to work in either A2K3 or A2K7.

In A2K3, it looks like it works, in that the bitmap is displayed, but
when the db is reopened it has disappeared.

In A2K7, the bitmap selected just doesnt apear in the MDI when
selected.

Have i missed something?

Thanks for your help.

Rgds

Kiers