Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    Charleston, SC
    Posts
    11

    Question Unanswered: Resetting all values in one field in a table?

    This is my first post - I'm just glad to have a place to ask my question!

    I thought I saw this answered on Friday, but now I can't find the code... I need to reset all the values in a certain field in a table (back to no) upon exiting the form. Can anyone please help?

    texassprite

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Resetting all values in one field in a table?

    Originally posted by texassprite
    This is my first post - I'm just glad to have a place to ask my question!

    I thought I saw this answered on Friday, but now I can't find the code... I need to reset all the values in a certain field in a table (back to no) upon exiting the form. Can anyone please help?

    texassprite
    Something like:

    UPDATE MYTable SET MyField=False;

    Is this what you're thinking of?

  3. #3
    Join Date
    Jan 2004
    Location
    Charleston, SC
    Posts
    11

    Thanks!

    Thank you so much - I'm just learning all of this. I kinda fell into Access programming by happy accident.

    One more question - is there any way to prevent the user from having to go through the prompts for the update query? I want it to run "behind the scenes" if possible.

    Thanks,

    texassprite

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Thanks!

    Originally posted by texassprite
    Thank you so much - I'm just learning all of this. I kinda fell into Access programming by happy accident.

    One more question - is there any way to prevent the user from having to go through the prompts for the update query? I want it to run "behind the scenes" if possible.

    Thanks,

    texassprite
    What do you mean? Are you creating an update query with parameters?

  5. #5
    Join Date
    Jan 2004
    Location
    Charleston, SC
    Posts
    11

    Yep

    Isn't that what I was supposed to do? You'll have to pardon my ignorance on this - I feel like I'm fumbling in the dark sometimes.

    Is there another way? Would you mind explaining? I do catch on fairly quickly...

    texassprite

Posting Permissions

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