[AccessD] Data Type Mismatch

Keith Williamson Kwilliamson at RTKL.com
Tue Jan 16 09:41:44 CST 2007


The report, itself, runs as well.  It is only when I try running the
report, from my form, with criteria.  It is the criteria (I have
textboxes to input Month, Year, and Entity) which the user fills in,
that is creating the data mismatch.

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
artful at rogers.com
Sent: Tuesday, January 16, 2007 10:10 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Data Type Mismatch

I assume this means you can run the query itself successfully without
running the report. If that is the case, then are there any controls on
the report which are calculated on the basis of the query contents? I
would also try generating an autoreport based on the query, then
comparing it with your original report. It's a little tedious, but you
could open them side by side and compare the controls one by one.

hth,
Arthur

----- Original Message ----
From: Keith Williamson <Kwilliamson at rtkl.com>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Sent: Tuesday, January 16, 2007 9:56:09 AM
Subject: [AccessD] Data Type Mismatch

Is there an easy way to determine exactly what data type is being
returned by a query?  I have a report I am trying to run, with a
"Docmd.openreport".....but I keep getting a data mismatch error.  For
the life of me, I can't figure out why......and I've tried playing with
the Where statement, to get it to give me the right data...to no avail.
I figure, if I can definitively determine the data type, for my three
criterias....I can format the Where statement properly.....and also
figure out why the query is changing the data type.   Grrrrr!!

 

Thanks,

 

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com
<http://www.rtkl.com/> 

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list