Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BOONEY

    Main Form and Sub Form For Data Entry

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

    Main Form and Sub Form For Data Entry

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

    VALIDATION RULE PROBLEM

    Thank you very much Bob.
  4. BOONEY

    Main Form and Sub Form For Data Entry

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

    VALIDATION RULE PROBLEM

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

    VALIDATION RULE PROBLEM

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

    Populating a field value of one table with a corresponding table value

    Thank you for your excellent response
  8. BOONEY

    Access 97, Populating a field in one table with a value from anther

    Thank you for your help.
  9. BOONEY

    Populating a field value of one table with a corresponding table value

    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 #...
  10. BOONEY

    Access 97, Populating a field in one table with a value from anther

    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 #...
  11. BOONEY

    AUTOMATIC FIELD UPDATE IN A TABLE

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

    AUTOMATIC FIELD UPDATE IN A TABLE

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

    AUTOMATIC FIELD UPDATE IN A TABLE

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

Part and Inventory Search

Back
Top