Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2007
    Posts
    3

    Unanswered: ADP - Object or class does not support the set of events

    I'm editing an existing Access 2000 Application. The subform I working with has a datasource of a SQL stored proc, I added a field to the stored proc. I edit the subform to add the field and save it. When I open the subform get the following error "Object or class does not support the set of events" and the unaltered existing line


    [myform].Form.AllowAdditions = New

    where New is a Boolean

    what is it about editing the subform that suddenly makes this code break?

    Thanks in advance

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    New is a reserved word - try changing it to something else and see if that helps
    George
    Home | Blog

  3. #3
    Join Date
    Aug 2007
    Posts
    3
    Quote Originally Posted by georgev
    New is a reserved word - try changing it to something else and see if that helps

    Sorry I was writing from memory... the actual code is as follows

    bNew = IsNull([DatePosted])
    [Deposit Detail SF].Form.AllowAdditions = bNew


    Keep in mind this code has been working for years. I've tested and if all i do is open the subform, add a comment to it and save it, this error pops. its like the subform gets broken and the script of the parent can no longer set this property.

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Have you debugged the value of bNew at the time of execution? Access sometimes throws what seem like arbitrary errors that don't align with the actual issue.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Aug 2007
    Posts
    3
    Quote Originally Posted by Teddy
    Have you debugged the value of bNew at the time of execution? Access sometimes throws what seem like arbitrary errors that don't align with the actual issue.

    Yes, its value is True or False...correctly Dependant on the scenario.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •