Results 1 to 3 of 3

Thread: Run-time error '3464' data type mismatch

  1. #1
    Join Date
    Jan 2009

    Run-time error '3464' data type mismatch

    I am getting "Run-time error '3464': data type mismatch in criteria expression" error While trying to run below query.

    SELECT table1.* FROM table1 WHERE
    (table1.txt1='" & txt1 criteria & "') AND
    (table1.longfield='" & longfield criteria & "')
    What is wrong with my code? I am using the above SQL query with my VB6.

  2. #2
    Join Date
    May 2008

    Re: Run-time error '3464' data type mismatch

    Your mistake lies in the last part.
    (table1.longfield='" & longfield criteria & "')
    You have unnecessarily used "' in the last part, simply remove it and everything will be OK.

  3. #3
    Join Date
    Jan 2008

    Re: Run-time error '3464' data type mismatch

    Well this depends on your code, if you don't need to add more statements then remove the last quotes before parenthesis but if you have any further statements then it is difficult to identify what is the problem. I need some more snapshot of your codes to identify the problem.

Similar Threads

  1. Start tag/end tag mismatch error
    By raeballi in forum Windows Software
    Replies: 1
    Last Post: 25-03-2012, 01:13 PM
  2. machine type mismatch error in Just Cause 2
    By Dhananjay in forum Video Games
    Replies: 6
    Last Post: 10-04-2010, 08:28 AM
  3. Replies: 3
    Last Post: 11-06-2009, 10:23 AM
  4. Type mismatch in JOIN expression. (Error 3615)
    By !const in forum Software Development
    Replies: 3
    Last Post: 19-05-2009, 05:38 PM

Posting Permissions

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