Hi,
I have this code:
Me.List89.RowSource = "SELECT SUM(SumOfNotional) FROM Data WHERE (Grouping='Revenue' And Fund='C179') AND (CC='CC1') HAVING YearOfChange= [forms]![OMRevenueSubgroup2]![Combo17]"
How do I assing the same select value to a Textbox ?
Thanks
Vic
Hi,
I know this is trivial but I stuck. How to multiply the values of 2 listboxes and assign the result to a textbox.
Any help is appreciated.
Dim Row1, Row2 As Integer
Row1 = Me.List272.ListIndex
Row2 = Me.List276.ListIndex
Me.Text290 = Me.List272.Column(0, Row1) * Me.List276.Column(0...
You mean this ?
Dim Row1, Row2 As Integer
Row1 = Me.List272.ListIndex
Row2 = Me.List276.ListIndex
Me.Text290 = Me.List272.Column(0, Row1) * Me.List276.Column(0, Row2)
Seems not working
Vic
Hi,
I know this is trivial but I stuck. How to multiply the values of 2 listboxes and assign the result to a textbox.
Any help is appreciated.
Thx,
Vic
Hi,
I have 2 buttons to activate Reports on one Form. I want to be able to have 1 Report open at a time. How do I prevent opening a second Report if one is already open ?
Many thanks,
Vic
Hi,
I have 9 List boxes (3 sets of 3 listboxes for ClientName, ClienId and Balance) on a Form and want to insert the values into a TempTable with the same fields (ClientName, ClientID, Balance)
I have following code to write 1 record into the table:
Private Sub UpdateData()
Dim db As...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.