Duane Hookom's Query by Form Demo

  • Thread starter Thread starter Lee Stafford via AccessMonster.com
  • Start date Start date
L

Lee Stafford via AccessMonster.com

Duane,

I have downloaded your QBF demo and it works great with your tables,
however when I copy all the tables and forms to my db, I get a "13: Type
mismatch" in cmdReport_click() when I try to run the query.

Is there something that I need to change?

tia,

Lee
 
Compare the references in Duane's demo to what you've got (Tools |
References when you've got any code module open).

I'm not actually familiar with that demo of his, but I wouldn't be surprised
if you're using Access 2000 or 2002, and don't have a reference set to DAO.
 
Thank you, I will check on that. Duane had just suggested the same thing.

thanks again,

Lee
 
I did check the references and it was missing one and they were in a
different order than what I had. It works for all that now, except in one
case the delimiter is wrong.

I downloaded the QBF demo from

www.rogersaccesslibrary.com/

I love what it can do, but when I try to use the "between" operator with my
month field, it will not use the correct delimiter. It will only use a
single quote instead of a double quote. If I try to use numbers, it will
try to use a single quote to separate them. If I go into the SQL and
modify it to the double quotes, it will work.
The month field is derived from =format(date(),"mmmm").
What am I missing? Is anyone familiar with this demo, and can help me
adjust the code so that I can use it to include a list of criteria?

tia,

Lee
 
Back
Top