Results 1 to 4 of 4
  1. #1
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226

    Setting a Yes/No check box problems

    I am trying to use a update querry to set a Yes/No check box. in a table. to all yest and the to all now.

    UPDATE [Name-Address] SET [Name-Address].Requires_Printing = No, [Name-Address].[Do NOt Print] = No, [Name-Address].[has been Printed] = "yes"
    WHERE ((([Name-Address].F_Name) Is Not Null));

    It is finding what I want changed but not changing the field to Yes

    It is not working, any suggestions?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Does taking the quotes out from around "yes" help?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226
    I tried both with and without quotes.
    The query finds all the data that I am looking for but does not change the Yes/No box.

  4. #4
    kennejd is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    188
    Try -1 or true.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help with setting up database
    By peachesflora in forum Database Design
    Replies: 1
    Last Post: 02-22-2011, 05:02 PM
  2. Setting SQL = string
    By jasonbarnes in forum Programming
    Replies: 7
    Last Post: 02-18-2011, 11:02 AM
  3. Setting up new database
    By mduplantis in forum Database Design
    Replies: 1
    Last Post: 06-23-2010, 11:07 AM
  4. To check or Un-Check all Boxes in a form
    By devcon in forum Forms
    Replies: 7
    Last Post: 05-01-2010, 12:03 AM
  5. Replies: 0
    Last Post: 01-08-2009, 05:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums