Execute Delete Where clause

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi

Can anyone please tell me the correct syntax for a where clause. I am using
execute to delete records from a table. It worked ok when I wanted all
records deleting but now I want to add a where clause and I get error 424
Object Required.

strCountry = Me![Country]

strSQL = "DELETE * FROM DealerSelection WHERE DealerSelection.Country
Code = " & strCountry

db.Execute strSQL, dbFailOnError

Thanks in advance for any help.
Sue
.

Relevant Pages

  • Re: What is the technique to supply a list of values to a where clause?
    ... the where clause has a "column in list" clause. ... When I try to run the code, DBI returns an error saying that the value ... execute with 10 variables when 2 were needed. ... element in the ArrayTupleStatus and in some cases it does not help ...
    (perl.dbi.users)
  • Re: user permissions
    ... I would like to add some comments regarding 'EXECUTE AS' clause in SQL ... Server 2005 as a complement of Rick's response. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.security)
  • Re: Do all the legs of an "OR" with null comparisons get executed?
    ... I did MMDDOB=1231, whenever MMDDOB was NULL the row would be filtered ... The WHERE clause is not working the way you expect, ... Placing as Oracle would evaluate the WHERE clause: ... going to execute something that reads ...
    (comp.databases.oracle.server)
  • What is the technique to supply a list of values to a where clause?
    ... I am working on a quick tool to update some records in an oracle ... database. ... the where clause has a "column in list" clause. ... execute with 10 variables when 2 were needed. ...
    (perl.dbi.users)
  • Re: for what are for/while else clauses
    ... print avalue, ... When somebody else "will the else clause execute", ... It seems misleading to me to focus on the controlling condition, i.e., ...
    (comp.lang.python)