[AccessD] Error 2468 - You can'tcarry out this action at thepresent time - solved

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


More information about the AccessD mailing list