473,769 Members | 1,929 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Stephen Lebans Code

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
Nov 12 '05 #1
11 3629
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**@businessf ormat.co.uk> wrote in message
news:d2******** *************** *********@4ax.c om...
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


Nov 12 '05 #2
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.


Nov 12 '05 #3
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%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" <in**@businessf ormat.co.uk> wrote in message
news:ql******** *************** *********@4ax.c om...
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.


Nov 12 '05 #4
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%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


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
Nov 12 '05 #5
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
<in**@businessf ormat.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


Nov 12 '05 #6
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**@businessf ormat.co.uk> wrote in message
news:it******** *************** *********@4ax.c om...
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
<in**@businessf ormat.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


Nov 12 '05 #7
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**@businessf ormat.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


Nov 12 '05 #8
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**@businessf ormat.co.uk> wrote in message
news:9g******** *************** *********@4ax.c om...
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**@businessf ormat.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


Nov 12 '05 #9
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**@businessf ormat.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


Nov 12 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2504
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 function works great. However, I sometimes have a problem with the last text line. Often the last line is just below the end of the field and to view that line I have to scroll to it. Is that a known problem? And is there a solution?
1
3112
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
3
2617
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 have created a custom toolbar with a custom control, "Export to File". In the On Action property (of the export control) I inserted the code "pf.ExportToMSWord rptApplicantReferral" which I had copied from his sample db except for the name of my...
1
1849
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 have db with an unbounded Main Form with numerous sub forms. The mousewheelhook works find with the subforms in the Main Form. Mousewheelhook is loaded in the Main Form Load event and unloaded in the same form in the unloaded event. The problem...
4
2166
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
3
3309
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 output one of Stephen Lebans' RTF2 controls on the report. He indicates that a copy and paste method will work from a form to the Word doc and that is fine although I have not done this in VB, rather used ^C and ^V I suspect that a similar method...
3
5823
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 it. (Even better, considering what I paid for it.) Just hit a situation where it didn't work, though, and I was wondering if anyone else has hit this yet: *A dumb terminal, running Windows 2003.
14
2017
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 for Access is not yet compatible with IE7. At that time, you correctly pointed out that IE7 was still in beta status and that you would not consider any update to A2KSHTML until after IE7 was officially released. Obviously, that was the only...
8
5485
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 external image file using on_open code I've searched through this group and there are a few comments about snapshots not working with embedded images, and my testing seems to
0
9579
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9420
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10205
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9984
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9851
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8863
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7401
isladogs
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5441
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3949
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.