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!

  • Congratulations Wanet Telecoms Ltd 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: *

  • Users: BOONEY
  • Content: Threads
  • Order by date
  1. 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...
  2. 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.
  3. 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 #...
  4. 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 #...
  5. 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