Viewing reports with Access Runtime

[rogge]

Here is one line of my code:
DoCmd.OpenReport "rptIssClosedListDate", acViewPreview

and it generates this error:
"Execution of this application has stopped due to a run-time error."
When one clicks "OK" the application closes

(yes, i know i am supposed to have error code, but when given the luxery of
3 days to create a multi-user SQL server database from scratch and deploy it
to a myriad of unknown computers, i prefer to program with no errors )

I have tested this on my machine, XP & Office 2003, using the runtime
switch, but i get no errors. On my co-workers machine, the error occurs.
Her machine has MS Access 2003 run-time.

Can this be a case of restrictive user permissions? Thank you for your help.

 

[SA]

Sure, could be permissions, could be anything. The only way to tell is to
add an error handler that displays a message with the error code and
description

e.g. assuming there's no code in the report itself that needs to be handled.

On error GoTo ErrHandler
DoCmd.OpenReport "rptIssClosedListDate", acViewPreview
ExitPreview:
Exit Sub
ErrHandler:
MsgBox "Error: " & Err.Number & " " & Err.Description
Resume ExitPreview

 

[Duane Hookom]

If you find the task of adding error handling to your modules (who doesn't)
then go to http://www.mztools.com/index.htm for a very handy, free utility
that does this and much more.

 

[rogge]

The error is :
Error 1502 (The OpenReport action was canceled) in procedure....

I have full admin rights on my computer and do not get this erorr; however,
my co-workers' computers are locked down tighter than Sir Galahad at Castle
Anthrax. SO i am assuming that these admin rights are the issue. will you
please shed some light on permissions and report running?

Thank you.