Re: Lebans Continuous Forms Sample Problem
- From: "Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@xxxxxxxxxxxx>
- Date: Thu, 28 Apr 2005 20:44:34 -0300
Now I remember why I did not port this sample to A2K. It's the old
Subclassing/VB IDE bug. If you have had or currently opened the VB IDE
window, then Access WIndow MEssage queque will get overloaded. If you
open the Form without having had the VB IDE open at any point during
this session then you will not encounter this bug.
There also seems to be a change from A97 in the sequence of form events.
Comment out all of the code in the resize event.
Tomorrow, I'll have a look at placing the sublassing code within an
external DLL as this is the only solution to the Subclassing bug.
It brings joy to my heart to see all of those ugly colors again on an
Access Form!<grin>
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"JohnR" <IWontTell@xxxxxxxxxxx> wrote in message
news:OdxVepDTFHA.3184@xxxxxxxxxxxxxxxxxxxxxxx
> I could only find one line.
>
> It goes into a loop and freezes the form
> CTRL Break gets it to stop on
>
> Public Function WindowProcSB(ByVal hWnd As Long, ByVal message As
Long,
> ByVal wParam As Long, ByVal lParam As Long) As Long
>
> "Stephen Lebans"
<ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@xxxxxxxxxxxx>
> wrote in message news:ehRZkNDTFHA.3184@xxxxxxxxxxxxxxxxxxxxxxx
> > Well I never bother porting it to A2K or higher simply because
> > Conditional Formatting is now directly supported. If you are willing
to
> > test it out then only 2 lines of code need to be changed.
> > Addrof needs to be modifed to call the now supported native
AddressOf
> > method instead.
> >
> > Let me know.
> >
> > --
> >
> > HTH
> > Stephen Lebans
> > http://www.lebans.com
> > Access Code, Tips and Tricks
> > Please respond only to the newsgroups so everyone can benefit.
> >
> >
> > "JohnR" <IWontTell@xxxxxxxxxxx> wrote in message
> > news:uY#9z9CTFHA.616@xxxxxxxxxxxxxxxxxxxxxxx
> >> 2003 :-(
> >>
> >> Too bad, because it looked great. The client insists on 6
different
> > colors,
> >> so I can't use the built in conditional formatting. I'll think of
> >> something.
> >>
> >> Thank you for your assistance and all the great content on your web
> > site.
> >>
> >> John
> >>
> >> "Stephen Lebans"
> > <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@xxxxxxxxxxxx>
> >> wrote in message news:OTxNtcCTFHA.3152@xxxxxxxxxxxxxxxxxxxxxxx
> >> > That solution is only for A97. WHich version of Access are you
> > using?
> >> > For A2K see:
> >> > http://www.lebans.com/conditionalformatting.htm
> >> > --
> >> >
> >> > HTH
> >> > Stephen Lebans
> >> > http://www.lebans.com
> >> > Access Code, Tips and Tricks
> >> > Please respond only to the newsgroups so everyone can benefit.
> >> >
> >> >
> >> > "JohnR" <IWontTell@xxxxxxxxxxx> wrote in message
> >> > news:OPpJjVATFHA.3344@xxxxxxxxxxxxxxxxxxxxxxx
> >> >> SubClassFormatByCriteriaVer45.mdb
> >> >>
> >> >> It changes the initial forms perfectly, but when I scroll down a
> > page
> >> > or use
> >> >> PageDown the data changes but the forms keep the original
colors.
> >> >>
> >> >> "Stephen Lebans"
> >> > <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@xxxxxxxxxxxx>
> >> >> wrote in message news:%23OdDbX4SFHA.3636@xxxxxxxxxxxxxxxxxxxxxxx
> >> >> > Which sample of mine are you referring to?
> >> >> >
> >> >> > --
> >> >> >
> >> >> > HTH
> >> >> > Stephen Lebans
> >> >> > http://www.lebans.com
> >> >> > Access Code, Tips and Tricks
> >> >> > Please respond only to the newsgroups so everyone can benefit.
> >> >> >
> >> >> >
> >> >> > "JohnR" <IWontTell@xxxxxxxxxxx> wrote in message
> >> >> > news:#IoavC4SFHA.616@xxxxxxxxxxxxxxxxxxxxxxx
> >> >> >> I need to change the background of each record on a
continuous
> > form
> >> >> > based on
> >> >> >> the value of one of the fields. From this Newgroup I was led
to
> >> >> > Stephen
> >> >> >> Lebans sample database. I was able to adopt it to my needs
and
> > it
> >> >> > works
> >> >> >> great. (Thank you Stephen) However when I scroll down the
> > form,
> >> > the
> >> >> >> formatting doesn't change. Each record keeps the color of
the
> >> > record
> >> >> > that
> >> >> >> originally occupied that space on the form. Does anyone know
> > how
> >> > to
> >> >> > capture
> >> >> >> the scroll event to rerun the code as the record changes?
> >> >> >>
> >> >> >> Thank You
> >> >> >>
> >> >> >> John
> >> >> >>
> >> >> >>
> >> >> >
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
>
.
- Follow-Ups:
- Re: Lebans Continuous Forms Sample Problem
- From: JohnR
- Re: Lebans Continuous Forms Sample Problem
- References:
- Lebans Continuous Forms Sample Problem
- From: JohnR
- Re: Lebans Continuous Forms Sample Problem
- From: Stephen Lebans
- Re: Lebans Continuous Forms Sample Problem
- From: JohnR
- Re: Lebans Continuous Forms Sample Problem
- From: Stephen Lebans
- Re: Lebans Continuous Forms Sample Problem
- From: JohnR
- Re: Lebans Continuous Forms Sample Problem
- From: Stephen Lebans
- Re: Lebans Continuous Forms Sample Problem
- From: JohnR
- Lebans Continuous Forms Sample Problem
- Prev by Date: Re: Stripping A character from a string
- Next by Date: Re: Combo box Limit
- Previous by thread: Re: Lebans Continuous Forms Sample Problem
- Next by thread: Re: Lebans Continuous Forms Sample Problem
- Index(es):
Relevant Pages
|
