Report does not display or print

[Todd]

I'm using Access 2003 (on Windows XP) and have a split dbase (FE/BE) with
security permissions set. One of my users cannot print preview or print any
reports. The user is in the same User group as the rest of my end users. I
went into one of the Access modules on her computer and checked the
references and set them to the same references as mine and still when she
selects the report to print and clicks the command button to perform the
event the same error messages appears, which states:

"The expression On Click you entered as the event property setting produced
the following error: The OpenReport action was canceled".

* The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro.

It seems that it should have something to do with her Access 2003
application since nobody else is having this problem, I think. She is
running the same program and OS as me (Access 2003 and XP).

FYI: If I logon using her dbase user name and password from my pc the
reports show up fine. If I logon from her pc using my dbase logon the same
error message appears.

Help!

 

[niuginikiwi]

If you got a different copy of FE and she got a different FE on a local
drive in both cases, then testing between her comp and your comp is
irrelevant.
If she is using a command button to preview/print the reports than verify
that the OnClick event is attached to a procedure.
Even if you have it working, it sometimes does not point to a procedure or
macro if you copy and past that command button.
Just a thought.

 

[Todd]

I forgot to mention that I do convert the FE on the server to an exe and then
deploy the exe to each persons local pc to run. I don't think it's the exe
file because the same exe is running on other users pc.
--
Todd

If you got a different copy of FE and she got a different FE on a local
drive in both cases, then testing between her comp and your comp is
irrelevant.
If she is using a command button to preview/print the reports than verify
that the OnClick event is attached to a procedure.
Even if you have it working, it sometimes does not point to a procedure or
macro if you copy and past that command button.
Just a thought.
--
niuginikiwi
Nelson, New Zealand

I'm using Access 2003 (on Windows XP) and have a split dbase (FE/BE) with
security permissions set. One of my users cannot print preview or print any
reports. The user is in the same User group as the rest of my end users. I
went into one of the Access modules on her computer and checked the
references and set them to the same references as mine and still when she
selects the report to print and clicks the command button to perform the
event the same error messages appears, which states:

"The expression On Click you entered as the event property setting produced
the following error: The OpenReport action was canceled".

* The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro.

It seems that it should have something to do with her Access 2003
application since nobody else is having this problem, I think. She is
running the same program and OS as me (Access 2003 and XP).

FYI: If I logon using her dbase user name and password from my pc the
reports show up fine. If I logon from her pc using my dbase logon the same
error message appears.

Help!