Can some one write me the code in Visual Basic for an expretion
similar to the Where Condition to open a report? I can't use the
Where Condition because it pop up a message of Microsoft database Jet
Engine. Any help I will realy apriciate it.

Thanks,
Ely

On 11 Apr 2007 18:20:16 -0700, "Ely" <visualkidnet@yahoo.comwrote:

Such expression would trigger the same error message. If you reply
with:
* the exact error message
* the exact query
* The line of code that currently opens your report
we may be able to help.

-Tom.

>Can some one write me the code in Visual Basic for an expretion
>similar to the Where Condition to open a report? I can't use the
>Where Condition because it pop up a message of Microsoft database Jet
>Engine. Any help I will realy apriciate it.
>
>Thanks,
>Ely

are you talking about the WHERE condition in a macro? if you're getting a
Jet error when attempting to apply a WHERE clause to a report's recordset in
a macro, why do you think you'll get a different result by doing the same
thing in VBA? how about telling us what the Recordsource of your report is;
if it's a SQL statement or a saved query, please post the SQL statement. and
tell us what the WHERE clause is. and finally, tell us exactly what the
error message says. with enough information, maybe someone here can help you
to get it working.

hth


"Ely" <visualkidnet@yahoo.comwrote in message
news:1176340816.661432.141110@b75g2000hsg.googlegr oups.com...

Can some one write me the code in Visual Basic for an expretion
similar to the Where Condition to open a report? I can't use the
Where Condition because it pop up a message of Microsoft database Jet
Engine. Any help I will realy apriciate it.
>
Thanks,
Ely
>