PC Review


Reply
Thread Tools Rate Thread

DoCmd.OpenReport suddenly failing, macro OpenReport succeeds

 
 
MattE
Guest
Posts: n/a
 
      1st Sep 2007
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?

 
Reply With Quote
 
 
 
 
MattE
Guest
Posts: n/a
 
      1st Sep 2007
One more thing, it only is a problem on one machine (WinXP SP2),
others WinXP SP2 machines are still ok.

 
Reply With Quote
 
MattE
Guest
Posts: n/a
 
      4th Sep 2007
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!

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
DoCmd.OpenReport suddenly failing, macro print prints same report ok MattE Microsoft Access Reports 2 4th Sep 2007 06:24 PM
DoCmd.Openreport? MJJ Microsoft Access Form Coding 2 10th Jun 2004 06:01 PM
Help with: Docmd.OpenReport =?Utf-8?B?RmVsaWNpYSBGaXNoZXI=?= Microsoft Access Form Coding 2 2nd Mar 2004 02:16 PM
DoCmd.OpenReport Gail Microsoft Excel Programming 0 24th Feb 2004 10:02 PM
Still need help w/DoCmd.OpenReport Tony Girgenti Microsoft Access Form Coding 9 18th Oct 2003 01:06 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:52 PM.