2 Replies - 997 Views - Last Post: 03 November 2012 - 04:20 PM Rate Topic: -----

#1 Boeiend101  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 03-November 12

Error 424: object required

Posted 03 November 2012 - 08:20 AM

I'm quite new to coding and especially to VB6.

The problem is, I'm writing a little program and I get the 424 error.
Private Sub cmdKlikuur_Click()
DoCmd.RunSQL "UPDATE Leerlingen SET KlikurenDezeWeek='txtKlikurendezeweek +1' WHERE Leerlingnummer = txtLeerlingnummer"
End Sub


I have no idea what to do, and I already searched other topics but they didn't help me.
If you need more info to help me, feel free to ask it.

Thanks in advance.

Is This A Good Question/Topic? 0
  • +

Replies To: Error 424: object required

#2 tlhIn`toq  Icon User is offline

  • Please show what you have already tried when asking a question.
  • member icon

Reputation: 5676
  • View blog
  • Posts: 12,194
  • Joined: 02-June 10

Re: Error 424: object required

Posted 03 November 2012 - 09:29 AM

Start by jumping off the ancient VB6 language. Its a legacy language used to support legacy applications. Do yourself a favor and at least come up to VB.net
Was This Post Helpful? 0
  • +
  • -

#3 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: Error 424: object required

Posted 03 November 2012 - 04:20 PM

This is VBA, not VB6. DoCmd is part of the Access object. If you're using VB6 and attempting to use DoCmd, it won't work. No such object, as the error says.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1