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 >