User Profile

Collapse

Profile Sidebar

Collapse
Paula Fox
Paula Fox
Last Activity: Jan 6 '11, 05:00 PM
Joined: Jan 6 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Paula Fox
    replied to Search Text box not working after table was moved to SQL server
    in Access
    WOW! Thanks for the quick response! There is the code for the text search. Hope this is what you are asking.


    Code:
    Private Sub txtClaimIDSearch_AfterUpdate()
    Dim rst As Recordset
    
    Set rst = Me.RecordsetClone
    rst.FindFirst "ClaimID = " & Me.txtClaimIDSearch
    If rst.NoMatch Then
        MsgBox ("No such claim exists")
        Me.txtClaimIDSearch.SetFocus
    ...
    See more | Go to post
    Last edited by Stewart Ross; Jan 6 '11, 08:44 PM. Reason: Added code tags around code

      Leave a comment:

    • Paula Fox
      started a topic Search Text box not working after table was moved to SQL server
      in Access

      Search Text box not working after table was moved to SQL server

      Recently, my access database main records table was "cloned" and is now being hosted on a SQL server as a linked table to my existing Access database. Now, the Record search box (in the form) does not consistently return the correct record when called. This is intermitant. The search function will work for maybe 5 searches, then will display a totally incorrect record out of the blue. I realize SQL server and Access have different data...
      See more | Go to post
      No activity results to display
      Show More
      Working...