Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Wed Jan 28 19:06:42 CST 2004
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 >