Can't use string for a table name within runsql delete statement 1

[vba317]

I am trying to use an runsql statement to run a delete query using a string for the table. I have tried many different ways to do this with no luck. I usually get compile errors the current method I am using the error message is Cant find the table strTbl1Namewoext you are looking for. Any help is greatly apprecaited.

Dim strDelete As String
Dim strTbl1Namewoext As String

strTbl1Namewoext = "NBM_CS_Data"

strDelete = "DELETE * FROM [strTbl1Namewoext]"
DoCmd.RunSQL strDelete

 

[PHV]

strDelete = "DELETE * FROM " & strTbl1Namewoext

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

And, in case you have strange table names:
strDelete = "DELETE * FROM [" & strTbl1Namewoext & "]"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Andrzejek]

Once again, you can help yourself by:

strDelete = "DELETE * FROM [strTbl1Namewoext]"[red]
Debug.Print strDelete[/red]
DoCmd.RunSQL strDelete

so you could see what's wrong

Have fun.

---- Andy