Search results for query: *

Thank you to all for your help. Adding the .Value to the syntax did make the difference.

I guess I didn't word that too well. Yes there are controls on the subform, I just changed the data source from the EID table fields to the combo box column data - mostly to make sure I really did have the column numbers correct and to make sure I could display the data. When I had them as the...

The EID controls are on the subform - or at least they were originally. I temporarily took them off to see if I could get the data to display on the subform using the cmbMaterialID.column(x). I want them to be on the subform and have the values assigned to them somehow. These will be display...

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

Thank you for the information. I believe that all of my tables are related correctly. I can bring up the relationship "picture" and see all of my links from the key field in one record to the corresponding related field in the other. I gave a very simplistic description of the total...

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

Thank you for the suggestion. I'm trying to implement your idea, but having problems. I've a feeling I bit off a bit more than I should have in agreeing to do this project for a friend (ie: I'm an obvious non-expert in Access programming). I keep getting the message "missing operator in...

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

The reason for the two fields is that most of the time PONumber will just be the next number in sequential order but sometimes the customer may need to change that to some other value. So the thought was to have a key field that incremented and a second field that was set to same value but was...

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