One Check box or Two

Discussion in 'Access Table Design' started by Cagney, Nov 23, 2010.

  1. Cagney

    Cagney Guest

    I have a situation where I get information sent to me via email.
    I have to verifiy that account info is Valid or Not Valid. So I have a
    check box that the user clicks to confirm the status. Upon clicking
    the checkbox I have code fill in 2 fields DateVerified and VerifiedBy.
    My dilemma is when the account is NOT valid, the user simply does not
    do anything, leaving the checkbox UNChecked. Therefore my code does
    not fill in the fileds that indicate When and Who verified the
    account. So I am thinking of adding a second check box called InValid
    forcing the user to click only one box. This way if both boxes are
    unchecked I then know that no one has verified these accounts yet.
    Is there another way to handle this?
    Thanks for the help.
    Cagney
     
    Cagney, Nov 23, 2010
    #1
    1. Advertisements

  2. Cagney

    XPS350 Guest

    On 23 nov, 17:48, Cagney <> wrote:
    > I have a situation where I get information sent to me via email.
    > I have to verifiy that account info is Valid or Not Valid. So I have a
    > check box that the user clicks to confirm the status. Upon clicking
    > the checkbox I have code fill in 2 fields DateVerified and VerifiedBy.
    > My dilemma is when the account is NOT valid, the user simply does not
    > do anything, leaving the checkbox UNChecked. Therefore my code does
    > not fill in the fileds that indicate When and Who verified the
    > account. So I am thinking of adding a second check box called InValid
    > forcing the user to click only one box. This way if both boxes are
    > unchecked I then know that no one has verified these accounts yet.
    > Is there another way to handle this?
    > Thanks for the help.
    > Cagney


    You could make one field with 2 (or 3) possible values: Valid, Unvalid
    (if you want Unchecked). When the value of the field is changed to
    Valid or Unvalid, you fill the other fields.

    Groeten,

    Peter
    http://access.xps350.com
     
    XPS350, Nov 23, 2010
    #2
    1. Advertisements

  3. Cagney

    Pat Hartman Guest

    Rather than creating a second checkbox, you could replace the first with an option group with two options. The option group can be designed to show checkboxes or radio buttons which ever looks best to you. Your code looks at the option group itself rather than the individual options. The options must be numeric and unless you have some objection,the first option should be 1 and the second should be 2. If the option group control = 1 then the first option was check, otherwise, the second (or neither) option was checked.

    > On Tuesday, November 23, 2010 11:48 AM Cagney wrote:


    > I have a situation where I get information sent to me via email.
    > I have to verifiy that account info is Valid or Not Valid. So I have a
    > check box that the user clicks to confirm the status. Upon clicking
    > the checkbox I have code fill in 2 fields DateVerified and VerifiedBy.
    > My dilemma is when the account is NOT valid, the user simply does not
    > do anything, leaving the checkbox UNChecked. Therefore my code does
    > not fill in the fileds that indicate When and Who verified the
    > account. So I am thinking of adding a second check box called InValid
    > forcing the user to click only one box. This way if both boxes are
    > unchecked I then know that no one has verified these accounts yet.
    > Is there another way to handle this?
    > Thanks for the help.
    > Cagney



    >> On Tuesday, November 23, 2010 3:28 PM XPS350 wrote:


    >> You could make one field with 2 (or 3) possible values: Valid, Unvalid
    >> (if you want Unchecked). When the value of the field is changed to
    >> Valid or Unvalid, you fill the other fields.
    >>
    >> Groeten,
    >>
    >> Peter
    >> http://access.xps350.com



    >> Submitted via EggHeadCafe
    >> Microsoft LINQ Query Samples For Beginners
    >> http://www.eggheadcafe.com/training...erators/33/LINQ-Standard-Query-Operators.aspx
     
    Pat Hartman, Jan 3, 2011
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Ilan Sebba

    How can I have only one one-2-one?

    Ilan Sebba, Oct 25, 2003, in forum: Access Table Design
    Replies:
    7
    Views:
    221
    Ilan Sebba
    Oct 26, 2003
  2. Marian

    Ticking only one check box in a record

    Marian, Jun 16, 2004, in forum: Access Table Design
    Replies:
    1
    Views:
    134
    Duane Hookom
    Jun 16, 2004
  3. daco3000

    How do you get spell check to check before sending?

    daco3000, May 10, 2005, in forum: Access Table Design
    Replies:
    1
    Views:
    130
    Rick B
    May 10, 2005
  4. mscertified

    Relationship one-to-one or one-to-many

    mscertified, Nov 3, 2005, in forum: Access Table Design
    Replies:
    3
    Views:
    122
    Pat Hartman\(MVP\)
    Nov 4, 2005
  5. Geometra76

    export two queries to two tabs in one excel file

    Geometra76, May 12, 2006, in forum: Access Table Design
    Replies:
    11
    Views:
    155
    Ken Snell \(MVP\)
    May 17, 2006
  6. Maarkr

    One to one with two joins? Not...

    Maarkr, Aug 8, 2007, in forum: Access Table Design
    Replies:
    2
    Views:
    96
    Jamie Collins
    Aug 9, 2007
  7. RipperT

    Two one to many's on one table

    RipperT, Dec 3, 2008, in forum: Access Table Design
    Replies:
    1
    Views:
    105
    Tom van Stiphout
    Dec 4, 2008
  8. Harriet
    Replies:
    11
    Views:
    195
    Harriet
    Sep 14, 2009
Loading...