Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    Deeber2 is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2020
    Posts
    23
    Nope! That wasn't it either.....confusing, but not limiting. I can handle not checking for Null in this situation as it can be handled elsewhere.

  2. #17
    Deeber2 is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2020
    Posts
    23
    Nope, that didn't do it either....It simply doesn't like me trying to control the object on insert/update. I can change the value check on the right side of the set statement so that's where I'll go with it.

  3. #18
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    I thought you found the issue? Is it still not working?

    How about posting your updated code.

    i would also try declaring Dim cProject As clsProject outside the click event and disambiguate your recordset as a DAO.Recordset.

    this line doesnt look right to me
    Code:
    Public Property Get Recordset() As Recordset
         Set Recordset = prsRecordset
      End Property
    Code:
    Nz(.Fields("ClientId").Value) = CLng(Me.ClientId)
    Isn't the nz on the wrong side of this?
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  4. #19
    Deeber2 is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2020
    Posts
    23
    Sorry for the late reply....I worked late into the night and took advantage of some long needed sleep!

    Yes, you are correct....that, I believe, was the issue. I actually changed the null checks (complete with replacement value) on the right side of the set statement. I also updated all my classes to set the Recordsets to DAO to eliminate ambiguity.

    Everything is now running stable and as expected.

    I got lazy when I created the classes and was going through the motions (that's what got me). Between not being explicit and not watching how I built the class, I made a couple mistakes. When I get a little time I'll upload a stripped down version of how the classes are working in the app.

    This can be considered closed as you hit the nail on the head.

    Null check on wrong side of the value assignment and not explicitly declaring the recordset.

  5. #20
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    Micron and I were happy to help.
    Good luck with your project.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Object required error 424
    By GraeagleBill in forum Programming
    Replies: 5
    Last Post: 06-22-2018, 12:00 PM
  2. Error Object required: Please help
    By lccrews in forum Programming
    Replies: 1
    Last Post: 06-14-2018, 10:59 AM
  3. Object Required Error
    By sgp667 in forum Programming
    Replies: 1
    Last Post: 11-06-2012, 03:15 AM
  4. Error: Object Required
    By compooper in forum Programming
    Replies: 6
    Last Post: 06-22-2011, 07:52 AM
  5. Object Required Error.
    By Robeen in forum Forms
    Replies: 1
    Last Post: 03-28-2011, 10:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums