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