[AccessD] vba to Delete mult records continous form

Continuous form with record selectors...users drag to select a block of records.
  ----- Original Message ----- 
  From: Rocky Smolin - Beach Access Software 
  To: Access Developers discussion and problem solving 
  Sent: Wednesday, May 11, 2005 1:03 PM
  Subject: Re: [AccessD] vba to Delete mult records continous form


  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

  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com