Search results for query: *

Ginger, You are so nice. Thank you very much for your excellent help. Mike

Thank you Ken. I am still a little unclear however. Are you saying to set the control source for these fields to the master table date line and shift? Could you please be a bit more specific as I am new to this. Sorry for being a pain. Mike

Thank you very much Bob.

I am trying to use a main form and a sub form to enter data into 2 related tables. The main table has the fields: Date: Line: Shift: The child table which has the following fields: Date: Line: Shift: Downtime Hours: Reason Code: For every 1 record in the main table, there could be multiple...

Thank you for your response. However, what I am after is to ensure that the end date is greater than the begin date. The begin date is entered first, and then the end date.

I have a table where a "StartDate" and "EndDate" field is entered for each record. I would like to ensure that the "EndDate" entered is always greater that the "StartDate". Both fields are in a general date format. Thank you.

Thank you for your excellent response

Thank you for your help.

I am looking at this from the perspective of data entry into a table or form. An example would be where you have an Item Master table with an Item # and Item Description Field. This table is fully populated with all items and descriptions. In a second table, the user is keying in the item #...

I am looking at this from the perspective of data entry into a table or form. An example would be where you have an Item Master table with an Item # and Item Description Field. This table is fully populated with all items and descriptions. In a second table, the user is keying in the item #...

I am looking at this from the perspective of data entry into a table or form. A simpler example would be where you have an Item Master table with an Item # and Item Description Field. This table is fully populated with all items and descriptions. In a second table, the user is keying in the...

dianemarie, we are working with 2 Access tables. Dreamboat, the weight of the lot is in the "Lot" Table which has lot number and weights. While entering a lot number in the 2nd table, I want the weights for the corresponding lot to populate the weight field in the 2nd table, as I...

Assuming the folling tables and field names Table Name = "Lot" Field 1 = LotNumber Field 2 = Weight Primary Key is Field 1 "LotNumber" This table is populated with lot numbers and weights. Table Name = "LotEntry" Field 1 = LotNumber Field 2 = Weight This is a...