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

    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

    Datura654

  2. #2
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    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,
    BUD
    Attached Files Attached Files

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    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;

    izy
    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
  •