[AccessD] Fw: E-Z-MRP(tm) Error Report

Rocky,

Did you try to do it this way?:

DoCmd.Close acForm, "frmMaterialPlanning"
DoCmd.OpenForm ("frmMainMenu")

I.e. change the sequence of close and open form statements?

What version of MS Access do you use?
Do you have any ActiveX controls on your forms?
Do you have timer control on your forms?
Do you use DoEvents statements in your code called directly or indirectly
while frmMainMenu is being opened and frmMaterialPlanning is being closed?

Open form and close form are synchronous operations but they can queue
asynchronous operations like processing events of ActiveX controls (e.g.
Treeview) - and when they will be processed depends on many factors...

Shamil


> >>
> >> ----- Original Message ----- 
> >> From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
> >> To: <AccessD at databaseadvisors.com>
> >> Sent: Monday, October 31, 2005 6:42 PM
> >> Subject: [AccessD] Fw: E-Z-MRP(tm) Error Report
> >>
> >>
> >>> Dear List:
> >>>
> >>> Does anyone know why a user should generate this error:
> >>>
> >>> Error: 2585 - This action can't be carried out while processing a form
> >>> or
> >>> report event.
> >>> In: frmMaterialPlanning.cmdExitToMainMenu_Click
> >>>
> >>> It occurs in a sub menu - unbound form.  The click routine just opens
> >>> the
> >>> main menu and closes this sub menu.  It doesn't occur consistently.  I
> >>> can't
> >>> get it to repeat and a couple of users who have gotten it can't get it
> >>> to
> >>> occur with any regularity.  Some users never get it.
> >>>
> >>> The code in the click event (I stripped out the error trapping) is:
> >>>
> >>>    DoCmd.OpenForm ("frmMainMenu")
> >>>    DoCmd.Close acForm, "frmMaterialPlanning"
> >>>
> >>> Any ideas?
> >>>
> >>> MTIA,
> >>>
> >>> Rocky Smolin
> >>> Beach Access Software
> >>> http://www.e-z-mrp.com
> >>> 858-259-4334
> >>>
> >>> ----- Original Message ----- 
> >>> From: "Laurie" <laurie at deKalblogistics.com>
> >>> To: <bchacc at san.rr.com>
> >>> Sent: Monday, October 31, 2005 9:35 AM
> >>> Subject: E-Z-MRP(tm) Error Report
> >>>
> >>>
> >>> Error: 2585 - This action can't be carried out while processing a form
> >>> or
> >>> report event.
> >>> In: frmMaterialPlanning.cmdExitToMainMenu_Click
> >>> -- 
> >>> Internal Virus Database is out-of-date.
> >>> Checked by AVG Anti-Virus.
> >>> Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/2005
> >>>
> >>>
> >>>
> >>> -- 
> >>> AccessD mailing list
> >>> AccessD at databaseadvisors.com
> >>> http://databaseadvisors.com/mailman/listinfo/accessd
> >>> Website: http://www.databaseadvisors.com
> >>>
> >>>
> >>> -- 
> >>> No virus found in this incoming message.
> >>> Checked by AVG Free Edition.
> >>> Version: 7.1.362 / Virus Database: 267.12.6/151 - Release Date:
> >>> 28.10.2005
> >>>
> >>>
> >>
> >> -- 
> >> 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
> >
> >
> > -- 
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.362 / Virus Database: 267.12.7/155 - Release Date:
01.11.2005
> >
> >
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com