Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Wed Jan 28 15:42:09 CST 2004
Charlotte: No the main form has record source "tblPOHeader" and the sub-form on the second page of the tab has record source "tblPODetail". Rocky ----- Original Message ----- From: "Charlotte Foust" <cfoust at infostatsystems.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Wednesday, January 28, 2004 1:20 PM Subject: RE: [AccessD] Error 2468 - You can't carry out this actionatthepresent time. > It sounds like you may have the parent and child forms linked to the > same dataset. Do you? > > Charlotte Foust > > -----Original Message----- > From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] > Sent: Wednesday, January 28, 2004 1:04 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Error 2468 - You can't carry out this action > atthepresent time. > > > I'm getting closer. I deleted the sub-form that on the second tab of > the tab form and the two deletes worked. > > It has something to do with a sub form on a tab. Any clues, anybody? > > Rocky > > ----- Original Message ----- > From: "Joe K Anderson" <ja at alldatacorp.com> > To: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>; > <accessd at databaseadvisors.com> > Cc: "Wayne Warren Angelucci" <wayne.warren at adelphia.net>; "Gordon > Bennett" <gbennett at webdatacorporation.com>; "Barry Hynum" > <bhynum at cox.net>; "Dixon Foss" <dixon at fossware.net>; "Mark Krisburg" > <krisburg at opsoft.com> > Sent: Wednesday, January 28, 2004 11:44 AM > Subject: Re: [AccessD] Error 2468 - You can't carry out this action at > thepresent time. > > > You may need to do a Requery between deletes? > > joe > ----- Original Message ----- > From: Rocky Smolin - Beach Access Software > To: Access Developers discussion and problem solving > Cc: Wayne Warren Angelucci ; Mark Krisburg ; Joe Anderson ; Gordon > Bennett ; Dixon Foss ; Bob Heygood ; Barry Hynum > Sent: 01-28-2004 11:34 > Subject: Re: [AccessD] Error 2468 - You can't carry out this action at > the present time. > > > Randall: > > Tried this experiment just to get the DAO recordset out of the way. I > deleted all references to it. > > Then I replaced: > > 'DoCmd.SetWarnings False > 'DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 > 'DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 > 'DoCmd.SetWarnings True > > with > > DoCmd.RunCommand acCmdDelete > > I selected a record and ran that code which does the delete. Then > before > trying to delete the second record, I checked the table and the record > was > still there! > > So the delete (and probably other operations) are not completing for > some > reason. > > Pluse, when I get the error, I have to use the task manager to clear > access. > It won't quit, cant close any forms, etc. > > Any ideas? > > Many thanks in advance and regards, > > is > > ----- Original Message ----- > From: "Randall Anthony" <ranthony at wrsystems.com> > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Sent: Wednesday, January 28, 2004 10:31 AM > Subject: RE: [AccessD] Error 2468 - You can't carry out this action at > the > present time. > > > > Right off the top of my head, it has to do with the movefirst, > movelast. > I > > ran into this when converting A97 to A2K. Code worked in A97, not > A2K and > > M$ said this was designed behavior. I'll try to find the article. > > > > -----Original Message----- > > From: Rocky Smolin - Beach Access Software > [mailto:bchacc at san.rr.com] > > Sent: Wednesday, January 28, 2004 1:07 PM > > To: AccessD at databaseadvisors.com > > Subject: [AccessD] Error 2468 - You can't carry out this action at > the > > present time. > > > > Dear List: > > > > I am getting the following error message on a bound form: > > > > Error 2468 - You can't carry out this action at the present time. > > > > This form has a sub form linked to the main form by the main form's > primary > > key. (Main form is P.O. Header, subform is P.O. Detail). > > > > I get this error if I try to delete two records in a row. > > > > DoCmd.SetWarnings False > > DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 > > DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 > > DoCmd.SetWarnings True > > > > I also get this error after I try to add a record. The problem > started > > because I wanted to get the last PO in the file, add one to the PO > number, > > and put the prefix and the new PO number ito the new record: > > > > DoCmd.GoToRecord , , acNewRec > > > > 'If rstPOHeader.RecordCount <> 0 Then > > ' rstPOHeader.MoveLast > > ' Me.fldPOPrefix = Nz(rstPOHeader!fldPOPrefix) > > ' If IsNumeric(rstPOHeader!fldPONumber) Then > > ' Me.fldPONumber = rstPOHeader!fldPONumber + 1 > > ' fldPOOrderDate.SetFocus > > ' Else > > ' Me.fldPONumber.SetFocus > > ' End If > > 'End If > > 'If Nz(Me.fldPOPrefix) = "" And Nz(rstPOHeader!fldPOPrefix) = "" > Then > _ > > Me.fldPOPrefix.SetFocus > > > > Right now the code is commented out. If I uncomment the two lines: > > > > ' rstPOHeader.MoveLast > > ' Me.fldPOPrefix = Nz(rstPOHeader!fldPOPrefix) > > > > I get the error when I try to save: > > > > DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , > acMenuVer70 > > > > I checked the web and there is nothing. Has anyone encountered this > before? > > > > Thanks and regards, > > > > 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 > > _______________________________________________ > 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