Re: Data type mismatch in criteria expression

From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
Date: Thu, 24 Aug 2006 21:46:21 -0500

I am using the following parameters to execute an insert query using Delphi
7 and MS Access 97.

I get the error "Data type mismatch in criteria expression.

Can anyone tell me what I am doing wrong?

One of the field types from the select query you are trying to insert is not
compatible with the field you are trying to insert it into.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

References:
- Data type mismatch in criteria expression
  - From: Dan R

Prev by Date: Spaces in table names
Next by Date: Re: Ado Password Question
Previous by thread: Data type mismatch in criteria expression
Next by thread: Ado Password Question
Index(es):
- Date
- Thread

Relevant Pages

get the sql statement
... Data type mismatch in criteria expression. ... Protected Sub btnSave_Click(ByVal sender As Object, ...
(microsoft.public.dotnet.framework.aspnet)
Error 3464 with dCount - some computers only
... Error 3464 - Data type mismatch in criteria expression" from this line ... and produces a recordset with 36 records ... this code (and the print in the immediate window) ...
(microsoft.public.access.formscoding)
Re: Update query
... > It *should* set the value to NULL if the Allow Zero Length is false. ... Data type mismatch in criteria expression. ... Those are 2 single quotes... ...
(microsoft.public.access.queries)
Re: sort report by year (weird format)
... its okay - i get the error "data type mismatch in criteria expression" ... can i use a query?) ... Marshall Barton wrote: ...
(microsoft.public.access.reports)
>255 into excel?
... I need to insert more than 255 chars into an excelcolumn ... "Data type mismatch in criteria expression." ... ('VAFocus - ADH','Item cannot be found in the collection corresponding to ...
(microsoft.public.inetserver.asp.db)