Delete records from table 1

[wmbb]

I want to create a button to delete all records in the table "tbltextimport".
What is the code for the macro ?

thanks in advance

 

[PHV]

VBA code:
DoCmd.RunSQL "DELETE * FROM tbltextimport"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[wmbb]

Thx, That was what I needed !

 

[wmbb]

Running the script I get a confirmation-box.
Is it possible to delete the records without the confirmation-box ?

 

[JerryKlmns]

'No warnings
Docmd.SetWarnings False
'Warnings are back
DoCmd.SetWarnings True

 

[HarleyQuinn]

Have a look at DoCmd.SetWarnings.

DoCmd.SetWarnings False will turn them off.

I'd recommend only turning it off for specific operations, and the re-enabling it after the operation has been performed.

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[HarleyQuinn]

Too fast Jerry...

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[JerryKlmns]

You added some recommendation flavor there, resulting in extra time to taste.

 

[HarleyQuinn]

Haha

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.