Search results

That worked. Thanks!

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

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

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.

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

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

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

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

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

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.

The invoice records are imported from a csv file which does not include a status.

The invoice records are imported into the invoice table from a csv file, so I can't have the status in the invoice table.

There are approx 20 different statuses. There is a field in the Status Lookup table with another field that groups these status codes into different groups. I am then able to pull up lists of invoices by the status group.

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