Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Another 2007 bug (Access 2007)

    Here is an Access2007 bug I just found.

    I provide a "Select All" button to allow users to select all lines in a multi-select listbox. The code is very simple, as in this example:
    --------------------------------------
    Dim N As Integer

    For N = 0 To lstAttendees.ListCount - 1
    lstAttendees.Selected(N) = True
    Next N
    --------------------------------

    This has worked in all versions of Access until Access2007!

    In Access2007, if the listbox has the "Column Headers" property set to True, it will "select" the header row also! Previous versions apparently did not allow the Selected property of the header row to be set.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Another 2007 bug (Access 2007)

    Yep - see A2007: Interesting list box bug. It mentions that the bug has been reported to Microsoft, and a clever workaround.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Another 2007 bug (Access 2007)

    I wish Microsoft had a comprehensive list of all reported bugs that they published. I checked their website and found some A2007 issues, but this one wasn't one of them. I also checked a few other websites, and no-one had mentioned this one either. Unfortunately, when someone says "This has been reported to Microsoft", I don't exactly know what that means. Do they have some of "official" method for doing so unavailable to the rest of us?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Another 2007 bug (Access 2007)

    Some software makers are upfront about bugs and problems they know about, but Microsoft has always been more reticent.

    Tony Toews is a Microsoft MVP for Access, so he does have a direct way of contacting the Microsoft Access development team.

Posting Permissions

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