Error: 3464 with Report to PDF

  • Thread starter Thread starter Larry Kahm
  • Start date Start date
L

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
 
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.
 
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.
 
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
 
Larry Kahm said:
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
 
Back
Top