How to clear/delete all data of access table by VB?

Hi all,

Please help me, how to clear/delete all data of access table when every time I hit cancel button command in VB application form and that table gonna be BLANK for next formload use.

Thank you very much,

ps: By the way, how to save time in DTPicker1 into D/T field of access table because it just show date only ? Thank in advances

Hello chuiwaucr,

Insert this line into your Cancel button code:

DoCmd.RunSQL ("DELETE * FROM YourTableName;")

its not clear (at least to me) what you want to do, are you clearing the form or are you deleting all/selected records in the database?

Hi JamesLe,

My cancel button in VB application form, when I put
DoCmd.RunSQL ("DELETE * FROM YourTableName;")

It says "variable not defined" (error highlight at DoCmd) when I compile program. Please
Help me more, I'd appreciate much.

Thanks so much JamesLe

Hi JamesLe,

I got it, thanks for your reply. By the way, how to save date and time from DTPicker of vbform into access table. Because I just save date only, I want both date and time.

thanks,

Hello chuiwaucr,

Try:
DTPicker1.Value = Now()