Search results

EB - WOW! Perfect. Thanks very much, it's exactly what I needed. You saved me countless hours on the details for this. Greatly appreciated.

Hi all, sorry for the delayed response. I was trying to figure this out without bothering all of you, but no dice. The concept is kind of simple, but I need help with the execution. Requirement: Calculate a running total of values from a table using values from multiple rows, and paste...

This gets me in the right direction, thank you very much. Still not sure how to get this to really work so in a few minutes I'm posting a DB with some questions.

Strange. Im posting a DB so maybe that will work better. ty

Hi all, this is an old thread I need to revisit. Slighty revised. For matching accounts and securities: I need to calculate the difference in a stock price from one day to another, and create a cumulative return over time. I get that this is more of an excel-style function, but I know it is...

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

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

Issac - sorry I don't know what this means. I just want to freeze the 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

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

I'll try that. Thanks

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.

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

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

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.

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

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

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.