User Profile

Collapse

Profile Sidebar

Collapse
rch2
rch2
Last Activity: Mar 23 '07, 01:14 PM
Joined: Mar 22 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rch2
    replied to Cannot update checkboxes with an update query in access 97 - help!!
    in Access
    Sorry, I meant to say that I have typed in the 'Update to:' section, not the 'criteria' section. So:

    All checkboxes are currently empty (ie: FALSE).

    I want to update them all to checked (ie: TRUE).

    In the update query design I have the following:
    Update to: [fieldname]=TRUE
    Criteria:FALSE

    When I run this, it tells me it is updating all records, but when I go to the table...
    See more | Go to post

      Leave a comment:

    • rch2
      started a topic Cannot update checkboxes with an update query in access 97 - help!!
      in Access

      Cannot update checkboxes with an update query in access 97 - help!!

      Hi,

      I'm trying to use an update query to update a checkbox field in access 97.

      In the update query design I am indicating in criteria:
      [fieldname]=true

      When I run the update query, a message box appears saying "You are about to update xxx records. .... Are you sure you want to update these?" to which I click yes.

      However, when I check the table, none of the checkboxes...
      See more | Go to post
      No activity results to display
      Show More
      Working...