K
kagard
Greetings:
My report generating code worked yesterday. (It automatically
generated 73 reports correctly.) Today, instead of each recipient
getting just their information, every report contained everyone's
data. The reports still run, but the Where clause isn't being applied.
Here's the line of code:
DoCmd.OpenReport ReportName, acViewPreview, , TheWhereClause,
acWindowNormal, LevelOfDetail
When I view this in break mode, the ReportName is correct and
TheWhereClause contains the right criteria
( [Salesman] = "John Smith" ) for example. Executing this line of code
opens the report, but TheWhereClause is not applied and all records
are displayed.
I copied the UI (front end) to my boss' computer, which did not have
SP1 applied, and everything works fine.
Quarter End reports have to go out tomorrow morning, so this couldn't
have happened at a worse time. Does anyone know what is causing this,
and what I can do to work around it?
TIA
Keith
My report generating code worked yesterday. (It automatically
generated 73 reports correctly.) Today, instead of each recipient
getting just their information, every report contained everyone's
data. The reports still run, but the Where clause isn't being applied.
Here's the line of code:
DoCmd.OpenReport ReportName, acViewPreview, , TheWhereClause,
acWindowNormal, LevelOfDetail
When I view this in break mode, the ReportName is correct and
TheWhereClause contains the right criteria
( [Salesman] = "John Smith" ) for example. Executing this line of code
opens the report, but TheWhereClause is not applied and all records
are displayed.
I copied the UI (front end) to my boss' computer, which did not have
SP1 applied, and everything works fine.
Quarter End reports have to go out tomorrow morning, so this couldn't
have happened at a worse time. Does anyone know what is causing this,
and what I can do to work around it?
TIA
Keith