Newbie needs some help 1

[issunboshi]

Not sure if this is the right place for this, but here goes. I am trying to write a small access app that will import data typed into text fields into a table, then when finished, export the data from the table into various formats. Doing pretty good, but have hit a brickwall on a few parts. If you folks would be kind enough to help out with some coding, it would be greatly appreciated. What i am looking for:

The code to be able to delete all the records from a table using a command button click. E.g. delete all records from table1.

The code to export the data from a query into a csv file.

I know, I am lazy, but it's a small app, and it's been too many years since I have programmed in VB. Any help? Please? You can have my first born!!!

Ken

 

[Apollo13a]

Ken, here's code to delete all records from your table.

DoCmd.RunSQL ("DELETE from [YourTableName]")

jim

 

[issunboshi]

Thanks Jim, works like a charm, one down, one to go... thanks again.

Ken