<?xml version="1.0" encoding="utf-8"?>
<!-- generator="FeedCreator 1.7.2" -->
<rss version="2.0">
    <channel>
        <title>Lowyat.NET: Latest topics by chinyeung</title>
        <description></description>
        <link>http://forum.lowyat.net/</link>
        <lastBuildDate>Sun, 22 Nov 2026 18:01:28 +0800</lastBuildDate>
        <generator>FeedCreator 1.7.2</generator>
        <item>
            <title>how to do data selection on datagrid and use it?</title>
            <link>http://forum.lowyat.net/topic/702809</link>
            <description>Private Sub CmdUse_Click()&lt;br /&gt;&lt;br /&gt;Dim i As Integer&lt;br /&gt;Dim varBmk As Variant&lt;br /&gt;&lt;br /&gt;Do Until DataGrid1.SelBookmarks.Count = 0&lt;br /&gt;   &lt;br /&gt;    For Each varBmk In DataGrid1.SelBookmarks&lt;br /&gt;                       &lt;br /&gt;    If DataGrid1.SelBookmarks.Count = 0 Then Exit Sub&lt;br /&gt;    If DataGrid1.SelBookmarks.Count = 1 Then&lt;br /&gt;        i = 0&lt;br /&gt;    ElseIf DataGrid1.SelBookmarks.Count &amp;gt; 1 Then&lt;br /&gt;        i = DataGrid1.SelBookmarks.Count - 1&lt;br /&gt;    End If&lt;br /&gt;    DataGrid1.SelBookmarks.Remove (i)&lt;br /&gt;&lt;br /&gt;Form1.txtChildCode.Text = rs.Fields(&amp;quot;SalesPersonCode&amp;quot;)&lt;br /&gt;Form1.txtChildName.Text = rs.Fields(&amp;quot;SalesPersonName&amp;quot;)&lt;br /&gt;Next&lt;br /&gt;Loop&lt;br /&gt;&lt;br /&gt;Form1.Show&lt;br /&gt;Unload Me&lt;br /&gt;&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;p/s= currently i using this code for this function. but this show me nothing on the textbox i wish. any idea pls? thanks for help..</description>
            <author>chinyeung</author>
            <category>Codemasters</category>
            <pubDate>Fri, 23 May 2008 14:49:01 +0800</pubDate>
        </item>
        <item>
            <title>how to filter integer? anyone help plz</title>
            <link>http://forum.lowyat.net/topic/702676</link>
            <description>Dim X As Double&lt;br /&gt;Dim y As String&lt;br /&gt;&lt;br /&gt;X = Trim(Text1.Text)------------------------------------&amp;#62; type mismatch&lt;br /&gt;rs.Filter = &amp;quot;SalesPersonCode =val(x)&amp;quot;&lt;br /&gt;&lt;br /&gt;If Y &amp;lt;&amp;gt; &amp;quot;&amp;quot; Then&lt;br /&gt;rs.Filter = &amp;quot;SalesPersonName like &amp;#39;&amp;quot; &amp;amp; Y &amp;amp; &amp;quot;%&amp;#39;&amp;quot;&lt;br /&gt;Else&lt;br /&gt;rs.Filter = &amp;quot;SalesPersonName &amp;lt;&amp;gt;&amp;#39;%&amp;#39;&amp;quot;&lt;br /&gt;End If&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Set DataGrid1.DataSource = rs&lt;br /&gt;&lt;br /&gt;DataGrid1.Refresh&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Text1.Text = &amp;quot;&amp;quot;&lt;br /&gt;Text2.Text = &amp;quot;&amp;quot;&lt;br /&gt;Text1.SetFocus&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;p/s= In this case, why i cannot filter the integer and always show the error &amp;#39;type mismatch&amp;#39;. For string, it can filter out the name.</description>
            <author>chinyeung</author>
            <category>Codemasters</category>
            <pubDate>Fri, 23 May 2008 11:25:31 +0800</pubDate>
        </item>
        <item>
            <title>filtering records problems</title>
            <link>http://forum.lowyat.net/topic/700321</link>
            <description>Dim rs As New ADODB.Recordset&lt;br /&gt;Dim Conn As New ADODB.Connection&lt;br /&gt;Dim rs1 As New ADODB.Recordset&lt;br /&gt;&lt;br /&gt;Private Sub CmdRefresh_Click()&lt;br /&gt;&lt;br /&gt;Dim Y As String&lt;br /&gt;Dim X As String&lt;br /&gt;&lt;br /&gt;Y = Trim(Text2.Text)&lt;br /&gt;If Y &amp;lt;&amp;gt; &amp;quot;&amp;quot; Then&lt;br /&gt;rs1.Filter = &amp;quot;SalesPersonName like &amp;#39;&amp;quot; &amp;amp; Y &amp;amp; &amp;quot; %&amp;#39;&amp;quot;&lt;br /&gt;Else&lt;br /&gt;rs1.Filter = &amp;quot;SalesPersonName &amp;lt;&amp;gt;&amp;#39;%&amp;#39;&amp;quot;&lt;br /&gt;End If&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Set DataGrid1.DataSource = rs1&lt;br /&gt;DataGrid1.Refresh&lt;br /&gt;&lt;br /&gt;Text2.Text = &amp;quot;&amp;quot;&lt;br /&gt;Text2.SetFocus&lt;br /&gt;&lt;br /&gt;Set rs1 = Nothing&lt;br /&gt;&lt;br /&gt;End Sub&lt;br /&gt;----------------------------------------------------------------------------------------------&lt;br /&gt;Private Sub Form_Load()&lt;br /&gt;&lt;br /&gt;Conn.ConnectionString = &amp;quot;DRIVER={MySQL ODBC 3.51 Driver};&amp;quot; &amp;amp; &amp;quot;SERVER=localhost;&amp;quot; &amp;amp; &amp;quot;uid=MYBS;&amp;quot; _&lt;br /&gt;                        &amp;amp; &amp;quot;DATABASE=Test;&amp;quot; &amp;amp; &amp;quot;PWD=MYBSMYBS;&amp;quot;&lt;br /&gt;Conn.Open&lt;br /&gt;&lt;br /&gt;rs.CursorLocation = adUseClient&lt;br /&gt;&lt;br /&gt;rs.Open &amp;quot;select * from SalesPerson&amp;quot;, Conn, adOpenDynamic, adLockPessimistic&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Set DataGrid1.DataSource = rs&lt;br /&gt;&lt;br /&gt;Set Conn = Nothing&lt;br /&gt;Set rs = Nothing&lt;br /&gt;&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;p/s : When i click on refresh button to filter out some records in datagrid1..it does not works. datagrid1 was show nothing there. anyone can help please. thanks a lot.&lt;br /&gt;</description>
            <author>chinyeung</author>
            <category>Codemasters</category>
            <pubDate>Tue, 20 May 2008 10:25:11 +0800</pubDate>
        </item>
        <item>
            <title>duplicatecheck records canot works.anyone help plz</title>
            <link>http://forum.lowyat.net/topic/700318</link>
            <description>Private Function DupCheck(chkID As String) As Boolean&lt;br /&gt;&lt;br /&gt;Dim sql As String&lt;br /&gt;    sql = &amp;quot;select * from salesperson where Default_Code = &amp;#39;&amp;quot; &amp;amp; chkID &amp;amp; &amp;quot;&amp;#39;&amp;quot;&lt;br /&gt;&lt;br /&gt;    if rs.EOF = True Then&lt;br /&gt;        rs.Close&lt;br /&gt;    Set rs = Nothing&lt;br /&gt;    Exit Function&lt;br /&gt;    End If&lt;br /&gt;&lt;br /&gt;    If chkID = rs&amp;#33;Default_Code Then&lt;br /&gt;     DupCheck = True&lt;br /&gt;    Else&lt;br /&gt;        DupCheck = False&lt;br /&gt;    End If&lt;br /&gt;&lt;br /&gt;    rs.Close&lt;br /&gt;End Function&lt;br /&gt;-----------------------------------------------------------------------------&lt;br /&gt;Private Sub CmdAdd_Click()&lt;br /&gt;&lt;br /&gt;If DupCheck(txtDefaultCode.Text) = True Then&lt;br /&gt;        MsgBox &amp;quot;Duplicate Record &amp;quot;, , &amp;quot;Warning&amp;quot;&lt;br /&gt;ElseIf&lt;br /&gt;   rs.AddNew&lt;br /&gt;   rs.Fields(&amp;quot;Default_Code&amp;quot;) = txtDefaultCode.Text&lt;br /&gt;   rs.Fields(&amp;quot;SalesPersonCode&amp;quot;) = txtSalesPersonCode.Text&lt;br /&gt;EndIf&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;p/s: anyone can help me please? it keep adding the records even the DefaultCode is duplicated.</description>
            <author>chinyeung</author>
            <category>Codemasters</category>
            <pubDate>Tue, 20 May 2008 10:19:11 +0800</pubDate>
        </item>
    </channel>
</rss>
