VBA Delete Query Assistance

[cstickman]

Hey Guys,

I just need a simple assistance with a delete query. I have a table called tbluser and five columns, ID, racf, username, security, password. When the user selects on a name and then clicks on the delete button. I have this as my code, but I am getting an error for the table name. I believe it is a compile error. Below is my code and I am sure it is something that I am missing.

I do apologize in advance for asking what seems to be small questions, but I am trying to learn and understand it. Thanks

<code>
Dim strSQL As String

strSQL = "DELETE * FROM "tbluser" WHERE username = 'Me.txtusername';"

CurrentDb.Execute strSQL
</code>

 

[Joe4]

The important thing to remember when creating strings is that anything between the double-quotes are considered "literal" text. If you want to return the values from variables or objects, they must be outside of the double-quotes, i.e.

[COLOR=#333333][FONT=monospace]strSQL = "DELETE * FROM tbluser WHERE username = '" & Me.txtusername & "';"[/FONT][/COLOR]

Like I recommend in the previous post we were working on, use a MsgBox to return the value of your string. This allows you to see what it is, and if you have written a valid command, i.e.

MsgBox strSQL

What I like to do is manually create a query that does an example of what I want to do, then switch to SQL View to see what it should look like. This is what you are trying to build in VBA. So you can use the MsgBox to compare what you have built with what it needs to look like.

 

[cstickman]

Thanks Joe!! I see what I was doing wrong. I will have to remember the & and spaces between the variables. I will start getting into habit of typing in MsgBox strSQL.