Results 1 to 2 of 2

Thread: Not Searching

Threaded View

  1. Sep 9th, 2012, 05:33 AM #1
    Jagjit
    Jagjit is offline

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2011
    Posts
    688

    Not Searching

    Hi

    Dim strsearch, strsql As String
    strsearch = InputBox("Search For", "Search Input Box")
    strsql = "SELECT * FROM m_itemmaster WHERE icode LIKE " & Chr(34) & strsearch & Chr(34)
    Openrstitem (strsql)

    Secondly i want if user enters * in inputbox it fills listview with all records , no filter.

    What value i enter it does not search where as record exists

    Thanks
    Last edited by Jagjit; Sep 9th, 2012 at 05:41 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width