Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Data Type Mismatch In Criteria Expression Error
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

kavaliotis
Starting Member

11 Posts

Posted - 31 May 2001 :  05:22:20  Show Profile
Hello guys, i know this is a common error but i can't find a solution..I haven't set any Time/Date data types in my access database, just text,memo and autonumber. What can this problem be?

BuffyNET
Junior Member

United Kingdom
126 Posts

Posted - 31 May 2001 :  05:29:47  Show Profile  Visit BuffyNET's Homepage  Send BuffyNET an ICQ Message
Can you give us more details, the exact error you receive and maybe a snippet of code aqnd what you are trying to do?

Neil

This is my Sig! ©2001 My Sig & Co. Ltd. Plc. etc
Go to Top of Page

kavaliotis
Starting Member

11 Posts

Posted - 31 May 2001 :  06:10:14  Show Profile
OK the error is :

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/Form.asp, line 90

in the line that is says that i have the error, i don't see anything strange (do we count the empty lines when we start counting the lines from the top of the page with the code?)

I'm just trying to insert records from a form in an access database.

Go to Top of Page

BuffyNET
Junior Member

United Kingdom
126 Posts

Posted - 31 May 2001 :  06:20:21  Show Profile  Visit BuffyNET's Homepage  Send BuffyNET an ICQ Message
ok, can you send me the code? the form and the part that writes it to the database (if it is 2 seperate files), and maybe a blank database?

send to buffynet@btinternet.com

And I will take a look for you

Neil

This is my Sig! ©2001 My Sig & Co. Ltd. Plc. etc
Go to Top of Page

cbovis
New Member

United Kingdom
91 Posts

Posted - 31 May 2001 :  06:23:12  Show Profile
yes you do count the empty lines so post the line here and we will see if we can help.

Go to Top of Page

kavaliotis
Starting Member

11 Posts

Posted - 31 May 2001 :  06:50:09  Show Profile
Check your emails Buffynet!!!!!

Go to Top of Page

BuffyNET
Junior Member

United Kingdom
126 Posts

Posted - 31 May 2001 :  07:26:26  Show Profile  Visit BuffyNET's Homepage  Send BuffyNET an ICQ Message
OK, will take a look over lunch...

Neil

This is my Sig! ©2001 My Sig & Co. Ltd. Plc. etc
Go to Top of Page

BuffyNET
Junior Member

United Kingdom
126 Posts

Posted - 31 May 2001 :  18:56:55  Show Profile  Visit BuffyNET's Homepage  Send BuffyNET an ICQ Message
This problem has now been resolved over email

Neil

This is my Sig! ©2001 My Sig & Co. Ltd. Plc. etc
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000 Version 3.4.07