Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17

ADO connection and Recordset

  1. #16
    Sweetu is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2016
    Posts
    19
    Before filtering I was using this code to search in the form...both filtering and below code working fine for whole form...but with slow down almost 2 minutes...while the query open itself within 4 seconds...only search is issue...


    Code:
    Dim strSearch As String
    Dim strText  As String 
    StrText= Me.txtSearch.value
    StrSearch = "SELECT * From Qry_tsb_Sql  Where EmployeeNumber =" & chr (34) & strText & chr (34)
    Me.RecotdSource = strSearch


  2. #17
    aytee111 is online now Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,661
    This is the last time I am explaining this! Go to SQL Server, create the query, include "WHERE EmployeeNumber=12345", get it working, copy the SQL to your code, follow steps in post #4.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Remote Desktop Connection Broker connection string
    By Philosophaie in forum Access
    Replies: 1
    Last Post: 09-14-2015, 02:51 PM
  2. Replies: 6
    Last Post: 12-03-2013, 10:14 PM
  3. Replies: 2
    Last Post: 03-08-2012, 11:59 AM
  4. DAO Recordset Connection for Access 2002
    By creativefusion in forum Programming
    Replies: 5
    Last Post: 08-17-2010, 05:45 PM
  5. Replies: 1
    Last Post: 11-13-2009, 02:03 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums