By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Auto Select Records

P: n/a
Hello

I have a macro that opens up a table. I am wanting to delecte all
records from this table and then close the table. I do not want to
delete the table just all contents then close it. I have tried a few
different ways to delete all the records automatically but it does not
work.

Anybody know how to edit the macro to automatically select all the rows
of records and delete them then close the table?

Thank you

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Try this in code ...

CurrentDB.Execute "DELETE FROM tblMyTable"

Just make sure you really want to delete them. This will do it!
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"Troy" <an*******@devdex.com> wrote ...
Hello

I have a macro that opens up a table. I am wanting to delecte all
records from this table and then close the table. I do not want to
delete the table just all contents then close it. I have tried a few
different ways to delete all the records automatically but it does not
work.

Anybody know how to edit the macro to automatically select all the rows
of records and delete them then close the table?

Thank you

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.