Hai
I have a problem with my code 2 delete all the records in access table
i have used this code

Private Sub mnudel_Click()
DoCmd.SetWarnings False
DoCmd.RunSql "DELETE * FROM Register"
DoCmd.SetWarnings True
End Sub

But by executing this i get a
runtime error '424'
Object required
plz give a suggetion 2 cum out from this plz..

hi there.. is docmd correct registered?? I mean do you have it somewhere dimmed??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

What do u mean by dimmed?
I'm new 2 Vb so plz clarify my doubt in a clear view

well.. with line is throwing the error???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

If this code is in VB, and you are trying to talk to an Access DB, you need to establish a proper connection to the Access DB, and DoCmd will not be available to you. (DoCmd is specifically an Access command; you need to be running code that is contained in Access, with Access active as the host for that code for that statement to run. This statement is one of the ways that Access talks to itself. "Others" cannot talk to Access this way.)