[AccessD] Error 2468 - You can't carry out this action at the present 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
  >