Need Help in delete command event

[leonald007]

I am really new to visual basic programming language. I want to design a form with a list box and delete button. when i select a particular month and press delete it will delete with the query. the code dont work. hope u guys can help pls. thx in advance


Private Sub Command4_Click()

ListBox ListBox1

Month1 = ListBox1.Value

Dim SQL As String

SQL = "DELETE FROM Table2 where Datetime = Month1 "


MsgBox "Deleted !"



End Sub

[FishVal]

I am really new to visual basic programming language. I want to design a form with a list box and delete button. when i select a particular month and press delete it will delete with the query. the code dont work. hope u guys can help pls. thx in advance


Private Sub Command4_Click()

ListBox ListBox1

Month1 = ListBox1.Value

Dim SQL As String

SQL = "DELETE FROM Table2 where Datetime = Month1 "


MsgBox "Deleted !"



End Sub

Hi, there.

Take a look at "Month" VBA function.

[leonald007]

hihi thx....
But wher do i look at "Month" VBA function.?

[leonald007]

Hey i saw the month function , but the current problem is i do not know how do the delete query. Is the any required connection to the database from the vba codes. when i view the form and click the button, it does not execute the query.

[FishVal]

Hey i saw the month function , but the current problem is i do not know how do the delete query. Is the any required connection to the database from the vba codes. when i view the form and click the button, it does not execute the query.

:)

And now take a look at DoCmd.RunSQL.

Regards,
Fish