Error: 3464 with Report to PDF

[Larry Kahm]

I was testing with Stephen Lebans Report to PDF and everything was working
just fine last week.

This week, I'm getting an Access error message: 3464 - Data Type mismatch
in criteria expression.

I don't get it. I've tried tracing the code, but somehow, I'm just missing
the line that throws the error.

Any suggestions as to how to proceed?

Thanks!

Larry Kahm

 

[Stephen Lebans]

Comment out your code that calls the ReportToPDF functions. I'll bet the
error still appears. If I remember correctly that error has to do with
criteria supplied to a Query. Do you have a SQL statement as the
recordsource for this form? A GoogleGroups search on this error should yield
a lot of relevant threads.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

Sounds like you are passing a string when it is expecting a number, or a
number when it's expecting a date etc etc... why not post your code so we
can have a look?

Damian.

 

[Larry Kahm]

Trouble found: exists between eyes and keyboard!

Test report used test query - with built-in record number.

Actual report continued to use test query....

I >hate< when that happens!

Thanks!

Larry

 

[Tony Toews [MVP]]

Trouble found: exists between eyes and keyboard!

Test report used test query - with built-in record number.

Actual report continued to use test query....

I >hate< when that happens!

Been there, done that.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm