VBA, Runtime error 424: Object required

Runtime error 424: Object required

Author	Message
Rhett G. Mille #1 / 4	Runtime error 424: Object required Is anybody familiar with this error. MS online support only makes referance to an EXCEL macro calling VBA code. I get it in an access97 module that compiles fine but won't get past the first If statement without this error message.
Fri, 22 Jun 2001 03:00:00 GMT

Dev Ashis #2 / 4	Runtime error 424: Object required Hi Rhett, What does your code look like? -- Dev :Is anybody familiar with this error. MS online support only makes :referance to an EXCEL macro calling VBA code. :I get it in an access97 module that compiles fine but won't get past the :first If statement without this error message. :
Fri, 22 Jun 2001 03:00:00 GMT

Keri Hardwic #3 / 4	Runtime error 424: Object required Quote: > Is anybody familiar with this error. MS online support only makes > referance to an EXCEL macro calling VBA code. > I get it in an access97 module that compiles fine but won't get past the > first If statement without this error message. Darn near every time I've gotten this error it's because I forgot "Set" and done this: rst = currentdb.openrecordset... instead of this set rst = currentdb.openrecordset... Maybe you've missed a "set" in your code somewhere? Keri Hardwick
Sat, 23 Jun 2001 03:00:00 GMT

Jonathan Wienk #4 / 4	Runtime error 424: Object required You may not have declared one of the object variables as an object. You can get this error with the following code: Sub Junk() Dim X as Long Y.Height = 250 ... Since VB will implicitly declare Y as a Variant, treating it as an object (by trying to access a non-existent property) causes error 454. Quote: >Is anybody familiar with this error. MS online support only makes >referance to an EXCEL macro calling VBA code. >I get it in an access97 module that compiles fine but won't get past the >first If statement without this error message.
Mon, 25 Jun 2001 03:00:00 GMT

Page 1 of 1

[ 4 post ]