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!

Register Log in
  • Congratulations Rhinorhino 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. gigsvoo

    MSFlexGrid

    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...
  2. gigsvoo

    MSFlexGrid

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

    I need a database formula to share data between two databases.

    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
  4. gigsvoo

    MSFlexGrid

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

    MSFlexGrid

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

    Datareport an grouping

    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
  7. gigsvoo

    Parameter query only working first time.

    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, ...
  8. gigsvoo

    Using an If Then Statement

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

    export access table to a textfile

    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...
  10. gigsvoo

    need help getting data with vb6 from access db after there is a space

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

    convert db table to textfile

    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
  12. gigsvoo

    Datareport an grouping

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

    Syntax error on update statement vb6 access 2000

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

    MSFlexGrid

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

    Run time error -2147220992 (80040200) Class Not Registered

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

    auto assign a number

    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...
  17. gigsvoo

    Run time error -2147220992 (80040200) Class Not Registered

    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
  18. gigsvoo

    Cannot Copy Error - Please Help

    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

Part and Inventory Search

Back
Top