Deleting a record, still!

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

Mike J

Ok, from a post on the 29th I am using the stmnt below to
delete a record:
strDelRnd = "Delete * From [Date Played] Where (([id] = "
& MainID & ") AND ([Date Played] = Rnd_Date))"
DBEngine(0)(0).Execute strDelRnd, dbFailOnError

Note: rnd_Date has the #'s around it.

This is a takeof of what was given to me on the 29th post
reply.

But when I run it, I am getting runtime error 3061: Too
few parms: Expected 1.

What am I missing? Thanks
 
Prove it.

strDelRnd = "Delete * From [Date Played] Where (([id] = "
& MainID & ") AND ([Date Played] = "& Rnd_Date

Principiante. Spain.

Mike J escribió:
 
Back
Top