Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1750
  • Last Modified:

Closing a report Error "This action can't be carried out while processing a form or report event"

If not data then I messagebox and I am trying to do a DoCmd.Close and I get this error.  How do I stop the processing and allow this to close.  It is a report.
0
bostonroxx
Asked:
bostonroxx
1 Solution
 
cjswimmerCommented:
in the NoData Event of the report, just set Cancel = True
0
 
PaurthsCommented:
i would add that u trap the error that will be caused by the Cancel = True statement.

the on click event of the button with which u open the report (i assume a button is used, but u can use this also if u use e.g. a combobox' after update event):


Private Sub cmdOpenReport_Click()
On Error GoTo ErrHandler
 
    DoCmd.OpenReport "YourReport", acPreview

ErrHandler:
    If Err.Number = 2501 Then
        Err.Clear
        MsgBox "The report has no data..."
    End If
   
End Sub

cheers
Ricky
0
 
bostonroxxAuthor Commented:
I tried using the Cancel = True after the message box but this did not stop the processing.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
PaurthsCommented:
hi bostonroxx,

exactly what code are u running?

can u show here the code in the report and the code u use in the form?

I feel we need more info to be able to assist u better.

Ricky
0
 
PaurthsCommented:
are u still having problems with this one bostonroxx ?
0
 
PaurthsCommented:
any update bosonroxx?
0
 
PaurthsCommented:
Hi bostonroxx,

u been asking 8 Q's in 10 days, and have not graded 1.
Didn't anyone provide a correct comment?

u should follow up on your Q's. Experts put in time and effort for u, u know!

cheers
Ricky
0
 
cjswimmerCommented:
bostonroxx,  the messagebox function you showed was outside the scope of the report.  You need to put

   Cancel=True

inside the NoData() Event on the actual Report.

0
 
cjswimmerCommented:
and take out the DoCmd.Close
0
 
PaurthsCommented:
this is a waste of time,
grab the answer and run off without even a thanx...

added to BL.

cheers
Ricky
0
 
PaurthsCommented:
complete procedure on Date: 07/02/2001 10:45AM PST

worked a zillion times when testing it. It would be amazing if it would not work on another comp:

<
i would add that u trap the error that will be caused by the Cancel = True statement.


Private Sub Report_NoData(Cancel As Integer)
Cancel = True
End Sub


the on click event of the button with which u open the report (i assume a button is used, but u can
use this also if u use e.g. a combobox' after update event):


Private Sub cmdOpenReport_Click()
On Error GoTo ErrHandler

   DoCmd.OpenReport "YourReport", acPreview

ErrHandler:
   If Err.Number = 2501 Then
       Err.Clear
       MsgBox "The report has no data..."
   End If
   
End Sub

cheers
Ricky
>
0
 
costelloCommented:
Force accepting Paurths' comment.

costello
Community Support Moderator @ Experts-Exchange
0
 
cjswimmerCommented:
costello, can you please post the explanation as to why you accepted Paurths answer over mine?
0
 
PaurthsCommented:
b/c u were on honeymoon ... ?

:-)
cheers
0
 
cjswimmerCommented:
heh heh....probably...I looked over the posts again and agree that Paurths should get the points.
0
 
PaurthsCommented:
djeez, cjswimmer,

where do u live (aka : keep track of EE) ???
0
 
cjswimmerCommented:
Connecticut, USA
0
 
PaurthsCommented:
ah, i see

(was just to check b/c it was pretty late here (Belgium) when i posted, but i guess it was a respectable time over there...)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now