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

    Transpose Rows and columns

    I tried the pivottable, but I can't have the user enter data, only view it. Thanks for the suggestions.
  2. DrKeith

    Transpose Rows and columns

    Hi, I would like to have a form with a datasheet view but would like to transpose the rows/columns. I need the variables to be on the y axis and enter data down each column (date for example). Is there a way to do this? There is a microsoft KB to display a transposed table, but I need data to...
  3. DrKeith

    Reference main form

    Thanks Remou.
  4. DrKeith

    Reference main form

    Hi, I am inserting a subform (frm_switch) into many main forms (frm_main1, frm_main2, etc). Is there a way to reference the main form from the subform without using the name of each form? I tried using Screen.ActiveForm in the code of the subform , but this just refers to the subform. Dim...
  5. DrKeith

    SQL query help

    I am trying to write a SQL query to return a row with the most recent date. There are many other columns, but this is a sample. I need to group by the ID field, and want to return the row with the latest contact date for each ID. For the sample below, I would need to return rows 2 and 6. I...

Part and Inventory Search

Back
Top