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!

  • Congratulations SkipVought 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. CupraSA

    Split contents into 3 fields

    aah much better thanks
  2. CupraSA

    Split contents into 3 fields

    Thanks you got me thinking. ok so the following does the trick Dim Sdate As String * 10 Dim Shour As String Dim Smin As String Sdate = txtDateRecieved.Text Shour = mobjADORst.Fields("DATERECIEVED") Smin = mobjADORst.Fields("DATERECIEVED") txtDate.Text = Sdate...
  3. CupraSA

    Split contents into 3 fields

    Hi, This is probably such a simple thing to do but i just dont know how... txtDateRecieved.Text = mobjADORst.Fields("DATERECIEVED") which contains "2009/10/01 11:23" I need to split the contents into 3 fields: txtDate should contain "2009/10/01" txtHour should contain "11" txtMinu should...
  4. CupraSA

    Problem with ListViewGrid

    ok. I figured it out!!! :) you need to added the column headers first... Private Sub Command2_Click() Dim mstrSQL As String Dim list_item As ListItem On Error GoTo LocalError With ListViewGrid .ColumnHeaders.Clear .ColumnHeaders.Add , , "Record", .Width *...
  5. CupraSA

    Problem with ListViewGrid

    When the error occurs the values are as follows: EOF = false list_item = "33" list_item.SubItems(1) = <Invalid property value> !TRSNum = "1" The code on the other form that works is: strSQL = "SELECT *" _ & " FROM StaffTimeSheet WHERE username = '" & MainUser.Text & "'" _ & "...
  6. CupraSA

    Problem with ListViewGrid

    Good day, Please advise why i'm getting the following error. 380 - Invalid property value I have the same code on a different form and it works... Thanks Private Sub Command2_Click() Dim mstrSQL As String Dim list_item As ListItem On Error GoTo LocalError mstrSQL =...
  7. CupraSA

    Calculate total of a listview column

    Thanks for the prompt responces guys. Ok I went with this option. Just one more thing: How do you get it to add SumTime in the correct column. Currently it adds it to the first column. It needs to be displayed beneath the timespent column. Also is it possible to make the text bold or change the...
  8. CupraSA

    Calculate total of a listview column

    Hi, Please help. I've have a listview that contails 10 columns. The records listed in the control change based on the month selected. I now need to display a sub total at the end of the timespent column and dont have a clue how to do this... I've searched all over the net and was only able...
  9. CupraSA

    Adding texbox value to end of rich textbox

    Perfect! Thanks a lot guys! Dilettante, Just a question why does it add the text for "Log" above the existing contents?
  10. CupraSA

    Adding texbox value to end of rich textbox

    Hi, I am relatively new to VB6 and have the following problem: I need to create a "audit trail" of what has happed in the form and display it in a rich textbox. So basically I want to add the value of textbox1 to the end of the existing contents in richtextbox1 when I save the form. How do I...

Part and Inventory Search

Back
Top