Search:

Type: Posts; User: __wired__

Page 1 of 2 1 2

Search: Search took 0.02 seconds.

  1. Replies
    0
    Views
    503

    CR 11 crosstab

    hi to all.. i have this table in access...

    http://i42.tinypic.com/fema14.jpg

    and i need to have an output in cr11 like this....disregard the colors.. data only
    ...
  2. Replies
    1
    Views
    1,195

    Re: mshflexgrid and textbox

    i already figure it out again.. hehehe.. here's the code

    MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 4) = Text1.Text

    "4" is the column... hope this will help to others..
  3. Replies
    1
    Views
    1,195

    [RESOLVED] mshflexgrid and textbox

    i want to get the value of the textboxes and insert in the mshflexgrid.. everytime i click a record in the grid...

    it's hard to find datagrid to excel.. thats why i switch to mshflexgrid.. but...
  4. Replies
    6
    Views
    584

    Re: Datagrid Value to Excel

    i replace the this error line:
    .Paste 'Paste clipboard contents

    with this one:

    SendKeys "^v"

    i got empty excel sheet..
  5. Replies
    6
    Views
    584

    Re: Datagrid Value to Excel

    i replace the error line with your code.. i got error "Paste method of Worksheet class failed"

    here's the error code:

    .Paste 'Paste clipboard contents
  6. Replies
    6
    Views
    584

    Re: Datagrid Value to Excel

    thanks for the reply.. i found a code for mshflex then i apply in datagrid.. i got 1 error.. hope someone can figure it out...
    Dim xlObject As Excel.Application

    Dim xlWB As...
  7. Replies
    6
    Views
    584

    Re: Datagrid Value to Excel

    BTW.. the data's in datagrid is not all from database/recordset.. i have 2 columns coming from a textbox.. is it possible to move all the data's in my datagrid to an excel sheet?
  8. Replies
    6
    Views
    584

    Datagrid Value to Excel

    this is my last problem in my program... hehehehe.. can someone help me on this. thanks
  9. Re: Adding textbox value to Datagrid column

    DataGrid1.Columns(2) = Text12.Text
    DataGrid1.Columns(3) = Text13.Text
    DataGrid1.Columns(4) = Text14.Text

    but.. instead of creating a new columns.. i just created a new fields to the...
  10. Re: Adding textbox value to Datagrid column

    i already figure it out... hehehehe.. thanks anyway to all who's trying to solve this..
  11. [RESOLVED] Adding textbox value to Datagrid column

    is this possible?

    http://i40.tinypic.com/262uvjc.jpg
  12. Replies
    18
    Views
    2,202

    Re: [RESOLVED] SUM Function

    i changed the field name "LEVEL"... now its totally working... yahhoooo... thanks again
  13. Replies
    18
    Views
    2,202

    Re: [RESOLVED] SUM Function

    thanks for you help... i think the word "LEVEL" is a reserved word.. coz other fields are working except the field named "LEVEL"... i totally appreciate your help... GOD BLESS :)
  14. Replies
    18
    Views
    2,202

    Re: [RESOLVED] SUM Function

    when i insert the "LEVEL" in the SELECT and GROUP BY..
  15. Replies
    18
    Views
    2,202

    Re: [RESOLVED] SUM Function

    rs.Open "SELECT NAME, LEVEL, SUM(H_RB)as H_RB, SUM(H_HS) as H_HS, SUM(H_SF) as H_SF, SUM(H_DF) as H_DF from qryMB WHERE TRANDATE>=#" & dtp1.Value & "# and TRANDATE <=#" & dtp2.Value & "# GROUP BY...
  16. Replies
    18
    Views
    2,202

    Re: [RESOLVED] SUM Function

    for example.. H_DF, NAME, POSITION is the new field.. should i include it in GROUP BY NAME, POSITION <<< ?
  17. Replies
    18
    Views
    2,202

    Re: [RESOLVED] SUM Function

    one more thing.. i want to display also the other fields not only the "NAME" what should i type?
  18. Replies
    18
    Views
    2,202

    Re: SUM Function

    thanks for the help...

    here's the code...
    rs.Open "SELECT SUM(H_RB)as H_RB, SUM(H_HS) as H_HS, SUM(H_SF) as H_SF, SUM(H_DF) as H_DF, NAME from qryMB WHERE TRANDATE>=#" & dtp1.Value & "# and...
  19. Replies
    18
    Views
    2,202

    Re: SUM Function

    i paste the wrong code.. sorry.. here's the code..

    rs.Open "SELECT SUM(H_RB)as H_RB, SUM(H_HS) as H_HS, SUM(H_SF) as H_SF, SUM(H_DF) as H_DF, NAME from qryMB GROUP BY NAME WHERE TRANDATE>=#" &...
  20. Replies
    18
    Views
    2,202

    Re: SUM Function

    thanks for the reply.. can you check my code..
    rs.Open ("SELECT SUM(H_RB)as H_RB, SUM(H_HS) as H_HS, SUM(H_SF) as H_SF, SUM(H_DF) as H_DF, NAME from qryMB WHERE TRANDATE>=#" & dtp1.Value & "#...
  21. Replies
    18
    Views
    2,202

    [RESOLVED] SUM Function

    hi there.. can someone teach me how to do this.. thanks


    http://i44.tinypic.com/eaqmxc.jpg
  22. Replies
    3
    Views
    546

    Re: How to change DataGrid color

    thanks for the replies... ok.. i'll try flexgrid.. thanks
  23. Replies
    3
    Views
    546

    [RESOLVED] How to change DataGrid color

    http://i41.tinypic.com/1pf51y.jpg
    is it possible?
  24. Thread: help pls

    by __wired__
    Replies
    6
    Views
    552

    Re: help pls

    thanks for the reply.. i'll try this one now.. is it possible to use crystal report on it instead of excel?
  25. Thread: help pls

    by __wired__
    Replies
    6
    Views
    552

    Re: help pls

    can someone tell me is it possible to do this in vb? the only thing that i can think is... it cant be dynamic.. am i right? i have excel format of this..
  26. Thread: help pls

    by __wired__
    Replies
    6
    Views
    552

    Re: help pls

    ?:confused:
  27. Thread: help pls

    by __wired__
    Replies
    6
    Views
    552

    help pls

    http://i43.tinypic.com/29n9f8g.jpg

    im trying to do a program with the output is the above picture.. the color blue cells is the contractors.. it must be dynamic.. list of contractors can be...
  28. Replies
    2
    Views
    740

    Re: Dtpicker value problem

    thanks for the reply... i thought it is possible.. hehehe..
  29. Replies
    16
    Views
    9,653

    Re: combobox select as you type

    hmmm.. that's odd.. the code is working perfectly to me...:confused:
  30. Replies
    16
    Views
    9,653

    Re: combobox select as you type

    Option Explicit
    Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long

    Private Const...
  31. Replies
    2
    Views
    740

    [RESOLVED] Dtpicker value problem

    can a dtpicker have a value of the word "None"? or 00/00/0000 will be its default value? im changing the mindate to 00/00/0000 so that i can change the value to 00/00/0000.. but it wont allowed......
  32. Replies
    2
    Views
    2,152

    Re: VB6 sp6 installation

    just create a folder.. then extract it there... then find the setup file.. then click setup... service pack 6 fix/add some functions... like in data report.. to be able to create a landscape.. you...
  33. Replies
    6
    Views
    1,080

    Re: DtPicker long format

    thanks bro...
  34. Replies
    6
    Views
    1,080

    Re: DtPicker long format

    like this one? >>> Text1.Text = Format(DTP1.Value, Trim(Mid(FormatDateTime(Now, vbLongDate), InStr(FormatDateTime(Now, vbLongDate), ",") + 1))).... it gives me this result >>> April 28, 2399049......
  35. Replies
    6
    Views
    1,080

    Re: DtPicker long format

    thank you.. last question.. what if i want only this one >>> April 27, 2009
  36. Replies
    6
    Views
    1,080

    [RESOLVED] DtPicker long format

    i set my dtpicker format to longdate (Monday, April 27, 2009)..
    i want to copy it in a textbox.. what code should i use? coz "text1 = dtpicker1.value" gives me this >>> 4/27/2009.. thanks in...
  37. Replies
    6
    Views
    931

    Re: creating installer problem

    cool... thanks
  38. Replies
    6
    Views
    931

    Re: creating installer problem

    thanks for the reply... what can you suggest for creating an installer?
  39. Replies
    6
    Views
    931

    Re: creating installer problem

    install creator pro...
  40. Replies
    6
    Views
    931

    [RESOLVED] creating installer problem

    i just finished my simple system.. then i created an installer.. then.. when i install the system im my computer it is working.. then i install in another pc w/out vb6 installed on it.. i can't open...
Results 1 to 40 of 67
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width