Search results for query: *

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

What I normally does is I will get the latest number using the following statement then increase the number by one...this will always confirmed that no phantom case or sharing violation happened. "SELECT Top 1 FROM ..... ORDER BY....DESC" Thanks Neo...

How do you deploy the application? Does you use something like Package Deployment Wizard or Windows Installer package? Becoz there are some components need to be registered into the client PC as a part of VB... Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo

I recommend not to use the package deployment wizard, use Visual Studio Installer instead, you will gonna love it. I have been using it for the pass 2 yrs from ver 1.0 till 1.1, great! Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo