Delete record howto?

  • Thread starter Thread starter Mike J
  • Start date Start date
M

Mike J

I have a table that has an ID field and a Date field.
There would be many records with the same ID in this table
but all the dates for that ID are different. So, I wanna
search for a record with an ID and a specific date and
then delete it. I'm having trouble doing this; can
someone show me how? Thanks.
 
Mike J said:
I have a table that has an ID field and a Date field.
There would be many records with the same ID in this table
but all the dates for that ID are different. So, I wanna
search for a record with an ID and a specific date and
then delete it. I'm having trouble doing this; can
someone show me how? Thanks.
Click to expand...

If the date has no time component (actually a time of midnight) then it
would be something like...

DELETE * FROM YourTableName
WHERE ID = 123
AND DateField = #1/1/2004#
 
-----Original Message-----


If the date has no time component (actually a time of midnight) then it
would be something like...

DELETE * FROM YourTableName
WHERE ID = 123
AND DateField = #1/1/2004#


.
Thanks for the fast comeback. I can then use variables
Click to expand...
instead of constants?
 
Sure. This example picks up the values form text boxes on your form:

strSql = "DELETE FROM YourTableName WHERE (([ID] = " & Me.txtWhatID & ") AND
([DateField] = #" & Format(Me.txtWhatDate, "mm\/dd\/yyyy") & "#));"

dbEngine(0)(0).Execute strSql, dbFailOnError
 
-----Original Message-----
I have a table that has an ID field and a Date field.
There would be many records with the same ID in this table
but all the dates for that ID are different. So, I wanna
search for a record with an ID and a specific date and
then delete it. I'm having trouble doing this; can
someone show me how? Thanks.
.
I tried this stmnt(s) in the code:
Click to expand...
strDelRnd = "Delete * From rstRound Where (([id] = " &_
MainID & ") AND ([Date Played] = Rnd_Date));"
DBEngine(0)(0).Execute strDelRnd, dbFailOnError

and got a syntax error. Rnd_date is formatted with the
#'s around it in a previous stmnt above. I thought this
would work per previous update. What am I doing wrong or
not seeing? Thanks
 
Back
Top