Results 1 to 4 of 4

Thread: access

  1. Oct 1st, 2001, 01:55 PM #1
    davidcard
    davidcard is offline

    Thread Starter
    Lively Member
    Join Date
    May 2001
    Location
    A pub that sells Kronenburg
    Posts
    116

    access

    is there any way of erasing all data on an access sheet??
    Reply With Quote Reply With Quote
  2. Oct 1st, 2001, 01:55 PM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333
    Whats an Access sheet?
    Reply With Quote Reply With Quote
  3. Oct 1st, 2001, 01:58 PM #3
    davidcard
    davidcard is offline

    Thread Starter
    Lively Member
    Join Date
    May 2001
    Location
    A pub that sells Kronenburg
    Posts
    116
    sorry, access database
    Reply With Quote Reply With Quote
  4. Oct 1st, 2001, 02:12 PM #4
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333
    Do you want to delete all data in all tables quickly? (I assume that because deleting the .MDB itself is just a one liner.)

    First, load all of the table names in to a Listbox, or something like that, and then loop through the listbox inserting each entry into a one line SQL statement.

    Dim SQL As String
    Dim i As Integer

    For i = 0 to List1.ListCount - 1
    SQL = "DELETE FROM " & List1.List(i)
    DatabaseObject.Execute SQL
    Next
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width