Search results

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...

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...

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 =...

I have a form to create a new record in an Invoice table. I have a combo box to a linked table for the Invoice Status. The link between the two tables is the invoice number. I can select a status in the combo box but when I save the new invoice record, the record in the linked Invoice Status...

I have a form with a subform. On the parent form, there is an unbound text box that calculates the total of the records on the subform. On the subform, on a double-click on a record, a form opens to edit or delete the record clicked. There are two buttons on this subform, one to save the record...