DoCmd.OpenReport suddenly failing, macro OpenReport succeeds

M

MattE

This is weird.

This database has worked ok for years, now suddenly in some VBA code a
DoCmd.OpenReport is failing, the error handler there doesn't get hit,
but the macro that called that VBA function gets an Action Failed in
RunCode. If I open the report manually it succeeds, if I open it
directly from a macro it succeeds. At least a couple of different
places this happens.

Anyone else seen this?
 
M

MattE

One more thing, it only is a problem on one machine (WinXP SP2),
others WinXP SP2 machines are still ok.
 
M

MattE

And if the VBA code does a RunMacro which prints the report that
works, but if the VBA code does an OpenReport of the same report that
fails!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DoCmd.OpenReport suddenly failing, macro print prints same report ok 2
Queries suddenly failing 2
Err running OpenReport in module function 1
On Error Resume Next not working 5
Access2002: DoCmd.OpenReport Error 2
Macro security! 1
Using Command causes failure in Access 2000 runtime 1
How to trap errors with an Input Box? 3

Top