Search results

Problem Solved! If Me.RecordsetClone.RecordCount = 0 Then MsgBox "No Record Found" Me.txtSerch = "" Me.txtFind = "" DoCmd.Requery Me.txtFind.SetFocus Exit Sub End If Thank you very much, pbaldy.

Hi pbaldy, Thank you for your help. This does solve the problem. However, another problem came up. After the if statement kicks in and exit the sub, the form doesn't reset or go back to the previous search result with the Me.txtFind.Undo function. For example, after the implementation of...

Hi pbaldy, The error only occur when there is no matching result. For example, if you try to search "99", the error would come up. Thank you very much.

I think it's because of the size of my file...... Let me try it again...... Hope this works.... Thank you very much PS. I have deleted a lot of information due to the size issue...hope you can still understand it.......

Hi pbaldy, I have tried to upload the file. However, it shows "Your submission could not be processed because a security token was missing". Do you know how I can solve this? Thank you very much.

Me.txtFind.SelStart = Len(Me.txtFind) This is the line. Thank you.

OK. Thank you very much John Big Booty for designing the Dynamically search multiple fields.

Thank you for your reply. But I thought this dynamic search is fine with text.

Hi John Big Booty, I am having trouble uploading my db. It shows "Your submission could not be processed because a security token was missing". However, this is what it looks like..... Private Sub txtFind_Change() 'Create a string (text) variable Dim vSearchString As String...

[Solved] Run-time error '2185' for Dynamically search multiple fields Hi all, I am trying to adpot this Dynamically search multiple fields into my db from John Big Booty at w w w.a c c e s s-p r o g r a m m e r s.co.uk/forums/showthread.php?t=188663 Every thing works great except it gives...