Hello experts, in an effort to gain a greater understanding of coding in access, I'm trying to remove all my docmd. statements. While they were handy initially, I feel they have reduced my knowledge curve. That said, please tell me what I'm doing wrong in the code below and why do I get the message "Invalid Qualifier". The DoCmd query was simply a delete everything from a table type.
Dim db As DAO.Database
Dim QryDefinition As DAO.QueryDef
Dim strSql As String
On Error GoTo errorhandler
strSql = "DELETE tmptblWeeklyInvoice.* FROM tmptblWeeklyInvoice;"
Set db = OpenDatabase(CurrentProject.Path & "\MyComicShopTables.accdb")
Set db = Nothing
Set qrydefintion = Nothing
MsgBox Err.Number & ":" & Err.Description