Search results

  1. C

    Macro that adds 1 to table value

    I see it now. The set warnings action in macros was hidden. All good now. Turn off before query and on after. I appreciate the help.
  2. C

    Macro that adds 1 to table value

    Ok I got the first one. I should be okay Criteria for InvoiceNumber: [Forms]![invoices-customer]![InvoiceNumber] Still working on the update query warnings suppressions
  3. C

    Macro that adds 1 to table value

    Ok I get the idea but I have two issues. 1. How do I get a value from the current form into the query so that it only updates the table row that's open in the form? I know where it goes in the query (criteria). In the update query I add two columns: Update PrintCounter = PrintCounter+1...
  4. C

    Show Text on Form IF

    woaaa! nevermind the second question. i got it. :-) both go in the code box for the form itself. thanks a lot.
  5. C

    Show Text on Form IF

    Sorry that I'm inexperienced but I hope you give me some more direction. What I did was go to the VB code screen and insert two new modules. Paste the code into each. Then for the check box "cancelled" in event, after update I put: =Cancelled_AfterUpdate() It's giving me an error that it...
  6. C

    Macro that adds 1 to table value

    Hello, Yes, add 1 to the table value permanently. The form uses a query of a couple tables so the value I want to update is right there. If you hit the print button it adds to the counter. For this, printing from the form seems fine (looks good). Thanks.
  7. C

    Show Text on Form IF

    Guys/Gals: I have a form with a check box called "cancelled". That is bound to a field that stores the value. Works fine. I want to be able to show large text across the form saying "CANCELLED" if the check box is active (table field cancelled = true) for this record. Any help would be...
  8. C

    Macro that adds 1 to table value

    Hello, I have a form with the access included macro to print selected record from form. I want to add a step to the macro that will update a field in the form's query to +1. Any help would be greatly appreciated. Thanks
  9. C

    Use Value in Form for Combo Box Query

    Resolved. Thanks anyway. [Forms]![account info form]![ID] OR < 1
  10. C

    Use Value in Form for Combo Box Query

    Hello, I have a form with Field1. I have a combobox in the form. I need to get the value from Field1 in order to implement it in the query for the combobox. Basically I want to filter the combobox list to show unused (unmarked) rows in a table. However, since the current record in the table...
  11. C

    Set field to dropdown and specify values to display

    Ok...It's a combo box. Resolved. Thanks for reading.
  12. C

    Set field to dropdown and specify values to display

    My mind is blocked even thought this would seem pretty simple... The form shows one record at a time of a Query. The Query is made up of two tables where EyeColorID fields intersect. In the form I don't want to show the EyeColorID (1,2,3) from either table. I just want to pick from the colors...
Back
Top Bottom