CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. April 1st, 2004, 09:48 AM #1
    High_D
    High_D is offline Member
    Join Date
    Oct 2003
    Posts
    133

    Clearing every record in a field

    I would like to place a button on my access form that would delete all data from a given field. I have a Yes/No field so I can flag various records, but I want to be able to clear them all in one swoop rather than clicking though hundreds of records on a query.

    Can it be done?
    Reply With Quote Reply With Quote
  2. April 1st, 2004, 12:20 PM #2
    M Owen
    M Owen is offline Senior Member
    Join Date
    Jun 2001
    Location
    Mi
    Posts
    1,249
    Yes.

    "UPDATE MyTable SET MyYesNoField=False;"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured