Recent content by gigsvoo

I have a sample form that uses MSFlexGrid, you wanna see the codes? I have no way to upload attachment here, so if u want it, just email me at gigsvoo@yahoo.com or post ur request at my website at http://communities.msn.com.my/VisualBasicwithNeo ok? Thanks Neo...

I made some codes here uses MSFlexGrid. Email me for my sample codes. Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo

From what i understand, you should need a SQL statement to do this: To retrive 2 different tables field values: "SELECT a.field1, b.field2 FROM Table1 a, Table2 b WHERE a.field2 = b.field3" Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo

Hi there, Could you please show me where is the error fall into which line? Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo

Any error messages? Maybe try to put this: Set DataGrid.DataMember = "" Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo

Or shall redesign the number of report textboxes? DO u think the GROUP BY will come out the require recordset? if yes, then rearrange the thing to fit. Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo

Should be this: Private Sub lstNames_Click() Dim i As Long txtUns.Text = lstNames.Text With cmd .CommandText = "_ParamAttendStats" .CommandType = adCmdStoredProc .Parameters("SocSecNum") = txtUns.Text End With rs.Open cmd, ...

drReport.Sections("Section1").Controls("RptLabel") = drReport.Sections("Section1").Controls_("RptTextBox") Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo

Dim fso As New FileSystemObject Dim f As TextStream Set f = fso.OpenTextFile("C:\Test.txt", ForAppending) Dim i, j For i = 0 to MsFlexGrid1.Rows - 1 For j = 0 to MsFlexGrid1.Cols - 1 f.Write(MsFlexGrid1.TextMatrix(i, j)) & ";" Next f.Write() & vbCrLf Next...

Use this when: Format("20-12-2001", "dd-mm-yyyy hh:mm:ss") Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo

You can do that...but if there are some calculations or functions happened b4 ouptput, then you can use a FileSystemObject writting textfile method. Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo

Use GROUP BY statement in the SQL statement? Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo

strUpdate = "UPDATE teams SET day='yes' WHERE tid='" & teamid & "'" rsteams.open strupdate, dbcon Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo

Remove the line: Set Rs = New ADODB.Recordset should be Dim Rs As New ADODB.Recordset Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo

Or you can try to use Visual Studio Installer...cool and FREE... Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo