UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Custom Search
Edit Discussion
> 13 - Type Mismatch    

Error Code: 13
Error Source: VBA
Error Message: Type Mismatch

A procedure/query/lookup is expecting a particular datatype, but receives a different one


Contents

Possible Causes and Resolutions

Criteria in a query doesn't match the underlying table fields datatype. If you use a text datatype criteria for example for a numerical or date/time table field you will receive the error

Double check that all criteria datatype matches the datatype of the underlying table column datatype

You use a currency symbol in the criteria of a currency datatype. For example, you type £10.50 or $10.51 as the criteria

Don't use the currency symbol for currency datatypes

You're trying to use a JOIN in a query on datatypes that don't match

Only specify JOINS on the same datatype

Edit Discussion
Custom Search
Thank you for your support!
This page has been accessed 3,396 times.  This page was last modified 07:31, 6 July 2011 by Yves Dekort. Contributions by Alan Greenwood  Disclaimers