[AccessD] Stop Code During Report

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Tue Oct 14 18:58:59 CDT 2003


Charlotte:

Got it. It works!  Thanks so much.

It didn't at first until I saw your comment that the report has to have a
module for it to work.  So I put in blank procedures for Open, Close, and
NoData ad it worked.

Best,

Rocky Smolin
Beach Access Software


----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, October 14, 2003 4:20 PM
Subject: RE: [AccessD] Stop Code During Report


> Rocky,
>
> I'm sending you a demo OL that shows you what I mean.
>
> Charlotte Foust
>
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> Sent: Tuesday, October 14, 2003 3:02 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Stop Code During Report
>
>
> Charlotte:
>
> Not completely confused.  Partially. :)
>
> So what I have now is:
>
> Some Code 1
>
> DoCmd.OpenReport "rptX", acVeiwPreview
>
> Some More Code 2
>
> So I would put Some More Code 2 into another module and run it from the
> OnClose event of the report?
>
> How do I run that code from the OnClose event of the report?
>
> Thanks and regards,
>
> Rocky
>
>
> ----- Original Message ----- 
> From: "Charlotte Foust" <cfoust at infostatsystems.com>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Tuesday, October 14, 2003 12:50 PM
> Subject: RE: [AccessD] Stop Code During Report
>
>
> > You could use WithEvents from the calling form to open the report and
> > trap the Report_OnClose event.  The code in the routine that opens the
>
> > report would end after opening the report, but the local OnClose event
>
> > for the report would trigger whatever code you put into that custom
> > routine.  That's the way I normally do it.  Does it sound completely
> > confused?
> >
> > Charlotte Foust
> >
> > -----Original Message-----
> > From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> > Sent: Tuesday, October 14, 2003 11:25 AM
> > To: AccessD at databaseadvisors.com
> > Subject: [AccessD] Stop Code During Report
> >
> >
> > Dear List:
> >
> > Is there an easy way to suspend execution of code while a report is
> > open?
> >
> > MTIA
> >
> > Rocky Smolin
> > Beach Access Software
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list