Help access 2010 to 2003 vba and sql problem!

[bcox9]

Ok I have written some simple vba code, and a sql statement in the criteria part of my query.



Everything was working fine in access 2007 and 2010, when I converted it in access 2007 to access 2003 format when I open my form it keeps asking for a parameter, which is point to the textbox that the query criteria is based on.

I have no idea why it's doing this, and I need some help. I am supposed to implement this on our computers at work tomorrow, because I thought I had finished with it, but I've got to get it working in access 2003 format.

I've attached everything. The 2007/2010 and the 2003 access files. A professional could probably look over it in 5-10 min and be able to tell me what is wrong.

Thanks in advance!

[June7]

I no longer have Access2003 available and the mdb does not present the prompt when opened with 2007. I don't see anything wrong with the query.

However, if you used a combobox instead of textbox, would not need the LIKE operator.

Did you run Compact & Repair with 2003? It is a very small project. Go to a computer with 2003 and rebuild if that's what it takes.

[bcox9]

That's probably what it will take.

Thanks for looking through it

Also the company SKU has 2 digits added on to the end of the ISBN (these vary), and the user will only have the ISBN of the book. So won't I need the LIKE operator for querying like that or can I just use = and use the same wildcard format to achieve this?

[bcox9]

Also, does the vba syntax change, because none of my ridicoulsly short vba commands are working either in the 2003 version.

It pops up with a reference error, and I believe the pop up is basically a reference error, so maybe the syntax for calling controls is different in 2003?

I don't know it's frustrating, because I've spent more time trying to fix this problem than I have putting the thing together.

Thanks in advance, as always.

[June7]

Not = with * wildcard. Will then need the LIKE operator.