Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AccDeveloper

    Assign a Select result to a Textbox instead of ListBox

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

    Listbox Values miltiplied ..How ?

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

    How to multiply 2 listbox values and show it in textbox

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

    How to multiply 2 listbox values and show it in textbox

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

    How to prevent opening of more than 1 Report

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

    How to add multiple records in a recordset (DAO) ???

    Thanks, Vic
  7. AccDeveloper

    How to add multiple records in a recordset (DAO) ???

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

Part and Inventory Search

Back
Top