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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by TSchrupp

  1. TSchrupp

    No current record error from transpose

    I'm trying to create a module to transpose a table. Testing the module using CTRL+G and "?Transposer("Table 1","TableTrans") in the "Immediate" pane results in an error "3021 No Current Record" and the resulting table has the first field filled...
  2. TSchrupp

    "Rotate" table in query

    I made an error in the new format for this query. It should be Item Contract Date1Amount Date2Amount ... Field1 A 0.00 0.00 Field2 A 0.00 0.00 Sorry for the confusion Tim
  3. TSchrupp

    "Rotate" table in query

    Hi all, I have a table linked from another db with this structure: Date Contract Field1 Field2 Field3 ... 1/1 A 0.00 0.00 0.00 I need to select the the FieldX column names as data, with the corresponding data as a row into this format: Item Date Contract...
  4. TSchrupp

    Problem with Dlookup

    I'm a relative newbie to this, so any assistance will be appreciated. I am attempting to write a VBA module to populate a combo box with a list of valid data based on input from a previous field. My problem is that the module returns only the value for the first record in the lookup table...

Part and Inventory Search

Back
Top