Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to implement Labans

Discussion in 'Information Technology' started by lmv, Jul 28, 2006.

  1. lmv

    lmv
    Expand Collapse
    Guest

    conditional formatting...
    I am trying to understand HOW to use this. If I knew more I am sure it would
    make sense however I can't see in the information exactly what steps to take.

    Do I need to import ALL of the modules? Then copy the VBA to my form. I
    don't understand about the txt box does it need to be visible. I tried
    changing the name to my field names but that doesn't work.

    Sorry, I am a bit confused. Is there a step by step info on how to implement
    somewhere.

    By the way I posted 3 other questions
    "Report Filters by Checked Box"
    "Lockbox works BUT..."
    "Scrollbar Problem"
    and never received any answers if anyone has the time to look at them.
    (Have also posted questions that have been answered quickly and concisely
    and I am truly appreciative!!)

    Thanks!!
     
  2. Loading...

    Similar Threads Forum Date
    India Anand Marriage Act to be implemented soon: Khurshid Breaking News Nov 14, 2011
    Legal National Litigation policy will be implemented from 1st July, 2010 Breaking News Jun 24, 2010
    Implementation of Integrated Child Development Services Health & Nutrition Apr 22, 2010
    Sikh News Appeal to Takht Chief to Implement Edict against Dera Sacha Sauda Breaking News Sep 30, 2009
    Sikh News Punjab To Effectively Implement Tobacco Control Measures (New Kerala) Breaking News Jul 26, 2008

  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Yes, you have to copy the modules and the VBA. As it explains on the
    README1st form, there are actually 2 separate classes
    (ClsConditionalFormatting and clsConditionalFormattingDataSheetView). If you
    know which class you want, you should be able to get away without importing
    the other one.

    I don't believe it actually matters whether or not the text box is visible.

    Unfortunately, "that doesn't work" doesn't give us anything to go on in
    terms of helping you.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "lmv" <lmv@discussions.microsoft.com> wrote in message
    news:1BE44506-AC2B-4201-9C66-8C69B81EBCB1@microsoft.com...
    > conditional formatting...
    > I am trying to understand HOW to use this. If I knew more I am sure it
    > would
    > make sense however I can't see in the information exactly what steps to
    > take.
    >
    > Do I need to import ALL of the modules? Then copy the VBA to my form. I
    > don't understand about the txt box does it need to be visible. I tried
    > changing the name to my field names but that doesn't work.
    >
    > Sorry, I am a bit confused. Is there a step by step info on how to
    > implement
    > somewhere.
    >
    > By the way I posted 3 other questions
    > "Report Filters by Checked Box"
    > "Lockbox works BUT..."
    > "Scrollbar Problem"
    > and never received any answers if anyone has the time to look at them.
    > (Have also posted questions that have been answered quickly and concisely
    > and I am truly appreciative!!)
    >
    > Thanks!!
    >
     
  4. lmv

    lmv
    Expand Collapse
    Guest

    Never mind!! I finally figured it out after finding this info at the bottom
    of the page
    http://www.lebans.com/conditionalformatting.htm

    If mShowHighlightingAlternate = False Then
    Set objFrc = ctl.FormatConditions.ADD(acExpression, _
    , "fCurrentRow([" & mKeyControl.Name & "])")

    Else
    Set objFrc = ctl.FormatConditions.ADD(acExpression, _
    , "fAlternateRow([" & mKeyControl.Name & "])")
    End If

    Once I change it ... presto! But, could still use answers to the
    following... ;)

    > By the way I posted 3 other questions
    > "Report Filters by Checked Box"
    > "Lockbox works BUT..."
    > "Scrollbar Problem"
    > and never received any answers if anyone has the time to look at them.
    > (Have also posted questions that have been answered quickly and concisely
    > and I am truly appreciative!!)
    >
    > Thanks!!
    >
     

Share This Page