Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Wed Jan 28 20:34:20 CST 2004
"Any way you look at it, it pays to make sure you know where you are before you try to do anything. " Good advice at any time. Brain fade dictates I address this in the a.m. Thanks for your input and have a nice night. 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 5:16 PM Subject: RE: [AccessD] Error 2468 - You can'tcarryoutthisactionatthepresenttime. > Yep, the command button wizard still writes Access 95 code. Cute, huh? > > Is there anything else on your form that has a connection to the same > table the parent form is based on? If not, then you need to make sure > there is a current record before you try deleting again. You might > stick some debug.print code in there to print the current Me.fldPOPrefix > or return the Me.NewRecord flag to see where you are. If you wind up on > a new record by deleting the last record in the recordset, then you'll > get an error if you try to go to a new record. If you're on the new > record when you try to delete, you'll get an error because there is no > current record. If you have started to create a new record, you can't > delete it because it isn't saved, and you can't go to NewRecord for the > same reason. Any way you look at it, it pays to make sure you know > where you are before you try to do anything. > > Charlotte Foust > > -----Original Message----- > From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] > Sent: Wednesday, January 28, 2004 5:07 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Error 2468 - You > can'tcarryoutthisactionatthepresenttime. > > > Trying to delete from the parent form. A parent record that has no > child records. > > For delete what should I use: DoCmd.RunCommand acDeleteRecord? > > That code came from the command button wizard. > > 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 4:22 PM > Subject: RE: [AccessD] Error 2468 - You can't > carryoutthisactionatthepresenttime. > > > > Ack! Lose that old A95 code, please! I can't even read it any more. > > Comment out the SetWarnings False and see what Access tells you about > > the operation. > > > > HOY! I just noticed that you appear to be running this from the > > parent form. Which form are you trying to delete a record from? > > > > Charlotte Foust > > > > -----Original Message----- > > From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] > > Sent: Wednesday, January 28, 2004 4:18 PM > > To: Access Developers discussion and problem solving > > Subject: Re: [AccessD] Error 2468 - You can't carry > > outthisactionatthepresenttime. > > > > > > Rats. No soap. Got the error on the second delete after adding the > > dbengineidle and the subfrm requery like this: > > > > > > DoCmd.SetWarnings False > > DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 > > DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 > > DoCmd.SetWarnings True > > > > DBEngine.Idle dbRefreshCache > > > > Me.Requery > > Me!subfrmPODetail.Requery > > > > Any other ideas? > > > > Thanks and regards, > > > > 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 3:47 PM > > Subject: RE: [AccessD] Error 2468 - You can't carry out > > thisactionatthepresenttime. > > > > > > > Rocky, > > > > > > I suspect you're running into an issue I've seen in somewhat similar > > > > circumstances, where the deletion didn't actually seem to get > > > processed until I requeried the subform. Have you tried a > > > DBEngine.Idle dbRefreshCache after the deletion? > > > > > > Charlotte Foust > > > > > > -----Original Message----- > > > From: Rocky Smolin - Beach Access Software > > > [mailto:bchacc at san.rr.com] > > > Sent: Wednesday, January 28, 2004 2:13 PM > > > To: Access Developers discussion and problem solving > > > Subject: Re: [AccessD] Error 2468 - You can't carry out > > > thisactionatthepresent time. > > > > > > > > > Charlotte: > > > > > > Further to my reply, I found that when I did a delete then, before I > > > > did anything else, I went and looked in the tblPOHeader and the > > > record > > > > > was still there. For some reason it's not completing the delete and > > > > that's why I think it's telling me that I can't make any moves at > > > this > > > > > time. > > > > > > 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 > > > > > > _______________________________________________ > > > 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 > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com