Where Clause in OpenForm statement

[Mike Charney]

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

[Tom van Stiphout]

On Fri, 30 Jun 2006 14:18:30 GMT, "Mike Charney"
<no*****@everything.net> 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

[Bob Quintal]

"Mike Charney" <no*****@everything.net> wrote in
news:Wo*********************@newssvr21.news.prodig y.com:

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

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

When I hit the button that is supposed to open the report I
get the following error:
Does anyone know what the problem is?

"[active] = " 'true' has a doublequote wrong.

if active is a text field withe the word true in it, then

"[ACTIVE] = 'true'"

if it's a boolean field,
"[ACTIVE] is true" OR "[active] = 1" will work
"[active] = true" also works in JET SQL, not sure about server.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Mike Charney]

Thanks Tom, that did the trick.

Mike Charney

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:7i********************************@4ax.com...

On Fri, 30 Jun 2006 14:18:30 GMT, "Mike Charney"
<no*****@everything.net> 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