Search:
Type: Posts; User: __wired__
Search:
Search took 0.02 seconds.
-
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
...
-
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..
-
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...
-
i replace the this error line:
.Paste 'Paste clipboard contents
with this one:
SendKeys "^v"
i got empty excel sheet..
-
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
-
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...
-
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?
-
this is my last problem in my program... hehehehe.. can someone help me on this. thanks
-
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...
-
i already figure it out... hehehehe.. thanks anyway to all who's trying to solve this..
-
is this possible?
http://i40.tinypic.com/262uvjc.jpg
-
i changed the field name "LEVEL"... now its totally working... yahhoooo... thanks again
-
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 :)
-
when i insert the "LEVEL" in the SELECT and GROUP BY..
-
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...
-
for example.. H_DF, NAME, POSITION is the new field.. should i include it in GROUP BY NAME, POSITION <<< ?
-
one more thing.. i want to display also the other fields not only the "NAME" what should i type?
-
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...
-
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>=#" &...
-
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 & "#...
-
hi there.. can someone teach me how to do this.. thanks
http://i44.tinypic.com/eaqmxc.jpg
-
thanks for the replies... ok.. i'll try flexgrid.. thanks
-
http://i41.tinypic.com/1pf51y.jpg
is it possible?
-
thanks for the reply.. i'll try this one now.. is it possible to use crystal report on it instead of excel?
-
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..
-
-
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...
-
thanks for the reply... i thought it is possible.. hehehe..
-
hmmm.. that's odd.. the code is working perfectly to me...:confused:
-
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...
-
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......
-
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...
-
-
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......
-
thank you.. last question.. what if i want only this one >>> April 27, 2009
-
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...
-
-
thanks for the reply... what can you suggest for creating an installer?
-
-
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...
|
Click Here to Expand Forum to Full Width
|