Deleting a record, still!

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
 
P

Principiante

Prove it.

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

Principiante. Spain.

Mike J escribió:
 

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

VBA works in orignal but fails in copy of database 1
Modify sql statement 2
Deleting a Form & SubForm Record 1
Add new record to related table and show data on form 2
Duplicate record in Form and Subform 0
Deleting a table 8
Check Box query issue 3
Two few parameters. Expected 2 1

Top