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 derfloh 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: GNorman
  • Content: Threads
  • Order by date
  1. GNorman

    DLookup to get three values from a table

    I've learned to bypass Recordsets by using DLookup when I need to get a value from a field in a table and store it in a variable. If I need to get three fields into three variables from the same table for the same criteria is a trio of back-to-back DLookups the right way or should I crack open a...
  2. GNorman

    Correct method for comparing data in two tables

    I have 2 tables. Table A contains records for a unique key field. A record for the same key field should exist in Table B, and B contains a "pipelength" field whose value should match the "pipelength" field in A. 1-to-1 relationship between A and B. 1) I need to verify that all records in A have...
  3. GNorman

    When and how to open recordsets

    I'm creating a small app that makes updates to a table based on user input. So I'm trying to open recordsets in a way that the Sub can see them every time the user inputs data. When I open the form and immediately close it I get a runtime error 91: "Object Variable or With block variable not...

Part and Inventory Search

Back
Top