Results 1 to 8 of 8

Thread: [RESOLVED] Code!!!

Threaded View

  1. Jul 7th, 2012, 03:37 PM #1
    brss
    brss is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2012
    Location
    I'm living in VBForum bcz its members deserve respect and appreciation
    Posts
    333

    Resolved [RESOLVED] Code!!!

    Dear Programer, Need your expert. I did do search based on [Customer_Name] and it's work fine.

    Code:
    If pt.State = adStateOpen Then pt.Close
    pt.Open "SELECT * FROM [Customer] WHERE [Customer_Name] LIKE '%" & Trim(txtFind) & "%'", db, adOpenStatic, adLockOptimistic
    - But when I want to expand my Search to be based on 2 things [Customer_Name] or [Customer_No], Code below crushed not working. Any help would be such appreciate:

    Code:
    If pt.State = adStateOpen Then pt.Close
    pt.Open "SELECT * FROM [Customer] WHERE [Customer_Name] LIKE '%" & Trim(txtFind) & "%' OR [Customer_No] LIKE '%" & Trim(txtFind) & "%'", db, adOpenStatic, adLockOptimistic
    Last edited by brss; Jul 9th, 2012 at 06:04 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