Yes you can do it in code, here is a sample:
DoCmd.RunSQL "delete * from [842-2486 Heads]"
where "[842-2486 Heads]" is the name of the table.
Or you can create a delete query by selecting the query type in the query
section of access.
let me know if this helps.
Delete [table name].[ID], [table name].[additional name] From [table name]
Where ((([table name].[ID])>0));
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.