DoCmd.OpenReport suddenly failing, macro OpenReport succeeds

  • Thread starter Thread starter MattE
  • Start date Start date
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?
 
One more thing, it only is a problem on one machine (WinXP SP2),
others WinXP SP2 machines are still ok.
 
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!
 
Back
Top