Search results for query: *

A reply to a previous post got me so much closer to my goal, but I'm not quite there. The project is to create an estimate. I have an estimate main table, and a table for line items for the estimate, and another for the Material data. For various reasons we want to save the current cost...

I'm sure this is the most basic of questions, but it's been a long time since I've used Access and I just can't figure this one out. One table I have is to keep data for a cost estimate. I've created a subform for the estimate line items. The table used by the subform has among others the...

I have a table for Purchase Orders with PONumber, POEmployeeNo, POJobNo, and POInvoiceCost (there are other fields, but they aren't relevent here). POEmployeeNo is linked to an Employee table which includes EmployeeName. POJobNo is linked to a JobInfo table which includes JobName. During the...

For this project we have a purchase order record. When the purchase order is initially created, some key information is entered such as employee id, supplier id, date, and job site information. One form has been created to enter that data. There are some additional fields in the table for...

I have a table with an autonumber key value "RECNO". It's basically just a sequence number for the record. On the form for data entry to the table, RECNO is displayed, but there is no tab stop since the user won't need to change the value. I put an "add record" control...

I have a table that has a field, "sequence" that is the key and an auto number. A second field, "PONumber" needs to default to the value of "sequence", but be editable so the user can override if needed. My first problem is when I add a new record...