Stephen Lebans Code

[Patrick]

I am using Stephans code to change the background color of the Access
container in Access 97, the code works fine when running in Access in
the normal way.

The problem occurs when running the program after creating a RunTime
version when a gray rectangle appears at the top left hand side of the
screen.

This effect is present when using the sub that changes the color and
when using the sub that calls up an image.

I expect that only Stephen can sort this out, I hope he reads this and
can help.
Regards
Patrick

[Stephen Lebans]

Re: Stephen Lebans Code

Patrick I think this issue was brought up a couple of months ago. It has
to do with a timing issue if I remember as Access leaves space for a
Menu/Toolbar even if it will actually end up not displaying it.
Have you searched on Google? I'm sure there is a thread there.

Let me know.

--
Stephen Lebans

http://www.lebans.com

Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Patrick" <info@businessf ormat.co.uk> wrote in message
news:d21oovgrov kddmsa2mfn1ecc8 bie95p722@4ax.c om...[color=blue]
> I am using Stephans code to change the background color of the Access
> container in Access 97, the code works fine when running in Access in
> the normal way.
>
> The problem occurs when running the program after creating a RunTime
> version when a gray rectangle appears at the top left hand side of the
> screen.
>
> This effect is present when using the sub that changes the color and
> when using the sub that calls up an image.
>
> I expect that only Stephen can sort this out, I hope he reads this and
> can help.
> Regards
> Patrick[/color]

[Patrick]

Re: Stephen Lebans Code

Hi Stephen
I have asearched every way I can think of, it very difficult to phrase
a search as most users will not have come across this problem. I was
hoping as you wrote the code that you could come up with a solution, I
will be most gratefull if you can, UI can put a screen shot up on the
web if it will help.
Regards
Patrick

On Tue, 14 Oct 2003 21:56:05 GMT, "Stephen Lebans"
<StephenLebans@ mvps.org> wrote:
[color=blue]
>Patrick I think this issue was brought up a couple of months ago. It has
>to do with a timing issue if I remember as Access leaves space for a
>Menu/Toolbar even if it will actually end up not displaying it.
>Have you searched on Google? I'm sure there is a thread there.
>
>Let me know.[/color]

[Stephen Lebans]

Re: Stephen Lebans Code

I typed in "Lebans" and "MDI". Google returned:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=M3NHa.727%24S

v5.93908%40ursa-nb00s0.nbnet.nb .ca&rnum=7&prev =/groups%3Fas_q%3 Dlebans%2
520MDI%26safe%3 Dimages%26ie%3D ISO-8859-1%26as_scoring% 3Dd%26lr%3D%26n um%
3D100%26hl%3Den

Does this sound like the same issue you are experiencing?

--

HTH
Stephen Lebans

http://www.lebans.com

Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Patrick" <info@businessf ormat.co.uk> wrote in message
news:ql0pov40f8 84vpmhsaa12hcl4 rdpgq1rsq@4ax.c om...[color=blue]
> Hi Stephen
> I have asearched every way I can think of, it very difficult to phrase
> a search as most users will not have come across this problem. I was
> hoping as you wrote the code that you could come up with a solution, I
> will be most gratefull if you can, UI can put a screen shot up on the
> web if it will help.
> Regards
> Patrick
>
> On Tue, 14 Oct 2003 21:56:05 GMT, "Stephen Lebans"
> <StephenLebans@ mvps.org> wrote:
>[color=green]
> >Patrick I think this issue was brought up a couple of months ago. It[/color][/color]
has[color=blue][color=green]
> >to do with a timing issue if I remember as Access leaves space for a
> >Menu/Toolbar even if it will actually end up not displaying it.
> >Have you searched on Google? I'm sure there is a thread there.
> >
> >Let me know.[/color]
>[/color]

[bebelino]

Re: Stephen Lebans Code

On Wed, 15 Oct 2003 00:47:52 GMT, "Stephen Lebans"
<StephenLebans@ mvps.org> wrote:
[color=blue]
>I typed in "Lebans" and "MDI". Google returned:
>http://groups.google.com/groups?hl=e...=M3NHa.727%24S
>v5.93908%40urs a-nb00s0.nbnet.nb .ca&rnum=7&prev =/groups%3Fas_q%3 Dlebans%2
>520MDI%26safe% 3Dimages%26ie%3 DISO-8859-1%26as_scoring% 3Dd%26lr%3D%26n um%
>3D100%26hl%3De n[/color]

A little tip: type the link between tw < >:
<http://groups.google.c om/groups?hl=en&lr =&ie=UTF-8&threadm=M3NHa .727%24Sv5.9390 8%40ursa-nb00s0.nbnet.nb .ca&rnum=7&prev =/groups%3Fas_q%3 Dlebans%2520MDI %26safe%3Dimage s%26ie%3DISO-8859-1%26as_scoring% 3Dd%26lr%3D%26n um%3D100%26hl%3 Den>

Best regards, and thanks for all the hard work!
--
bebelino

[Patrick]

Re: Stephen Lebans Code

They say a picture is worth a thousand words:

I have posted a screen shot of the problem to www.rhub.com/lebans
which should make clear what is happening, I have deliberately kept
things as simple as possible with a form and a button to run the code
as follows

Private Sub Command0_Click( )
Dim blRet As Boolean
Dim lngColor As Long
lngColor = 100
If lngColor = -1 Then lngColor = RGB(255, 255, 255)
blRet = RestoreMDIBackG roundImage(lngC olor)
End Sub

I looked at the group postings as suggested but they did not seem to
describe the problem I am having as the web page will make clear.

Help
Regards
Patrick

On Tue, 14 Oct 2003 14:18:49 +0000 (UTC), Patrick
<info@businessf ormat.co.uk> wrote:
[color=blue]
>I am using Stephans code to change the background color of the Access
>container in Access 97, the code works fine when running in Access in
>the normal way.
>
>The problem occurs when running the program after creating a RunTime
>version when a gray rectangle appears at the top left hand side of the
>screen.
>
>This effect is present when using the sub that changes the color and
>when using the sub that calls up an image.
>
>I expect that only Stephen can sort this out, I hope he reads this and
>can help.
>Regards
>Patrick[/color]

[Stephen Lebans]

Re: Stephen Lebans Code

Thanks for the screen shot...very strange!
Patrick I cannot duplicate this here at home. Have you duplicated this
effect on more than 1 machine?
What happens when you cause a screen redraw.. say if you drag your Form
over top of this stray rectangle. WHne you again move the form to
uncover this rectangle does it finally dissappear?
--

HTH
Stephen Lebans

http://www.lebans.com

Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Patrick" <info@businessf ormat.co.uk> wrote in message
news:it0qov85e8 i3gp8dod5p84q68 rsorgef86@4ax.c om...[color=blue]
> They say a picture is worth a thousand words:
>
> I have posted a screen shot of the problem to www.rhub.com/lebans
> which should make clear what is happening, I have deliberately kept
> things as simple as possible with a form and a button to run the code
> as follows
>
> Private Sub Command0_Click( )
> Dim blRet As Boolean
> Dim lngColor As Long
> lngColor = 100
> If lngColor = -1 Then lngColor = RGB(255, 255, 255)
> blRet = RestoreMDIBackG roundImage(lngC olor)
> End Sub
>
> I looked at the group postings as suggested but they did not seem to
> describe the problem I am having as the web page will make clear.
>
> Help
> Regards
> Patrick
>
> On Tue, 14 Oct 2003 14:18:49 +0000 (UTC), Patrick
> <info@businessf ormat.co.uk> wrote:
>[color=green]
> >I am using Stephans code to change the background color of the Access
> >container in Access 97, the code works fine when running in Access in
> >the normal way.
> >
> >The problem occurs when running the program after creating a RunTime
> >version when a gray rectangle appears at the top left hand side of[/color][/color]
the[color=blue][color=green]
> >screen.
> >
> >This effect is present when using the sub that changes the color and
> >when using the sub that calls up an image.
> >
> >I expect that only Stephen can sort this out, I hope he reads this[/color][/color]
and[color=blue][color=green]
> >can help.
> >Regards
> >Patrick[/color]
>[/color]

[Patrick]

Re: Stephen Lebans Code

Hi Stephen
Yes I can duplicate it every time I install it on any machine.

Moving another window over it done not remove it.

This problem only occurs when using the runtime which I create using
Access97 distribution kit and Sagekey.

Regards
Patrick

On Tue, 14 Oct 2003 14:18:49 +0000 (UTC), Patrick
<info@businessf ormat.co.uk> wrote:
[color=blue]
>I am using Stephans code to change the background color of the Access
>container in Access 97, the code works fine when running in Access in
>the normal way.
>
>The problem occurs when running the program after creating a RunTime
>version when a gray rectangle appears at the top left hand side of the
>screen.
>
>This effect is present when using the sub that changes the color and
>when using the sub that calls up an image.
>
>I expect that only Stephen can sort this out, I hope he reads this and
>can help.
>Regards
>Patrick[/color]

[Stephen Lebans]

Re: Stephen Lebans Code

Patrick I cannot duplicate it here so I'm not sure how to help you with
this. Have you tried loading a Bitmap instead of specifying a colored
brush, and see if that works?

--

HTH
Stephen Lebans

http://www.lebans.com

Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Patrick" <info@businessf ormat.co.uk> wrote in message
news:9gatovsq2q 955jndfj4khtljd rfo47cbfe@4ax.c om...[color=blue]
> Hi Stephen
> Yes I can duplicate it every time I install it on any machine.
>
> Moving another window over it done not remove it.
>
> This problem only occurs when using the runtime which I create using
> Access97 distribution kit and Sagekey.
>
> Regards
> Patrick
>
> On Tue, 14 Oct 2003 14:18:49 +0000 (UTC), Patrick
> <info@businessf ormat.co.uk> wrote:
>[color=green]
> >I am using Stephans code to change the background color of the Access
> >container in Access 97, the code works fine when running in Access in
> >the normal way.
> >
> >The problem occurs when running the program after creating a RunTime
> >version when a gray rectangle appears at the top left hand side of[/color][/color]
the[color=blue][color=green]
> >screen.
> >
> >This effect is present when using the sub that changes the color and
> >when using the sub that calls up an image.
> >
> >I expect that only Stephen can sort this out, I hope he reads this[/color][/color]
and[color=blue][color=green]
> >can help.
> >Regards
> >Patrick[/color]
>[/color]

[Patrick]

Re: Stephen Lebans Code

Ho Stephen
Yes the bitmap option has the problem, I wonder if it could have
anything to do with the distribution kit or Sagekey?
Patrick

On Tue, 14 Oct 2003 14:18:49 +0000 (UTC), Patrick
<info@businessf ormat.co.uk> wrote:
[color=blue]
>I am using Stephans code to change the background color of the Access
>container in Access 97, the code works fine when running in Access in
>the normal way.
>
>The problem occurs when running the program after creating a RunTime
>version when a gray rectangle appears at the top left hand side of the
>screen.
>
>This effect is present when using the sub that changes the color and
>when using the sub that calls up an image.
>
>I expect that only Stephen can sort this out, I hope he reads this and
>can help.
>Regards
>Patrick[/color]

[Patrick]

Re: Stephen Lebans Code

I have finally solved the probem - It seems that a WindowHide command
is required as the first entry in the Autoexec macro - simple as that!
Regards
Patrick


On Tue, 14 Oct 2003 14:18:49 +0000 (UTC), Patrick
<info@businessf ormat.co.uk> wrote:
[color=blue]
>I am using Stephans code to change the background color of the Access
>container in Access 97, the code works fine when running in Access in
>the normal way.
>
>The problem occurs when running the program after creating a RunTime
>version when a gray rectangle appears at the top left hand side of the
>screen.
>
>This effect is present when using the sub that changes the color and
>when using the sub that calls up an image.
>
>I expect that only Stephen can sort this out, I hope he reads this and
>can help.
>Regards
>Patrick[/color]

[Stephen Lebans]

Re: Stephen Lebans Code

Patrick I'm glad you found a solution!
:-)

--
Stephen Lebans

http://www.lebans.com

Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Patrick" <info@businessf ormat.co.uk> wrote in message
news:do82pv8e5i d35mtpgnbjcctke e9kvb2m9p@4ax.c om...[color=blue]
> I have finally solved the probem - It seems that a WindowHide command
> is required as the first entry in the Autoexec macro - simple as that!
> Regards
> Patrick
>
>
> On Tue, 14 Oct 2003 14:18:49 +0000 (UTC), Patrick
> <info@businessf ormat.co.uk> wrote:
>[color=green]
> >I am using Stephans code to change the background color of the Access
> >container in Access 97, the code works fine when running in Access in
> >the normal way.
> >
> >The problem occurs when running the program after creating a RunTime
> >version when a gray rectangle appears at the top left hand side of[/color][/color]
the[color=blue][color=green]
> >screen.
> >
> >This effect is present when using the sub that changes the color and
> >when using the sub that calls up an image.
> >
> >I expect that only Stephen can sort this out, I hope he reads this[/color][/color]
and[color=blue][color=green]
> >can help.
> >Regards
> >Patrick[/color]
>[/color]