Results 1 to 10 of 10
  1. #1
    Join Date
    Aug 2003
    Location
    Cleveland USA
    Posts
    184

    Question What are record selectors for???

    Just a question, but I've been wondering this for years. What is the point of the record selector bar on forms? I always turn them off. I can't see a use for them, especially for users.

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    I use Record Selectors primarily for subforms. For example, if you had a customer history form that showed the customers orders, you could have information about the customer and then below it a subform listing all of the orders for that customer. The user would click on a record and press the edit button. Without record selectors the user would not know which record had been selected.

  3. #3
    Join Date
    Jun 2002
    Location
    Saudi Arabia / Philippines
    Posts
    126
    I also nearly always turn them off. The only situation when they are remotely useful is on a list where all visible controls are disabled and the tab stop property is off. You might comment that with this set up the form is pretty useless; well, yes, unless this is a main form for a sub form (or another synchronized form) showing data related to the current record indicated by the record selector.
    Rod

    fe_rod@hotmail.com

  4. #4
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404

    Record selectors

    I used to use them on continuos forms, until a user managed to highlight several records, delete them and then complained that the databas was deleting the records all by itself!

    I then replaced the record selectors with delete, and other buttons.

    Moral of the story - never underestimate the end user!


  5. #5
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    998

    Talking

    Quote Originally Posted by LisaChow
    Just a question, but I've been wondering this for years. What is the point of the record selector bar on forms? I always turn them off. I can't see a use for them, especially for users.
    Hi LisaChow,

    Just for the purpose of some very basic users, they tend to like them so that they can either Highlight a line as they do in Excel (which so many people tend to use and like), and also makes it easy for some of them to select a record for Deletion (although they shouldn't have that much power..hehe). Always think about those less educated or maybe just not on our level of thinking in database design and usage. But see how easy it is to turn them on and off.

    have a nice one,
    Bud

  6. #6
    Join Date
    Aug 2003
    Location
    Cleveland USA
    Posts
    184

    Smile

    I can see the Excel connection, but I've had some users with very limited computer skills, and all were able to use the subforms just fine without them. Maybe it's because I never gave them a choice. When they are allowed to delete records on a continuous form, I have a "Delete" button that repeats for each record, so they click the Delete button next to the record they want to pitch. Access has a lot of options I've never used, but this one is especially annoying because its default is 'on'.

  7. #7
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404

    Defaults

    Maybe it's because I never gave them a choice
    Quite right too. Giving users too much freedom is dangerous and not usually helpful to them. Your delete button solution is one I would wholeheartedly recommend. (It deosn't mean, by the way, that you regard users as idiots.)

    And yes Access does seem to have some odd defaults, maybe there is a good reason for them, but I can't think why the record selector is defaulted to on, unless Microsoft realise that no-one would use it if it defaulted to off.


  8. #8
    Join Date
    Aug 2003
    Location
    Cleveland USA
    Posts
    184

    Smile

    No, the users aren't idiots, I just like to use what's more intuitive. And I like programming a delete button because I can change the "Are you sure" message to something more specific, such as "Are you sure you want to remove JOHN SMITH from the database?" to get their attention.

  9. #9
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by LisaChow
    No, the users aren't idiots, I just like to use what's more intuitive. And I like programming a delete button because I can change the "Are you sure" message to something more specific, such as "Are you sure you want to remove JOHN SMITH from the database?" to get their attention.
    Sorry to say this Lisa BUT THEY ARE! I use the record selector for 1 purpose: To select the record. I disable Addition and Deletion in my continuous forms (for obvious reasons - least of which is that I use disconnected recordsets and have a FE/BE setup ...) All other selection capability I provide thru comboboxes or listboxes ...
    Back to Access ... ADO is not the way to go for speed ...

  10. #10
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404

    Users idiots?

    No, the users aren't idiots ...
    Sorry to say this Lisa BUT THEY ARE!
    I've had a user who deleted numerous records and told everyone that the database did it all by itself. I wrote a bit of code to trace when records were deleted and by whom. The next time a bunch of records were deleted I was able to show here that she had deleted them, and when.

    She then found other ways to enter inaccurate data (surnames and forenames in wrong fields etc.). Eventually we had to stop using the database.

    I don't think she was an idiot, just a malicious individual who didn't want to use a database (it threatened her 'indespensible' position). I doubt if anyone can program a database to protect against such a person, but once I accepted that she was malicious I was able to write code to offer some protection (backing up deletions automatically, tracing activity in the database etc).

    It's not the genuine users you need to worry about - it's the malicious ones!

Posting Permissions

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