Recent content by Tskutnik

  1. T

    Min Across columns

    Hi All, A simple question I'm stuck on. Every Answer I can fin has 200 lines of code. I dont need or want code, just the correct syntax for the following. IN each row in a table, I want to find the Max value across the following three columns [Col1], [Col2], [Col3] Something like...
  2. T

    Stop Auto size column width

    I see what you mean. I think I can "cheat" this with the background colors, but I'll still need to keep the headers aligned with the data below. Thanks
  3. T

    Stop Auto size column width

    Issac - sorry I don't know what this means. I just want to freeze the column width
  4. T

    Stop Auto size column width

  5. T

    Stop Auto size column width

    Header box still changed width, but it did not impact any other field since they are not linked together. Looks like tis now. Still not what I need. I dont want them to resize at all
  6. T

    Stop Auto size column width

    Not sure how I remove the Layout and keep my column headers and values aligned
  7. T

    Stop Auto size column width

    I'll try that. Thanks
  8. T

    Stop Auto size column width

    Below is part of the Form. If I change the header "> 20% Flow" to "20%" the entre column auto sizes the that new width for the 3 characters, which is narrower than the data in that column. I want to fix the column widths and not have it resize.
  9. T

    Stop Auto size column width

    All, hopefully easy one. Cant find the answer without writing lines of code. This has to be easy. I want to stop my form from auto resizing the column widths when I make a change to the header text (or for any other reason). Thanks
  10. T

    Macro to open Form to a specific record

    Ah - I out thought myself. I tried all 3 and they give the correct info for the given row I click
  11. T

    Macro to open Form to a specific record

    Sorry - not 100% what you meant in the MSGbox. But unless you can get anything out of the macro image, I'm going to play around with something. I need to improve my unique keys, which may solve this problem. Hold tight.
  12. T

    Macro to open Form to a specific record

    Child for opens, but displays all. I should have said Continuous Form (looks like a Table), not a Datasheet. Button on right Like This:
  13. T

    Macro to open Form to a specific record

    Yes, from the button on the row in the datasheet. Convert to SQL maybe?
  14. T

    Macro to open Form to a specific record

    Not on a unique Key or ID, no. My thought was the 3 criteria makes the record unique so if I match all 3 I'd be good.
Top Bottom