Results 1 to 12 of 12
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Freeze a Form's row headings (2003 SP2)

    In Excel one can freeze panes so that row &/or column headings are always visible.
    In an Access form one can freeze the column headings by putting them in the header. Is there any way of freezing the row headings
    Regards,
    Peter

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Freeze a Form's row headings (2003 SP2)

    What kind of form are you talking about? In Datasheet view? I never use Datasheet view, but you can freeze columns through the Format menu.
    In Form view and Continuous view, I don't understand what you mean.

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Freeze a Form's row headings (2003 SP2)

    Not in data sheet view, but form view. Well, I guess you
    Regards,
    Peter

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Freeze a Form's row headings (2003 SP2)

    Umm...
    > The form is based on a Xtab query
    > ensure that the correct record field is being edited
    But a crosstab query is not updateable, so a form based on a crosstab query cannot be used to edit data. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Freeze a Form's row headings (2003 SP2)

    I have it so that when the required control is double clicked, (which, as the date heading can't be seen, could be the wrong one), the control changes colour and an edit form pops up. After editing, the Xtab re-queries and we go back to the control that was double clicked. It all works really well, except for being error prone in that the wrong control could be double clicked.
    Regards,
    Peter

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Freeze a Form's row headings (2003 SP2)

    The attached database is a rough, unfinished idea. It uses two subforms side by side, one with the row headers and one with the data columns.
    What is still to be done is synchronizing the vertical scrolling.

  7. #7
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Freeze a Form's row headings (2003 SP2)

    'What is still to be done is synchronizing the vertical scrolling.'
    I thought that would be easy, but there is no OnScroll event. All I can think of is to make my own scrolling bars (long buttons). Is there any other way?
    Regards,
    Peter

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Freeze a Form's row headings (2003 SP2)

    I don't think it'll be easy - you'll have to use built-in or ActiveX controls. Are you sure it's worth the trouble?

  9. #9
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Freeze a Form's row headings (2003 SP2)

    Probably not. Certainly not, if any ActiveX controls are needed. But then there's the challange of trying with Access only stuff.
    Regards,
    Peter

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Freeze a Form's row headings (2003 SP2)

    The attached version is rather clunky, but it does provide synchronized scrolling.

  11. #11
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Freeze a Form's row headings (2003 SP2)

    To say that I'm impressed would be a huge understatement. I was still rooting around just trying to find a way of doing it.
    Unbelievable. Thanks heaps.
    Regards,
    Peter

  12. #12
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Freeze a Form's row headings (2003 SP2)

    I was going to work on the code a bit. But inserting Me.Painting = False (& True), made the operation quick and smooth. No alteration needed.
    Regards,
    Peter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •