[AccessD] vba to Delete mult records continous form

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Tue May 10 22:03:24 CDT 2005


Kath:

How are the records being selected?

Rocky

----- Original Message ----- 
From: "Kath Pelletti" <KP at sdsonline.net>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Tuesday, May 10, 2005 7:21 PM
Subject: Re: [AccessD] vba to Delete mult records continous form


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
-- 
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