<strong id="nr4sf"></strong>

<button id="nr4sf"><object id="nr4sf"></object></button>

    <rp id="nr4sf"></rp>
    <th id="nr4sf"><track id="nr4sf"></track></th>
      <s id="nr4sf"></s>
    1. <em id="nr4sf"></em>
    2. <li id="nr4sf"><acronym id="nr4sf"></acronym></li>
    3. <button id="nr4sf"></button>

      office交流網--QQ交流群號

      Access培訓群:792054000         Excel免費交流群群:686050929          Outlook交流群:221378704    

      Word交流群:218156588             PPT交流群:324131555

      access篩選窗體記錄

      2020-07-05 08:00:00
      tmtony8
      原創
      13440

      在access程序中,我們對數據進行查詢篩選。

      如圖,在連續窗體中,我們通過一個金額數值范圍來篩選數據。


          Dim db As DAO.Database
          Dim rs As DAO.Recordset
          Dim strje As String
          Dim strje1 As String
          Dim strje2 As String
          Set db = CurrentDb()
          Set rs = db.OpenRecordset("銷售記錄", dbOpenDynaset)
      
      '設置篩選參數
          strje1 = "[金額]>=" & txt1
          strje2 = "[金額]<=" & txt2
          strje = strje1 & " and " & strje2 
      '執行篩選操作
          rs.Filter = strje 
          Set rs = rs.OpenRecordset
          Set Me.Recordset = rs
          Me.Requery
          End If
          Set rs = Nothing
          Set db = Nothing


        分享
        一级日本牲交大片束缚_玖玖资源站亚洲最大的网站_56PAO国产成视频永久_97人人操人人摸
        <strong id="nr4sf"></strong>

        <button id="nr4sf"><object id="nr4sf"></object></button>

        <rp id="nr4sf"></rp>
        <th id="nr4sf"><track id="nr4sf"></track></th>
          <s id="nr4sf"></s>
        1. <em id="nr4sf"></em>
        2. <li id="nr4sf"><acronym id="nr4sf"></acronym></li>
        3. <button id="nr4sf"></button>