Results 1 to 3 of 3

Thread: Search

  1. #1
    Kwadwo Boahene Guest

    Default Search

    I thought the code below could do a global search but found out otherwise. How could I just put in a letter in the search field and get all that apply. At the present time whenever I do a search I only get just one record even though I have a lot of records with the same selection criteria.<BR><BR>Also I inherited this db with weird table names and fields. Some of the fields have two words as "Item Code" and when I try to do a use that field name I run into and error. What should I do?<BR><BR><BR>Thanks,<BR>Kwadwo <BR><BR><BR>sql = "SELECT * From Bond10Masters WHERE Item like &#039%" & sitemcode & "%&#039"<BR><BR> <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Search

    I have a search engine that will search a single field in a database, but the code would be a bit to put on here. What is your email and I can email you the code if you like? My email is <BR><BR>Ken

  3. #3
    Kwadwo Guest

    Default RE: Search

    Ken,<BR> My e-mail is<BR><BR>Thnaks,<BR>Kwadwo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts