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

<<<
> Thought you had to open the next form before closing the current one.  No?
>>>
No, it's not necessary.
Despite the fact form is closed its code behind finishes OK.
But beware when form is closed its local form level variables become
deinitialized therefore they can't be used while form is closing....

<<<
although a user could obviously run the A2K mde with
> A2K2 or A2K3
>>>
This can be the source of the problem.
I have seen such weird effects for Acc2K add-ins(mda) running under AXP and
A2003...

Shamil

----- Original Message ----- 
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, November 02, 2005 11:55 PM
Subject: Re: [AccessD] Fw: E-Z-MRP(tm) Error Report


> Shamil:
>
> Thought you had to open the next form before closing the current one.  No?
>
> Other questions:
> mde compiled in A2K (although a user could obviously run the A2K mde with
> A2K2 or A2K3)
> No ActiveX controls.
> No timer control or event.
> No DoEvents.
>
> Any clues there?
>
> Regards,
>
> Rocky
>
>
> ----- Original Message ----- 
> From: "Shamil Salakhetdinov" <shamil at users.mns.ru>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Wednesday, November 02, 2005 12:48 PM
> Subject: Re: [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
> >
<<< tail skipped>>>