vba code to delete specific data from Access table

Hi All

Can anyone please help me to write code in excel that will delete the records from Access table based upon a certain condition?

Thanks a lot.

Can anyone please answer my quesion?

Thanks

Hmm No, not really. You haven't given anywhere near enough information.

1. What have you done so far? What have you tried and what is the goal of this project?
2. Are you comfortable with SQL?
3. Why don't you do this directly in Access?

My whole project is developed in Excel as a frontend and Access as a backend. Now the client needs the ability to delete a dates worth of data. So that wehn they select the date from Excel userform and press Delete button then records for that date should be deleted from Access table. I know SQL so it will be something like as follows:

Please Login or Register  to view this content.

I hope now you can help me in wrting the vba code for this.

Thanks

What are you asking then? I'm confused, if you have a front end in Excel, you must be familiar with executing SQL against an access database.

Have you tried your SQL? You'll need to adjust it slightly to:

Please Login or Register  to view this content.

I just wanted to know how to run this sql statement. Please see the below code and hope you can help me to complete it.

Please Login or Register  to view this content.

Maybe like this:

Please Login or Register  to view this content.

Although I struggle to understand how you have written a front end in Excel without executing any statements against access

Thanks Kyle. It worked absolutely fine.