Re: Where Clause in OpenForm statement

Thanks Tom, that did the trick.

Mike Charney

"Tom van Stiphout" <no.spam.tom7744@xxxxxxx> wrote in message
news:7idaa21mbkpo8e10uacjdq9gra4sge8fq6@xxxxxxxxxx
On Fri, 30 Jun 2006 14:18:30 GMT, "Mike Charney"
<nothing@xxxxxxxxxxxxxx> wrote:

I would think this would not even compile.

Try:
"[active]=1"

Note that True is -1 in VBA, and a True bit field in SQL Server is +1.

-Tom.



I am having trouble with the where clause in an openreport statement in an
Access Data Project.

I am using MS-Access 2003 with SQL Svr 2000.

The line I am using is:

DoCmd.OpenReport "rptAllRecords", acViewPreview, , "[active]=" 'True'

When I hit the button that is supposed to open the report I get the
following error:

Run-Time error '30025':
Invalid SQL Statement. Check the server filter on the form record source.

I have built the report directly form the table, not from a sql statment
or
view.

Does anyone know what the problem is?

Thanks,
Mike
m charney at dunlap hospital dot org





.

Quantcast