DELETE FROM statement

[Jochem Davids]

I'm trying to run a DELETE sql statement, based on two ComboBoxes.

CurrentDb.Execute ("DELETE FROM tblOne WHERE tblTwo.[Id] <> " & cboId & "
AND tblname.[name] <> " & cboName & " "), dbFailOnError

Both seperate they work fine...This AND statement will not work?!
I also tried && ... What should I use?

 

[Stefan Hoffmann]

hi Jochem,

I'm trying to run a DELETE sql statement, based on two ComboBoxes.

CurrentDb.Execute ("DELETE FROM tblOne WHERE tblTwo.[Id] <> " & cboId & "
AND tblname.[name] <> " & cboName & " "), dbFailOnError

You need to enclose the name in quotes:

Both seperate they work fine...This AND statement will not work?!
I also tried && ... What should I use?

Create a query based on that conditions (you don't need the quotes here):

SELECT *
FROM tblOne
WHERE tblTwo.[Id] <> Forms!YourForm!cboId
AND tblname.[name] <> Forms!YourForm!cboName

Is there any data?


mfG
--> stefan <--

 

[Ofer Cohen]

If the [Name] Field is text type try adding single quote be fore and after

CurrentDb.Execute ("DELETE FROM tblOne WHERE tblTwo.[Id] <> " & cboId & "
AND tblname.[name] <> '" & cboName & "'"), dbFailOnError