Results 1 to 9 of 9
  1. #1
    fluppe is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    48

    trouble calling methode ... Not found ?

    hello everybody,

    i'm new to Access and not experienced, so don't mind if this is too easy.



    I encountered the following problem:
    I added a VBA methode to a control element via the Events->AfterUpdate "property" in MS Access ...
    Editor opens and shows me a BLANK method that i can fill with life ...

    When I open the Form containing my element (it is a ComboBox thing ... have the german version and don't know the exact translation)
    i expect the code to be executed when i alter the Value in this box. But all I get is an error the method isn't even found.

    Why that ?

    Thanks for any hint so far

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    What does your VBA look like? Can you post your code here?

  3. #3
    fluppe is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    48
    hello again, i think i got it: The method has to be compiled and if that doesn't work, such errors can occur, right ?
    My code did indeed have a flaw which should have made compiling impossible ... so, this might be the reason.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    The act of compiling your code rewrites your code in a base language (I believe that is what it is called, my memory is vague). This is the language that the Run Time will understand. If the compiler does not understand the code you wrote, it will not translate it into the base language and it will cause a compile error. If your code will not compile and you try to run your app, you will get a Run Time error when the Run Time tries to run the code.

    Having said that, just because your code compiles, translates to the base language, does not mean you will never see a Run Time error.

  5. #5
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Dont bother compiling...Just fix the bugs that occur as you execute.

  6. #6
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by ranman256 View Post
    Dont bother compiling...Just fix the bugs that occur as you execute.
    I advise to compile your code as you write it.

  7. #7
    fluppe is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    48
    Thanks so far, but if got it right, you said that the RunTime truely tries to execute NOT EXISTING "RTM Code" in some cases and that leads the RuntimeError i got ... i was a little confused aboout that, because i'm not used to such mechanisms. I thought there should be some "Compiler Error" in some log that tells me where i messed up syntax ... but OK, there isn't.

    Greetings and thx a lot, ...

    p.s.: Where can i mark a thread as solved ?

  8. #8
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Use the "Thread Tools" above post #1

  9. #9
    fluppe is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    48
    ... fine ... Thanks once more

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

Similar Threads

  1. Calling DAO Close
    By BRZ-Ryan in forum Programming
    Replies: 2
    Last Post: 01-24-2014, 01:57 PM
  2. Calling Error
    By drunkenneo in forum Programming
    Replies: 6
    Last Post: 09-12-2013, 01:32 PM
  3. Calling and exe from code
    By drunkenneo in forum Access
    Replies: 1
    Last Post: 09-03-2013, 05:45 AM
  4. Calling previous value to add with new value
    By 2skannan in forum Programming
    Replies: 3
    Last Post: 01-23-2013, 11:33 PM
  5. calling function
    By ManvinderKaur in forum Programming
    Replies: 3
    Last Post: 07-22-2010, 10:53 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