Results 1 to 3 of 3

Thread: Strange Error

  1. #1
    Join Date
    Oct 2005

    Unanswered: Strange Error

    The error that I am getting is:

    Runtime Error '40036':
    Method 'Item' of object 'Forms' failed.

    Which is being thrown by this line:

    Forms("Equipment_SignOut_2").edt_EmpID = "204536"

    Basically, this error is thrown whenever I try to access a form other than the current one.

    The strange part is that this code was working previously, and I cannot think of anything that I have done to cause this error. Furthermore, it is only happening in this one form -- other forms in the same database are working fine.
    Net-searches indicate that this error is somewhat random, and some people have gotten rid of it simply by restarting Access... I am not so lucky.

    Any help is most appreciated.

    Pete Lloyd

  2. #2
    Join Date
    Mar 2005
    Sounds like corruption in the VBA project. Try decompiling:

    Alternatively try importing everything into a new database.

    Wayne Phillips

  3. #3
    Join Date
    Oct 2005

    Thanks Wayne, decompiling worked like a charm


Posting Permissions

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