Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
dSumRecordset won't trigger and returning #Name? error
OK, that is what I suspected . . . I did what you suggested (remove the recordset from the call and move the code to the form's module so that me.recordset is known) and IT WORKED!! Geez, this should honestly be posted on Allen Browne's page (if it's not already), I am going to use this so...- Jessica22
- Post #7
- Forum: Microsoft: Access Forms
-
dSumRecordset won't trigger and returning #Name? error
Yep! You are right, however, I only changed it to MyDsum after the #Name? error was produced on the original dsumrecordset so, unfortunately, that doesn't solve the problem. The function's code is not triggering. Here is the code fixed: Public Function MyDSum(expr As String, RcrdSet As...- Jessica22
- Post #3
- Forum: Microsoft: Access Forms
-
dSumRecordset won't trigger and returning #Name? error
thread702-1608030 I would really love to use the function provided by MajP called dSumRecordset, however, I cannot get it to work? I am using Access 2016. I put in another function with a break point on the first line to ensure vba was triggering. The function I wrote is triggering but...- Jessica22
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
