How can I use a Microsoft Access Module to run an SQL Update or DELETE statement on a table in the database?
Shane
Printable View
How can I use a Microsoft Access Module to run an SQL Update or DELETE statement on a table in the database?
Shane
Search this forum for ADO and Access. That should give you some pointers.
VB Code:
Sub RunMySql() Dim strSql As String strSql = "DELETE * FROM tblFOO" DoCmd.RunSql strSql End Sub