Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    Dudley, Midlands, England
    Posts
    55
    Thanks
    1
    Thanked 0 Times in 0 Posts

    'Quick Sort' in Datasheet view (A97)

    I have recently "inherited" a database system to look after. It used to exist on several people's desktops in various offices around the country. The decision has been made to make the use of this DB a "company standard" and so it has to be made more widely available in a common version.

    The company standard for applications like this is to split such an application into front-end and back-end (done that) and have every user run the same copy of the front end across the network using run-time Access and Citrix (done that too). I should add, that I'm supposed to spend as little time as possible getting this working in this environment, so certain niceties go out of the window.

    One quirk of the system is that it has a number of things which it calls "reports" but which are nothing more than datasheet views of portions of the data generated by various queries. Previously the users could even input via these (thus completely bypassing the proper forms and their validation) but I've stopped that happening. A few people are now using this centralised version and someone's come along and pointed out that they can no longer sort these "reports" in whatever order they wish (because the toolsbars and popup menus which allowed them to sort and filter before don't exist under run-time) and asked if I could re-enable this feature.

    OK, sure, I can build a new toolbar, popup menu or whatever to do this, but this has a knock-on effect I hadn't considered: once you change the sort order or filtering of a query in datasheet view, when you close it, it notices that you've modified the query and asks if you want to save it. It does this whether you're running full Access or Access RT and whether you're using an MDB or MDE. If you change the security on the query object so it's readonly, you still get prompted (though as it can't overwrite the existing version, it forces you to save to an external object or database). As each user used to have their own copy of the front end before, this wasn't too much of a problem, but now there is a shared front end I'd rather they didn't get prompted, and I certainly don't want anyone changing the queries just to suit themselves but no-one else.

    Does anyone know quick way of implementing the capability of allowing users to sort (and, I guess, filter) on the results of a query in datasheet view without Access subsequently asking them if they want to save their changes?

    Thanks,

    Simon

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: 'Quick Sort' in Datasheet view (A97)

    One possible solution would be to create a form that looks like a datasheet, and let them apply filters and sorts to the form. In that case I don't believe you will be prompted to save the design, though the only place I can think of where we do that right now is with Access 2000, so I'm not positive A97 behaves the same way. Another possibility is to set the file property of the front-end MDB to ReadOnly - we do that with A2k front-ends and add-ins to prevent them from growing like topsy. Hope this is useful.
    Wendell

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 'Quick Sort' in Datasheet view (A97)

    It does, Wendell. I usually use a form view, not a datasheet, and use the OnClick event of the label that identifies each column to do a quick sort on that column. You can even get fancy and toggle the sort back and forth between ASC and DESC with subsequent clicks. That eliminates the need for a menu.

    Another option is to create a custom shortcut menu that contains only the Asc, Desc, and Remove filter commands and set that as the shortcut menu for the form. Then the users can right click to sort on a column (or multiple columns).
    Charlotte

  4. #4
    Star Lounger
    Join Date
    Mar 2001
    Location
    Dudley, Midlands, England
    Posts
    55
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: 'Quick Sort' in Datasheet view (A97)

    I agree that the form as datasheet option is probably the better way and the way to go, eventually. To get a solution in place asap, I've used the "readonly" trick for now with a simple toolbar to allow the user to sort and filter the data.

    Thanks to both of you for your help.

Posting Permissions

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