Results 1 to 2 of 2

Thread: Macro to delete records in table

  1. #1
    Sylvia Delgado Guest

    Macro to delete records in table

    I am trying to develop a macro in Microsoft Access 97 to delete all records within a table. I am having trouble developing it can someone help

  2. #2
    Darryl Caillouet Guest

    Macro to delete records in table (reply)

    Macro:
    SetWarnings - No
    RunSQL - DELETE FROM tablename
    SetWarnings - Yes

    VBA code:
    DoCmd.SetWarnings False
    DoCmd.RunSQL "DELETE FROM tablename"
    DoCmd.SetWarnings True


    ------------
    Sylvia Delgado at 11/20/2001 9:00:37 AM

    I am trying to develop a macro in Microsoft Access 97 to delete all records within a table. I am having trouble developing it can someone help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •