Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Red face Unanswered: Syntex error (missing operator) in query expression

    Hi....

    I am getting the problem while I am run the following query in Visual Basic.

    Table name : Rel
    Database : Access
    ad : ADO connection
    rd : ADO Recordset

    I am trying to retriving the records from table when I click the combo box.


    rd.open "Select Department,Gono,Godate,Amtrel from Rel where department = " & combo1.text, ad

    error is : Syntex error (missing operator) in query expression

    kindly any body can help me to solve this problem. my email-id is superman_mukkamala@yahoo.co.in

    Thank-U
    Sangameshwar

  2. #2
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Lightbulb with text use the like operator

    rd.open "Select Department,Gono,Godate,Amtrel from Rel where department LIKE " & combo1.text, ad

Posting Permissions

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