DoCmd.RunSQL "DELETE * Using Me.Text Box

[Vagus14]

Hi everyone,

I am trying to get the code below to delete rows with the specific text in Me!Project_Name. I have the code 99% complete, however, the "Enter Parameter box" is poping up and a blank input box. I can input the same text and it'll run but I want to bypass this "Parameter box". Thanks for your help. Code below:

    DoCmd.RunSQL "DELETE * FROM " _
        & "tblProjectData WHERE [Project Name]=" & Me!Project_Name & ";"

Issue: Parameter Box keeps poping up with the ME!Project_Name text and a box to enter text.

It's probably something real simple I'm missing... Please help out even if it is a simple solution...

 

[Vagus14]

This doesn't seem to be working either....

CurrentDb.Execute "DELETE * FROM tblProjectData WHERE [Project Name]=" & Me!Project_Name & ";"

Error I get: Syntax Error (missing operator) in query expression '[Project Name] = '

Can I get some help. It will be much appreciated.

 

[jdraw]

Try (untested) --Note: I added 2 single quotes

CurrentDb.Execute "DELETE * FROM tblProjectData
 WHERE [Project Name]='" & Me!Project_Name & "';", dbFailOnError

 

[Vagus14]

jdraw... That was it!!

Thanks so much!

CurrentDb.Execute "DELETE * FROM tblProjectData WHERE [Project Name]='" & Me!Project_Name & "';"