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

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Thu Jan 29 11:02:59 CST 2004


Uh-oh.  Write in haste.  Repent at leisure.  Can now add multiple POs but
deletes still do not work.

Back to the drawing board.

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: Thursday, January 29, 2004 8:51 AM
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