Results 1 to 5 of 5
  1. #1
    Dave14867's Avatar
    Dave14867 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Location
    Upstate NY
    Posts
    376

    Get errors when trying to open form

    Hello all,



    I have started getting errors when opening a form in a database that has been working great and I haven't made changes to the form. I get errors like missing go sub in on current event. Some controls like go to last cmd button don't work, however, when I open the VB editor to look for issues, the problems go away.

    I have already compacted and repaired the database.

    Any ides?

    Thanks

    Dave

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,524
    Sometimes Access THINKS there is a break point still there. I think it's a bug in access.
    pressing F5 (continue) will make the code keep running, but nothing removes the phantom break point.

    you could try rebuilding the code section,by select all code,ctl-A, cut ,paste into a notepad,save both,
    close notepad,open notepad,copy code paste back.

    i never tried this, I just pressed F5.
    or
    A system cchange happened and there is a reference missing:
    vbe menu,tools,references.
    look for MISSING checked item.

  3. #3
    Dave14867's Avatar
    Dave14867 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Location
    Upstate NY
    Posts
    376
    ranman256,

    Thanks, I'll try that

    Dave

  4. #4
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,003
    Often a full decompile / recompile will sort this type of issue out.
    Have a read here http://www.fmsinc.com/microsoftacces.../decompile.asp
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    Dave14867's Avatar
    Dave14867 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Location
    Upstate NY
    Posts
    376
    Minty,

    Thanks, I'll give that a shot, sounds exactly like what I am seeing.

    Thanks
    Dave

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Form Errors - Help!
    By k6saunde in forum Forms
    Replies: 15
    Last Post: 02-29-2016, 06:23 PM
  2. Replies: 4
    Last Post: 08-11-2014, 01:18 PM
  3. Replies: 4
    Last Post: 06-21-2014, 05:43 AM
  4. Replies: 10
    Last Post: 10-22-2013, 07:35 AM
  5. Replies: 10
    Last Post: 07-25-2011, 12:07 PM

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