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

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Wed Nov 2 14:55:24 CST 2005


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
>
>
>> >>
>> >> ----- 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
>
> -- 
> 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