Results 1 to 3 of 3

Thread: Strange Error

  1. #1
    Join Date
    Oct 2005
    Posts
    4

    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.

    Thanks,
    Pete Lloyd

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

    http://www.granite.ab.ca/access/decompile.htm

    Alternatively try importing everything into a new database.

    Wayne Phillips
    http://www.everythingaccess.com

  3. #3
    Join Date
    Oct 2005
    Posts
    4


    Thanks Wayne, decompiling worked like a charm

    -Pete

Posting Permissions

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