Comments by qulaitks - CodeProject

qulaitks 20-May-23 7:02am View

Thansk, I have tried that and the output is similar to the previous code using the FIRST_VALUE

qulaitks 19-May-23 8:56am View

I have tried your corrected code and had different output than yours
TransID XCost NewCost BPrice
37 49700.00 49700.00 49.700000
37 24850.00 24850.00 49.700000
37 52674.00 52674.00 48.236263
37 29174.00 29174.00 49.280405
37 29174.00 29174.00 36.975918

qulaitks 9-Jan-21 3:15am View

I have updated the quetion and removed the link.

qulaitks 8-Jan-21 1:52am View

The promblem I had is I bought 1000 share by 49.7 then sold 500 by 50.6 then bought 592 with price of 47. How could I calculate the weighted average price.

qulaitks 1-Jun-20 2:25am View

DGV cell(0) holds int values and Cell (1) bit. Regards

qulaitks 1-Jun-20 1:39am View

Thanks for the reply, the above code will highlight all cells in DGV the have "Buy" Value. What I wand is to compare the Cell(0) rows value if no matched value the look into cell (1) for "Buy" or "Sell" . Best Regards

qulaitks 16-May-20 13:18pm View

I have tried it and is not shown any code error. The error I am having is when i cell click the DGV , its something to do with null-able values.

qulaitks 16-May-20 10:20am View

Cell(0) is holding the ID which is auto generated

qulaitks 16-May-20 10:13am View

The computed cell is cell(9), when I click the DGV the rows 1 to 8 values suppose to show in the related textboxs

qulaitks 18-Jan-20 3:52am View

Thanks it works .

qulaitks 8-Sep-19 23:40pm View

Good morning
I am having this problem when trying to assign last day of the month.
SalesDatePicker.Value = DateSerial(SalesDatePicker.Value.Year, SalesDatePicker.Value.Month, 1).Addmonths(1).AddDays(-1).

qulaitks 7-Sep-19 21:46pm View

Good Morning

I am using the DTP that has format (MMM-yyyy) to filter DGV , the code above works fine if months days are the same , as soon as the months days changes from say 31 to 30 , I receive the erroe massage. Sorry if i did not explain things right.

best regards

qulaitks 7-Sep-19 5:50am View

Thanks OriginalGriff for the quick respond. I have tried the given code but still reciving the same error massage.

regards

Comments by qulaitks (Top 13 by date)