Search results

  1. B

    Dlookup

    I have a control on a subform whose control source is: DLookup("[FullName]","tblUserInfo","[EmployeeID] = " & Me.PreviousOwner) PreviousOwner is a longInteger and EmployeeID is an autoNumber. On another form when ownership of equipment changes hands, I simply pick another user from a...
    • Bob M
    • Thread
    • Replies: 4
    • Forum: Forms
  2. B

    Passing Combo box value to another form

    I have a combo box on a subform. When I enter a value in the combo that is not part of the list I want to launch another form where the user enters the new product. I would like to capture the value entered and pass it to the next screen so the user doesn't need to enter it twice. Since the...
    • Bob M
    • Thread
    • Replies: 15
    • Forum: Forms
  3. B

    Cascading Combo Problem

    I am totaly perplexed. I have a table which among other fields has two. One is ProductID the other is SupplierID. Each product is supplied from a specific supplier. I have a form with a combo box names SupplierID. The rowsource for thois combo box is: SELECT distinctrow...
    • Bob M
    • Thread
    • Replies: 9
    • Forum: Forms
  4. B

    DLookup Problem

    OK here goes. I have three tables: Products, Suppliers and ProductSupplierJoin. Products has the following fields among others: ProductID - Key field VendorProductID Indexed No duplicates Suppliers has the following field among others...
    • Bob M
    • Thread
    • Replies: 3
    • Forum: Forms
  5. B

    Combo Box Requery

    I have a form [Purchase Orders] and a subform [Purchase Orders Subform]. On the 1st form I have a combo box from which the user can select from a list of suppliers. On the subform there is a combo box from which the user can select from a list of products sold by the supplier chosen above. If...
    • Bob M
    • Thread
    • Replies: 5
    • Forum: Forms
  6. B

    Append Query Problem

    I have two tables Products and ProductsSupplierJoin. Both tables have ProductID and SupplierID. I want to append records to the ProductsSupplierJoin table from the Products table using the ProductID and SupplierID fields. I've set up an append query according to the instructions on the...
  7. B

    Cascading Combo Boxes Form and Subform

    I have two tables Suppliers with SupplierID as the primary key and another table Products with ProductID as the primary key and SupplierID as a foreign key linked to Suppliers. I have a form with a combo box SupplierID and a subform with a ProductID combo box. For the SupplierID combo...
    • Bob M
    • Thread
    • Replies: 2
    • Forum: Forms
  8. B

    Report using many to many relationship

    I have 4 tables set up as follows: tblEmployee EmployeeID FullName Department tblInventory EmployeeID IDTag Description SerialNumber tblSoftwareModuleUser (Join table)...
  9. B

    Onnotinlist problem

    I have two tables OperatorMaster and MachineProduction which have a one to many relationship. The tables have the following fields: OperatorMaster MachineProduction OperatorNo OperatorNo OperatorName...
    • Bob M
    • Thread
    • Replies: 2
    • Forum: Forms
  10. B

    Northwind

    I see discussions which refer to the Northwind database as an example. Could someone tell me where the Northwind Database is and how I get to see the examples everyone is talking about.
  11. B

    Lookup on a table based on previous field on a form

    I have a data entry/view form which has a field Machine from a table (tblMachineProduction) and a combo field ProductID from (tblProduct) which will populate the field ProductID in tblMachineProduction. I would like to have the operator enter a machine number and restrict the lookup on the...
Back
Top Bottom