docmd.openquery

[MoonBlosm]

I am attempting to run a delete query. I don't want the delete query to
delete all records just records where [projectnum] = me.projectnum. When I
do a docmd.openquery, I can delete them all. I do not know how to send a
parameter to this delete query so it only deletes specified records. I have
the code in a button on a form. IF this cant be done, does anyone know of a
better way to delete specific records from a button on a form? Thanks for
your help in advance!

 

[Klatuu]

--
Dave Hargis, Microsoft Access MVP

Here is a better way:

Dim strSQL As String

strSQL = "DELETE * FROM MyTable WHERE [projectnum] = " & Me.projectnum &
";"
Currentdb.Execute strSQL, dbFailOnError

The above syntax in the SQL assumes projectnum is a numeric field. If it is
text, use this syntax:

strSQL = "DELETE * FROM MyTable WHERE [projectnum] = """ & Me.projectnum
& """;"

 

[Marshall Barton]

I am attempting to run a delete query. I don't want the delete query to
delete all records just records where [projectnum] = me.projectnum. When I
do a docmd.openquery, I can delete them all. I do not know how to send a
parameter to this delete query so it only deletes specified records. I have
the code in a button on a form. IF this cant be done, does anyone know of a
better way to delete specific records from a button on a form?

Dim strSQL As String
strSQL = "DELETE * FROM table " _
"WHERE projectnum = " & me.projectnum
CurrenDb.Execute strSQL, dbFailOnError

 

[MoonBlosm]

Thank you... I knew there had to be an easier way. You guys are always so
helpful!

--
Dave Hargis, Microsoft Access MVP

Here is a better way:

Dim strSQL As String

strSQL = "DELETE * FROM MyTable WHERE [projectnum] = " & Me.projectnum &
";"
Currentdb.Execute strSQL, dbFailOnError

The above syntax in the SQL assumes projectnum is a numeric field. If it is
text, use this syntax:

strSQL = "DELETE * FROM MyTable WHERE [projectnum] = """ & Me.projectnum
& """;"

I am attempting to run a delete query. I don't want the delete query to
delete all records just records where [projectnum] = me.projectnum. When I
do a docmd.openquery, I can delete them all. I do not know how to send a
parameter to this delete query so it only deletes specified records. I have
the code in a button on a form. IF this cant be done, does anyone know of a
better way to delete specific records from a button on a form? Thanks for
your help in advance!