[AccessD] vba to Delete mult records continous form

Kath Pelletti KP at sdsonline.net
Tue May 10 21:21:33 CDT 2005


Yes Rocky - but when the criteria is multiple selected records (not one) on a continuous form then what does StrCriteria become??
  ----- Original Message ----- 
  From: Rocky Smolin - Beach Access Software 
  To: Access Developers discussion and problem solving 
  Sent: Wednesday, May 11, 2005 12:15 PM
  Subject: Re: [AccessD] vba to Delete mult records continous form


  Kath:

  dim db as DAO.Database
  Set db = Currentdb

  db.Execute "Delete * FROM tblXYZ WHERE fldSomeField = '" & strCriteria & "'"

  Without the WHERE clause it will delete all the records in the table.

  Rocky

  ----- Original Message ----- 
  From: "Kath Pelletti" <KP at sdsonline.net>
  To: <AccessD at databaseadvisors.com>
  Sent: Tuesday, May 10, 2005 6:03 PM
  Subject: [AccessD] vba to Delete mult records continous form


  RESENDING THIS AS IT DIDN'T APPEAR?

  --------------------------------------------------------------------------------

  Hi everyone - maybe I am just having a bad day but can someone tell me the 
  code I need in vba to do the same action as the [Records]  [Delete] menu? 
  ie. I have a continuous form, user selects a block of records to delete.

  If I use DoCmd.RunCommand acCmdDeleteRecord then it only takes out the first 
  rec.

  How can I get rid of them all? I could do it with a delete sql string if I 
  knew how to reference the selected records.

  TIA
  Kath

  ______________________________________________
  Kath Pelletti
  Software Design & Solutions Pty Ltd.
  -- 
  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