Debug - Delete data in Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried to run the following code so widely suggested but I get a "Run-time
error '424': Object required" message box. I'm a newbie so let me know what
I'm doing wrong


Function DeleteDataFromDatabase()

Current.Db.Execute "DELETE * FROM tblDraftConversionTable", dbFailOnError

End Function

Los Man
 
I figured it out:

Function DeleteDataFromDatabase()

CurrentDb.Execute "DELETE * FROM tblDraftConversionTable", dbFailOnError

End Function

CurrentDb.Execute, not Current.Db.Execute.

I'm going to go insane,
Los Man
 
You must log in or register to reply here.

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

Calling a form in variable 1
Use a form's control value as a table name 2
Database Connection to SQL from Access 2003 5
Update Field Data Type 3
VBA - query reading newly added field as null 2
Only run if check box is checked 5
Deleting Selected records from a table via Visual Basic 6
Error 3211 - tbl already in use 1

Back
Top