Search results

  1. R

    Update with where clause

    Brill! Thanks Kiwiman! Rach
  2. R

    Update with where clause

    Thanks Paul but I'm getting a 'datatype mismatch in criteria expression'? Rach
  3. R

    Update with where clause

    Thanks Kiwiman but I'm getting a syntax error! Tried moving the speech mark after = to the end but that didn't work either? Rach
  4. R

    Update with where clause

    Hi, I have a Loans form and an Equipment table. I would like the 'Available' checkbox in the Equipment table to be unchecked when when the user clicks the 'Submit' button on the Loans form (i.e. when an item is loaned out) - but I only want the checkbox corresponding to the item (Equipment ID)...
  5. R

    Auto update checkbox in table onclick

    Thanks DJkarl! You're right I am going to need a where clause :( Looks like its back to the drawing board! Do you know how I can get it to change for only the item they have selected to loan? The field they select is Equipment ID. Thanks again, Rachael
  6. R

    Auto update checkbox in table onclick

    Hi, please help! I am a beginner to VB so please excuse my poor programming. I have an 'Equipment' table with a field 'Available' which has a checkbox assigned, the default value is 'Yes' (checked). I then have a 'Submit' button within a 'Loan' form. I would like it so that when the button is...
Back
Top Bottom