Search results

I have a database for a small repair shop. When repairs are made, staff members enter a service ticket, which has a Service ID autonumber. At a later date, this Service ID # is added to an Invoice. The Invoice Number is not an autonumber (not my design or choice). This is done on a form with a...

Greetings all. I have a main form and a subform. On the mainform, when a user enters data, the "Save Record and Return" Button has the typical code: If Me.Dirty = True Then If MsgBox(" Save Changes? ", vbYesNo) = vbYes Then Me.Dirty = False Else Me.Undo...

Greetings and Happy New Year all. I'm having a problem with using a Lookup to bring the Customer ID and Customer's name from a Customer's Table into a Products table. So in the Products table, I have a lookup field: SELECT tblCustomer.CustomerID, [Lastname] & ", " & [Firstname] AS CustomerName...

Greetings all. I have a simple form with one unbound (combobox) and 4 bound (test boxes) controls. The form has a query as it's control source. I need to have the form open to a blank record, but it opens to the first record. I've tried: Call DoCmd.GoToRecord(, , acNewRec) in the Open Form...

Greetings all. I have a Customer database with almost 20,000 records. There is a form with 3 cascading combo boxes to select the State, City, and Address in order to locate a specific customer. All the comboboxes work correctly, the only issue I have is that with this many records, some of the...

So in the attached database, as you can see there is a table and 2 forms. The CustomersList form opens showing general information, and then the CustomerDets form can be opened from the "Open" link on the CustomersList form, which is how the program is supposed to operate. When done this way...

So I have a simple query where I want to count the number of (for example) orders and take the average of the cost of the orders. The query runs fine, but when I create a form based on the query, the count field is OK, but in the average field a #name? error is displayed. I've verified that the...