Run-time Error '424'

#1

A button on a form has the ONClick Event [Event procedure]
with this code

Private Sub Toggle12_Click()
DocCmd.OpenQuery "TEST"
End Sub

Clicking the button & I get a
Run-time error '424'
Object Required
message

WinXP + Access 97
Googling Run-time error + Query didnt come up with anythin i thought was
helpful

#2

paul wrote:

Quote:

A button on a form has the ONClick Event [Event procedure]
with this code

Private Sub Toggle12_Click()
DocCmd.OpenQuery "TEST"
End Sub

Clicking the button & I get a
Run-time error '424'
Object Required
message

WinXP + Access 97
Googling Run-time error + Query didnt come up with anythin i thought
was helpful

Does TEST exist?

#3

Deano wrote:

Quote:

paul wrote:

A button on a form has the ONClick Event [Event procedure]
with this code

Private Sub Toggle12_Click()
DocCmd.OpenQuery "TEST"
End Sub

Clicking the button & I get a
Run-time error '424'
Object Required
message

WinXP + Access 97
Googling Run-time error + Query didnt come up with anythin i thought
was helpful

Does TEST exist?

yes. Thought of that - I get the same error message regardless of the

query Im trying to open. Test is a very simple query (a couple of fields
from the DB with no fiddling around)

#4

"paul" <pdconetwofour_numbers_ (AT) yahoo (DOT) co.uk> wrote

Quote:

A button on a form has the ONClick Event [Event procedure]
with this code

Private Sub Toggle12_Click()
DocCmd.OpenQuery "TEST"
End Sub

Clicking the button & I get a
Run-time error '424'
Object Required
message

WinXP + Access 97
Googling Run-time error + Query didnt come up with anythin i thought was
helpful

1. Check spelling: "DocCmd" or "DoCmd"

2. Does the code for the database compile?

Fletcher

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Run-time Error '424'

comp.databases.ms-access comp.databases.ms-access

Run-time Error '424' - 08-05-2003 , 04:08 PM

Re: Run-time Error '424' - 08-05-2003 , 04:14 PM

Re: Run-time Error '424' - 08-05-2003 , 04:20 PM

Re: Run-time Error '424' - 08-05-2003 , 05:42 PM