Charlotte Foust
cfoust at infostatsystems.com
Thu Jan 29 10:58:54 CST 2004
Glad you got it solved. Sometimes the obvious gets overlooked. Charlotte Foust -----Original Message----- From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] Sent: Thursday, January 29, 2004 8:51 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Error 2468 - You can'tcarry out this action at thepresent time - solved Charlotte: Well I solved it. It turns out that I'm using the ADH resizing code and had the resizer called in the open event of the subform. When I removed that one line of code, everything started to work. I have no idea why that resizing code hosed the record operations. But once I figured out it was something in the subform, I deleted all the subform code and everything worked that failed before. So then I restored the code and began to remove one module at a time and it wasn't long before I removed the OnOpen event code and everything worked. So then since there was only a few lines of code in that module, it was a simple matter to guess it was the adhScaleForm routine. Thanks for your input. Rocky ----- Original Message ----- From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Wednesday, January 28, 2004 6:34 PM Subject: Re: [AccessD] Error 2468 - You can'tcarryoutthisactionatthepresenttime. > "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 > > _______________________________________________ > 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