HELP NEEDED! Enter Parameter Value

[lpfluger]

Hi everyone, I have a problem with my database. I'm trying to run a query, and I get an "Enter Parameter Value" message box. I've inspected all the expressions and all seem to be ok. I even tried to discard field by field and the message remains with all the fields. This is a problem that I had before, and it solved itself mysteriously when I opened my .mdb file from another computer, in which the query worked perfectly. Any idea please?

[RuralGuy]

Try *importing* everything into a freash new db and see if the problem follows. http://www.btabdevelopment.com/ts/impnew

[lpfluger]

Try *importing* everything into a freash new db and see if the problem follows. http://www.btabdevelopment.com/ts/impnew

Thanks Royal, I did what yoy suggested but unfortunatelly it didn't work. Any other possible solution?

[RuralGuy]

I assume you have already done a Compact and Repair?

[pkstormy]

If you get the 'Enter Paramater Value' message, try deleting all the fields in the query and then drag them down again. Usually this stems from an expression or incorrect field name (sometimes it can even be the wrong table name itself in that row.) I also see queries get messed up when tables are deleted/relinked.

If this is something that works on 1 mdb but doesn't on another, I'd suspect something with the tables linked into 1 of the mdb's that might be conflicting with another or a field in the query which no longer exists in the table (which refreshing the linked tables and then removing that field in the query will solve.)