Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. 04-08-2017, 09:59 AM #1
    Quanada
    Quanada is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Location
    Rahway, NJ
    Posts
    8

    Function called from form returning #Error - Please help!


    Not sure why this isn't working - I haven't programmed in years! Please ignore the double equal signs, I did that just to make it fit on the screen for this image; it was NOT originally like that... I forgot to change it to a plus in the rush to get the question out; please forgive me.
    Attached Thumbnails Attached Thumbnails error.jpg  
    Reply With Quote Reply With Quote
  2. 04-08-2017, 10:08 AM #2
    andy49's Avatar
    andy49
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    You have a line with two = signs in


    Sent from my iPhone using Tapatalk
    Reply With Quote Reply With Quote
  3. 04-08-2017, 10:09 AM #3
    andy49's Avatar
    andy49
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    And should you design the function in case all values are zero? The avg part then won't work.


    Sent from my iPhone using Tapatalk
    Reply With Quote Reply With Quote
  4. 04-08-2017, 10:20 AM #4
    Quanada
    Quanada is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Location
    Rahway, NJ
    Posts
    8
    Yes sorry I just put that there to make it fit on the screen, it wasn't like that when the error originally and continues to occur... as to the all zeroes, i will of course add that in, i would just like it to work first
    Reply With Quote Reply With Quote
  5. 04-08-2017, 10:28 AM #5
    andy49's Avatar
    andy49
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Have you debugged the two key values before the avg part


    Sent from my iPhone using Tapatalk
    Reply With Quote Reply With Quote
  6. 04-08-2017, 10:29 AM #6
    davegri's Avatar
    davegri
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,740
    Perhaps you should define the arguments in the function as Long or Decimal.
    Reply With Quote Reply With Quote
  7. 04-08-2017, 10:40 AM #7
    Quanada
    Quanada is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Location
    Rahway, NJ
    Posts
    8
    I will try decimal... Andy, I suspect that it is never getting into the Function as I have breakpoints established and they are never getting hit... In green, I have commented the call in the unbound text box used to call this function...
    Reply With Quote Reply With Quote
  8. 04-08-2017, 10:41 AM #8
    andy49's Avatar
    andy49
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Isn't there an upper limit on integers? Long may be better as dave said. Just spotted it.


    Sent from my iPhone using Tapatalk
    Reply With Quote Reply With Quote
  9. 04-08-2017, 10:48 AM #9
    Quanada
    Quanada is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Location
    Rahway, NJ
    Posts
    8
    Still the same it's not even hitting the breakpoint... I haven't done this in years...lol
    Click image for larger version.  Name: error.jpg  Views: 8  Size: 278.2 KB  ID: 28187
    Reply With Quote Reply With Quote
  10. 04-08-2017, 10:50 AM #10
    andy49's Avatar
    andy49
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Sumtotalavm as long.


    Sent from my iPhone using Tapatalk
    Reply With Quote Reply With Quote
  11. 04-08-2017, 10:53 AM #11
    Quanada
    Quanada is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Location
    Rahway, NJ
    Posts
    8
    no, that doesn't change anything... i'm pretty sure it's never getting to this code... ah well, thanks for the assistance...
    Reply With Quote Reply With Quote
  12. 04-08-2017, 10:54 AM #12
    andy49's Avatar
    andy49
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Where are you calling the function?


    Sent from my iPhone using Tapatalk
    Reply With Quote Reply With Quote
  13. 04-08-2017, 11:04 AM #13
    Quanada
    Quanada is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Location
    Rahway, NJ
    Posts
    8
    in an unbound text box, the commented section of the code is the call used
    Reply With Quote Reply With Quote
  14. 04-08-2017, 11:24 AM #14
    andy49's Avatar
    andy49
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    I'm assuming those fieldnames are part of the data source of the form?[emoji19]


    Sent from my iPhone using Tapatalk
    Reply With Quote Reply With Quote
  15. 04-08-2017, 11:51 AM #15
    Quanada
    Quanada is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Location
    Rahway, NJ
    Posts
    8
    Yes they are the exact names used in the table
    Reply With Quote Reply With Quote
Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. #error in form field returning report's value
    By patheo in forum Forms
    Replies: 7
    Last Post: 01-04-2016, 01:10 PM
  2. Create Function that can be called from VBA on any form.
    By ts_hunter in forum Programming
    Replies: 5
    Last Post: 01-24-2014, 09:05 AM
  3. DLookup function within a form control always returning same value
    By tbgh in forum Forms
    Replies: 10
    Last Post: 12-27-2013, 02:54 PM
  4. Function called via Autoexec fails when using Access 2007 Runtime
    By haggis999 in forum Access
    Replies: 3
    Last Post: 01-08-2013, 11:51 AM
  5. Function returning Error 91 (can't Figure out)
    By FrustratedAlso in forum Access
    Replies: 2
    Last Post: 04-17-2012, 02:55 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums