Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004

    Smile Unanswered: reset field for a group of records

    Hi there guys,

    I am working on a membership database form which contains a control called [INVITE] containing the values YES or NO. The user periodically chooses different records and sets the control to YES. When they have finished with this group of records I want to be able to reset the control [INVITE] back to NO.

    I have created an update query which will isolate the records but I can't seem to reset all the records in one action. I need to be able to put the action on a command button.

    I need to be able to write a macro which will;

    1) isolate all records where INVTE = YES
    2) reset this field to NO.

    ANy ideas? I need to have this done for Tuesday. Any help from you Access Gurus would be great.

    Thanks guys


  2. #2
    Join Date
    Dec 2003
    Dallas, TX
    Hi datura654,

    Not being very sure of how your database works, take a look at the sample db I made and posted here. Might not be exactly what you wanted but thought I'd give it a try. If it doesn't work, hang on and someone else will certainly be around soon.

    have a nice one,
    Attached Files Attached Files

  3. #3
    Join Date
    Dec 2002
    Préverenges, Switzerland
    try typing something like this in the SQL view of your query (which one to use depends on the datatype of Invite in the table):

    if Invite is string:
    UPDATE nameOfYourTable SET Invite = 'NO' WHERE Invite = 'YES';

    if invite is boolean:
    UPDATE nameOfYoutTable SET Invite = False WHERE Invite = True;

    currently using SS 2008R2

Posting Permissions

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