sql delete syntax

A

Alex

Can someone please help me with my syntax.

strSQL = "DELETE * FROM AllNewParts WHERE [Model] = Me.Model & [Part] =
Me.New Part & [NHL] = Me.New Part NHL

I am trying to delete records from the AllNewParts table and I have a hard
time with this syntax. All 3 fields are text. Thanks for your help. Alex
 
K

Klatuu

strSQL = "DELETE * FROM AllNewParts WHERE [Model] = '" & Me.Model & "'
AND[Part] = '" & Me.[New Part] & "' AND [NHL] = '" & Me.[New Part NHL] & "'"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unmatched record query help 5
Delete button dode 4
Delete button and refresh 8
Do Until Loop help 1
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Search for previous or next record 2
Delete and go to previous record 1
Help creating a search form in Access XP 0

Top