Search results

  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.
  15. T

    Macro to open Form to a specific record

    There is something in the Parent. That form is a Datasheet and the buttons to call the Child are on each row. Seems it is not recognizing the specific row in the Parent to pick from in the Child... Or maybe not. The 3 criteria being used should get me to the specific record in the Child
  16. T

    Macro to open Form to a specific record

    Thanks DB - as always. Something is still not working though. It is still not going to the correct Child record. I'm checking some obvious things....
  17. T

    Macro to open Form to a specific record

    All, Syntax problem somewhere. Any help is appreciated. In a button on the "Parent" form Macro I have the following, meant to open the "Child" Form to same record selected. I have this working with using one criteria t find the Child record, but combining the 3 fields is giving me trouble. The...
  18. T

    Delete Query Issue

    OK so if by extension the read only Union query makes the delete query read only I kinda get it, although again, I'm deleting FROM a totally separate table. I can work around this either way. Thanks for all the help
  19. T

    Delete Query Issue

    isladogs - thanks, but again, I'm not deleting FROM the union query. I'm deleting from an unrelated table, with the Union query used to ID the records to delete from the table. The union query is definitely read only
Top Bottom