Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2001
    Location
    Richmond, Virginia, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error sorting subform in Windows 2000 (Access 2000)

    Hi,

    One of the applications that I developed and am responsible for maintaining has several subforms who's sort order is controlled by an OptionGroup on the main form. The code used is as follows:

    Private Sub optSortByItemNumber_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)

    ' Sort produce item listing by item number.
    Me.sfrMaintainProduceItem.Form.OrderBy = "ItemNumber"

    End Sub

    Private Sub optSortByItem_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)

    ' Sort produce item listing by item description.
    Me.sfrMaintainProduceItem.Form.OrderBy = "Item, ItemNumber"

    End Sub

    Private Sub optSortByPLUUPC_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)

    ' Sort produce item listing by PLU/UPC.
    Me.sfrMaintainProduceItem.Form.OrderBy = "PLU_UPC, ItemNumber"

    End Sub

    Recently several of the sites where this program is deployed have upgraded from Windows 95 to Windows 2000. At these sites, the users are now unable to sort the subform. No mater which option button is selected, the subform remains sorted in the default order. Those sites that are still running Windows 95 can still sort the subform.

    The application consists of a .mde file and a linked .mdb data file. The data source for the subform is a linked table.

    Thanks for your help,

    Vernon

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

    Re: Error sorting subform in Windows 2000 (Access 2000)

    I don't know why you are having problems. The immediate thought I had was that you did not set the OrderByOn property, but from your description there was no change in the database, only the OS. However, as an experiement, immediately after:

    Me.sfrMaintainProduceItem.Form.OrderBy = "Item, ItemNumber"

    Try puttiing this:

    Me.sfrMaintainProduceItem.Form.Requery
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    New Lounger
    Join Date
    Aug 2001
    Location
    Richmond, Virginia, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error sorting subform in Windows 2000 (Access 2000)

    Actually, it turns out that I hadn't set the OrderByOn property. It's curious that it worked previously as an Access 97/Windows 95 & Access 2000/Windows 95 application.

    Thanks for the help,

    Vernon

Posting Permissions

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