delete all rows in a table

[Rivers]

can someone please advise me on the way i can delete all rows in my table
called "00 1-1 booked" i tried the delete method in VB but to no avail is it
possible to call a delete method from vb. i still want the structure to
survive but the recdords to be deleted.

thanks

 

[fredg]

can someone please advise me on the way i can delete all rows in my table
called "00 1-1 booked" i tried the delete method in VB but to no avail is it
possible to call a delete method from vb. i still want the structure to
survive but the recdords to be deleted.

thanks

Is it a one time deal?
Just open the table. Select all the records by (clicking in the little
square in the left hand corner where the gray field names meets the
record selectors).
Press the Delete key.

You can delete all records using a delete query,
or
you can use VBA code:

CurrentDb.Execute 'Delete * from TableName;", dbFailOnError

All the date will be deleted, but the fields and properties will be
untouched.

 

[Jeanette Cunningham]

Rivers,
referential integrity can prevent records from being deleted.
If this is your situation, delete records from any child tables before you
try to delete records from any parent table.

Jeanette Cunningham

 

[Rivers]

I tried the command already but this did not work is there another way?

Rivers,
referential integrity can prevent records from being deleted.
If this is your situation, delete records from any child tables before you
try to delete records from any parent table.

Jeanette Cunningham

 

[Rivers]

TableName = "00 1-1 booked"
CurrentDb.Execute " Delete * from TableName;", dbFailOnError

this command doesnt work what am i doing wrong please help

thanks

I tried the command already but this did not work is there another way?

 

[Rick Brandt]

TableName = "00 1-1 booked"
CurrentDb.Execute " Delete * from TableName;", dbFailOnError

this command doesnt work what am i doing wrong please help

The variable cannot be inside the quotes or else the query will actually
looking for a table named "TableName".

TableName = "00 1-1 booked"
CurrentDb.Execute " Delete * from " & TableName, dbFailOnError

 

[Rick Brandt]

The variable cannot be inside the quotes or else the query will
actually looking for a table named "TableName".

TableName = "00 1-1 booked"
CurrentDb.Execute " Delete * from " & TableName, dbFailOnError

Sorry, I completely missed the ramifications of this (really horrible) table
name on the process. It will of course need to have square brackets around
it because of the spaces and the fact that the name begins with a digit.

TableName = "[00 1-1 booked]"
CurrentDb.Execute " Delete * from " & TableName, dbFailOnError

 

[Bob Quintal]

TableName = "[00 1-1 booked]"
CurrentDb.Execute "Delete * From" & TableName, dbFailOnError

tried this but it asks for a parameter as it is missing

if that's pasted from your module, you are missing a space between
from and "

Rivers wrote:
TableName = "00 1-1 booked"
CurrentDb.Execute " Delete * from TableName;", dbFailOnError

this command doesnt work what am i doing wrong please help

The variable cannot be inside the quotes or else the query will
actually looking for a table named "TableName".

TableName = "00 1-1 booked"
CurrentDb.Execute " Delete * from " & TableName, dbFailOnError

Sorry, I completely missed the ramifications of this (really
horrible) table name on the process. It will of course need to
have square brackets around it because of the spaces and the fact
that the name begins with a digit.

TableName = "[00 1-1 booked]"
CurrentDb.Execute " Delete * from " & TableName, dbFailOnError

 

[Rivers]

TableName = "[00 1-1 booked]"
CurrentDb.Execute "Delete * From" & TableName, dbFailOnError

tried this but it asks for a parameter as it is missing

The variable cannot be inside the quotes or else the query will
actually looking for a table named "TableName".

TableName = "00 1-1 booked"
CurrentDb.Execute " Delete * from " & TableName, dbFailOnError

Sorry, I completely missed the ramifications of this (really horrible) table
name on the process. It will of course need to have square brackets around
it because of the spaces and the fact that the name begins with a digit.

TableName = "[00 1-1 booked]"
CurrentDb.Execute " Delete * from " & TableName, dbFailOnError

 

[fredg]

TableName = "[00 1-1 booked]"
CurrentDb.Execute "Delete * From" & TableName, dbFailOnError

tried this but it asks for a parameter as it is missing

Rivers wrote:
TableName = "00 1-1 booked"
CurrentDb.Execute " Delete * from TableName;", dbFailOnError

this command doesnt work what am i doing wrong please help

The variable cannot be inside the quotes or else the query will
actually looking for a table named "TableName".

TableName = "00 1-1 booked"
CurrentDb.Execute " Delete * from " & TableName, dbFailOnError

Sorry, I completely missed the ramifications of this (really horrible) table
name on the process. It will of course need to have square brackets around
it because of the spaces and the fact that the name begins with a digit.

TableName = "[00 1-1 booked]"
CurrentDb.Execute " Delete * from " & TableName, dbFailOnError

When replying to a question many times we use generic names, such as
YourTable, MyTable, FormName, ControlName, etc.
You're supposed to replace those generic names with your actual object
names

Why are you placing the table name in a variable?
Substituting your table name for the generic YourTable, this works for
me:

CurrentDb.Execute "Delete * from [00 1-1 booked];", dbFailOnError