Recent content by phoust

  1. P

    Solved Filter data to left of character using Left and InStr functions

    That worked. Thanks!
  2. P

    Solved Filter data to left of character using Left and InStr functions

    I have an invoice number that is a combination of a sale # , a "-" and a ID number. Example: 388-LA142. I am trying to select all the invoices that start with a specific sale#. I have an unbound text field where I specify the sale#. I keep getting a type mismatch and I can't figure out how to...
  3. P

    Update field with last payment date

  4. P

    Update field with last payment date

  5. P

    Update field with last payment date

  6. P

    Update field with last payment date

    I'm getting an #Name? error. I've checked the field names and they are correct. I put this as an expression in the control for an unbound text box and set the format of the box to Short Date. I can't figure out what I am doing wrong.
  7. P

    Update field with last payment date

    I tried the DMax function but I'm having trouble with the syntax. Private Sub Form_Load() Me.LastPaymentDate = DMax("PmtDate", "InvoicePmt", "InvoiceNo = " & Me!Invoice) End Sub This date will show on the invoice form and also on a list of invoices ready to ship. If I use an unbound text...
  8. P

    Update field with last payment date

    Actually this is what I have. There is a separate payment table. We want the last payment date to show on the invoice form and on a list of paid invoices ready to ship so we can prioritize the shipping by final payment dates.
  9. P

    Update field with last payment date

    I have an invoice table with a LastPaymentDate field. Payments are entered into InvoicePmt table from a NewPayments form. There can be multiple payments for an invoice. I am trying to update the LastPaymentDate field on the invoice with the date of the most recent payment. I thought I could do...
  10. P

    VBA code with Date() function not working in runtime mode

    The change to Me!QuoteRequestDate.Value worked. Thank you!
  11. P

    VBA code with Date() function not working in runtime mode

    OK. I'll give this a try and let you know.
  12. P

    VBA code with Date() function not working in runtime mode

    There's no error message, I just can't open the form this appears on.
  13. P

    VBA code with Date() function not working in runtime mode

    I have an invoice form with a combo box to update the status of the invoice. The following code is triggered After Update. If Me.StatusGroup = "QUOTE" Then Me.QuoteRequestDate.Visible = True Me.QuoteRequestDate.Value = Date Else Me.QuoteRequestDate.Value =...
  14. P

    Create record in linked table

    Thanks for all the responses. I'm going to put the status code in the invoice table. I am new with Access and I appreciate the input.
  15. P

    Create record in linked table

    The invoice records are imported from a csv file which does not include a status.
See more
Back
Top Bottom