Results 1 to 5 of 5
  1. #1
    Kemo is offline Novice
    Windows XP Access 2003
    Join Date
    May 2012
    Posts
    3

    Can't run a function?

    Hi all,



    I followed tutorial to make function in access database (2003), the tutorial in attachments (pages 11,12,13). But can't run the function myLookUp(), i got the next popup window:

    Click image for larger version. 

Name:	mcrPop.jpg 
Views:	8 
Size:	113.0 KB 
ID:	7717


    How i can run this function?


    Note: the database (with function code) in the attachments.
    Attached Files Attached Files

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    Typically you would call it from a query or elsewhere in code:

    http://www.baldyweb.com/Function.htm

    In other words, you'd call it from wherever you need its result.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Kemo is offline Novice
    Windows XP Access 2003
    Join Date
    May 2012
    Posts
    3
    Pbaldy, thank much for ur post. Can u explain the pop window come out when run function?
    typically I can run subroutine method, why exact function can't do?
    In explanation of the tutorial (attached text) said you can do (run).. why actually can't do in access?

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    How exactly are you trying to run it?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Kemo is offline Novice
    Windows XP Access 2003
    Join Date
    May 2012
    Posts
    3
    Quote Originally Posted by pbaldy View Post
    How exactly are you trying to run it?
    Yes, I try to run it

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

Similar Threads

  1. IIf function
    By seb in forum Queries
    Replies: 4
    Last Post: 11-15-2010, 05:28 PM
  2. Now() function
    By shexe in forum Queries
    Replies: 1
    Last Post: 11-11-2010, 09:59 AM
  3. Max function???
    By kaite07 in forum Queries
    Replies: 1
    Last Post: 11-10-2010, 05:20 PM
  4. Help with AVG function
    By techexpressinc in forum Reports
    Replies: 1
    Last Post: 03-23-2010, 07:47 AM
  5. Want function to get current function name
    By Davis DeBard in forum Programming
    Replies: 2
    Last Post: 08-13-2009, 05:02 AM

Tags for this Thread

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