Search results

  1. F

    Update Table Field with Sum Query

    Thank you to all, I used DavidatWork sugestion, and it worked. LPurvis, I have to show the running total in the subform because the payment can apply to more than one invoice, so the running total is of the portion of the invoice paid. Thanks.
  2. F

    Update Table Field with Sum Query

    This is my problem: Table Invoice: InvoiceId CustomerID Total_Invioce (Double) Table Payments: PaymentId PaymentType ... So, one payment can distributed in more than one invoice, and payments might be partial. I created a table InvoiceVsPayment: InvoiceID PaymentID PaymentPart: stores the...
  3. F

    Validation Code Textbox.Value vs. Number

    It worked, I also needed a good source for text conversion function. Thank you!!!
  4. F

    Validation Code Textbox.Value vs. Number

    I have the following code to validate that the value entered in a text box is less than the amount in another text box: Private Sub TxtPaymentAmount_AfterUpdate() Dim LResponse As Integer If TxtPaymentAmount.Value > TxtPOTotal.Value Then LResponse = MsgBox("Payment Amount is greater...
Back
Top Bottom