Results 1 to 4 of 4
  1. #1
    ksor's Avatar
    ksor is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    Feb 2017
    Posts
    126

    Starting getting errors when opening a form in Access 2010 ????

    I'm gettin an error when I starts a form - I'm running DANISH version, so the err-message will not mean anything to you I think - but anyway here it is:

    Denne fejl forekommer, når en hændelse ikke er blevet kørt, fordi placeringen af hændelsens logik ikke kan evalueres. Hvis egenskaben OnOpen for en formular f.eks. er angivet til =[Felt], forekommer denne fejl, fordi det forventes, at det skal være navnet på en makro eller en hændelse, der skal køres, når hændelsen opstår.


    I have located what sub form is causing the problem and I open up this form and JUST looking at teh SQL-code in the datasource - not changing anything at all - then save the form and try run again - now it all works again !!!!!!!!!!!

    Even if I shut down the problematic form and starts it again it works !!!



    But if I shut down Access and starts again the error is the again !!!!!!

    I HAVE done compress and correction of the DB !

    What is wrong and how to fix it ?

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Your error message (translated by a site found with google) reads:
    This error occurs when an event has not been run because the location of event logic can not be evaluated. If the property OnOpen for a form eg. Is set to = [Field], this error occurs because it is expected that it should be the name of a macro or event to run when the event occurs.
    Have you checked all main form and sub form event properties are set correctly. If they are all correctly set please post a copy of the db for us to look at.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    ksor's Avatar
    ksor is offline Competent Performer
    Windows 10 Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    126
    Quote Originally Posted by Bob Fitz View Post
    Your error message (translated by a site found with google) reads:Have you checked all main form and sub form event properties are set correctly. If they are all correctly set please post a copy of the db for us to look at.
    I tend to say YES to that - but as I wrote it all works again JUST BY VIEWING the SQL-code (SHIFT F2) for the datasource in the problematic subform !

    But the RE-start of Access set it all back to this strange error-state again.

    The DB is way too big to copy to you.

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    The DB is way too big to copy to you.
    How about one with just the troublesome forms and a few dummy records that illustrates the problem. Compact and then zip it.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Replies: 3
    Last Post: 12-07-2015, 11:29 AM
  2. Replies: 3
    Last Post: 08-25-2015, 04:40 PM
  3. Access 2010 form opening as read only
    By tracer in forum Forms
    Replies: 5
    Last Post: 02-10-2012, 03:52 PM
  4. Access 2010 first macro - errors
    By DLParker in forum Forms
    Replies: 9
    Last Post: 10-16-2011, 04:17 PM
  5. Starting Access 2010 not solved
    By mrkaye in forum Access
    Replies: 11
    Last Post: 10-12-2011, 02:50 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