Results 1 to 9 of 9
  1. #1
    Join Date
    Jan 2014
    Location
    Ithaca, NY
    Posts
    4

    Unanswered: Newbie question: How to select/export only "checked boxes" or TRUE values

    Hello,
    I'm hope and assume this is an easy Access database question for this forum, since I don't have a lot of experience with it. Apologies in advance.

    I have an Access DB which is a list of peoples names, addresses, etc,. and some special information associated with each person listed in columns with check boxes. Checked boxes = TRUE and Unchecked boxes = FALSE.

    See attached screen shot showing part of the DB I'm referring to.

    I need to select (and eventually export the selected) only the checked boxes in the "poster" column.

    I've tried everything I can think of, browsed the help menu with no luck. Searched here and didn't find this addressed on these forums.

    Thanks in advance for any help!
    - Sheri
    Attached Thumbnails Attached Thumbnails check-box-fields.jpg  

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You'd use a query, with

    True

    in the criteria for that field.
    Paul

  3. #3
    Join Date
    Jan 2014
    Location
    Ithaca, NY
    Posts
    4
    I tried creating a query.

    Using the Simple Query Wizard and selecting the poster field. From there it is not obvious what to do next in order to tell it I want only the checked or TRUE values from that column to export.

    Good to know I'm on the right track... and tips on how to connect the dots would be great. Thanks.

    Sheri

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Not sure how to say it any better. Put

    True

    in the criteria row under that field.
    Paul

  5. #5
    Join Date
    Jan 2014
    Location
    Ithaca, NY
    Posts
    4
    I've done this and when I hit "run" only that column appears on the new table. No other info. I need to see the Names and addresses... etc.

    Thanks for pointing me in the right direction.
    I'm going home to have a margarita now.

  6. #6
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You would add whatever fields to the query that you wanted to see. Once that query shows the fields you want and filters as desired, you can use it for reports or export.

    Margarita sounds good; wish I could have one right now.
    Paul

  7. #7
    Join Date
    Jan 2014
    Location
    Ithaca, NY
    Posts
    4
    I think I got it to work!

    One confusing thing: the table that output from the query has -1 in the column where I expected there to be either checked boxes or the word TRUE.

    I just need to confirm the -1 means TRUE, but I suspect it does.

    Thanks for helping a novice over here.
    -Sheri

  8. #8
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Happy to help Sheri! Yes, Access stores true as -1 and false as 0.

  9. #9
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ...but always always use the vb constants instead of -1 or 0, as thats down to implementation and could change at any time

    use vbtrue / vbfalse or true / false

    its unlikely that therse thigns will change in the medium to short term, but by using implementation specific values you always make your code prone to probelms over time. if you use true or false then that will never break.


    if the implementation does change then you can easily skip over such code thinking its alwasy worked in the past..
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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