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 11 3594
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" <in**@businessformat.co.uk> wrote in message
news:d2********************************@4ax.com... 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
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"
<St***********@mvps.org> wrote: 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.
I typed in "Lebans" and "MDI". Google returned: http://groups.google.com/groups?hl=e...=M3NHa.727%24S
v5.93908%40ursa-nb00s0.nbnet.nb.ca&rnum=7&prev=/groups%3Fas_q%3Dlebans%2
520MDI%26safe%3Dimages%26ie%3DISO-8859-1%26as_scoring%3Dd%26lr%3D%26num%
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" <in**@businessformat.co.uk> wrote in message
news:ql********************************@4ax.com... 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" <St***********@mvps.org> wrote:
Patrick I think this issue was brought up a couple of months ago. It
hasto 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.
On Wed, 15 Oct 2003 00:47:52 GMT, "Stephen Lebans"
<St***********@mvps.org> wrote: I typed in "Lebans" and "MDI". Google returned: http://groups.google.com/groups?hl=e...=M3NHa.727%24S v5.93908%40ursa-nb00s0.nbnet.nb.ca&rnum=7&prev=/groups%3Fas_q%3Dlebans%2 520MDI%26safe%3Dimages%26ie%3DISO-8859-1%26as_scoring%3Dd%26lr%3D%26num% 3D100%26hl%3Den
A little tip: type the link between tw < >:
<http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=M3NHa.727%24Sv5.93908%40ursa-nb00s0.nbnet.nb.ca&rnum=7&prev=/groups%3Fas_q%3Dlebans%2520MDI%26safe%3Dimages%26i e%3DISO-8859-1%26as_scoring%3Dd%26lr%3D%26num%3D100%26hl%3Den>
Best regards, and thanks for all the hard work!
--
bebelino
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 = RestoreMDIBackGroundImage(lngColor)
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
<in**@businessformat.co.uk> wrote: 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
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" <in**@businessformat.co.uk> wrote in message
news:it********************************@4ax.com... 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 = RestoreMDIBackGroundImage(lngColor) 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 <in**@businessformat.co.uk> wrote:
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
thescreen.
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
andcan help. Regards Patrick
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
<in**@businessformat.co.uk> wrote: 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
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" <in**@businessformat.co.uk> wrote in message
news:9g********************************@4ax.com... 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 <in**@businessformat.co.uk> wrote:
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
thescreen.
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
andcan help. Regards Patrick
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
<in**@businessformat.co.uk> wrote: 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
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
<in**@businessformat.co.uk> wrote: 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
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" <in**@businessformat.co.uk> wrote in message
news:do********************************@4ax.com... 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 <in**@businessformat.co.uk> wrote:
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
thescreen.
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
andcan help. Regards Patrick This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Wally |
last post by:
Hi All,
I'm using Stephan Lebans' nifty code for automatically resizing text
fields to the size required to show (almost) all text in that field
(CanGrow3, thanks Stephen!).
In general this...
|
by: Alex |
last post by:
The JustiDirect text justification on Stephen LeBans site works well
but I cannot get it to work on a sub report. Could anyone tell me if
this is possible.
Thanks.
Alex
|
by: Alex Wisnoski |
last post by:
I am trying to adapt Lebans' ReportUtilities to export reports (to
preserve formatting) from an Access 97 application. I have made the
reference to his mde and copied the modules into my db. I...
|
by: ChrisR |
last post by:
Hi Stephen Lebans
Thank you very much for your effort and time you have spent writing
and helping small hacks like me.
I have just one problem with your mousewheelhook.
I'm using Access 2002.
I...
|
by: Karl Roes |
last post by:
Hi Stephen,
Very Cool. I can only get it working on the first row of a continuous
form. Is this correct?
Regards
Karl
|
by: Phil Stanton |
last post by:
I am trying to produce a program that will output any Access report to an
editable Word document. So far it is working well but slowly with text
boxes, labels, and lines.
I now need to try to...
|
by: Rémi |
last post by:
Hello all!
I've been using Stephen Lebans' MouseWheel stuff for a number of years
now, without problems. I've used on different combinations of Access
and Windows, and have had great results with...
|
by: nospamhere |
last post by:
Hello Stephen and all,
This is such a cool group. I really need to spend more time here.
A few months ago I noticed some brief discussion here about the fact
that your excellent HTML Editor...
|
by: grant |
last post by:
Hi
I've copied Stephens code into my db, and can get it to work, but only
on "plain Jane" reports with no images.
Most of my reports has an unbound image obluect in them that I set to
an...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |