SUM calculation field does not display and/or calculate on Access subform only on certain workstations.

Question

I'm having a very peculiar problem with the form in a front-end Access database. On some computers (Windows 10 version 21H2 and 22H2), a "SUM" field on a sub-form does not display and/or calculate. What's even more odd is that this occurs on this form only when accessed from one point in the application and does not occur when accessed from a different place in the application. After encountering this, I made some changes in the code to make sure that both ways of opening the form are exactly the same (see the attached code).

Private Sub Job_ID_DblClick(Cancel As Integer)
    DoCmd.Close acForm, "JobListUnfinished"
    DoCmd.OpenForm "JobDetail", acNormal, "", "[Job.ID]=[TempVars]![JobID]", acEdit, acNormal
End Sub

The only potential problem I can think of is that my application was created and is running in 32-bit MS Access, and the problem machines are 64-bit computers with 32-bit MS Access Runtime installed on them. However, the problem doesn't occur on another 64-bit machine running Windows 10 version 1709 or Windows 7 pro with the same Runtime setup.

Attached you will find a snapshot of the subject form.

If this description seems a little erratic, it is because I frankly don't know where to start troubleshooting due to the peculiarity of symptoms.

I will be happy to provide more in-depth information if someone would know where to start looking and suggested it in this forum thread.

Private Sub Job_ID_DblClick(Cancel As Integer)
    DoCmd.Close acForm, "JobListUnfinished"
    DoCmd.OpenForm "JobDetail", acNormal, "", "[Job.ID]=[TempVars]![JobID]", acEdit, acNormal
End Sub

Answer 1

Hello there,

You are correct as it is very difficult for troubleshooting an issue without knowing the root cause.

This article explains how to use a type of function called an aggregate function to sum the data in a query result set. This article also briefly explains how to use other aggregate functions, such as COUNT and AVG to count or average the values in a result set. In addition, this article explains how to use the Total Row, a feature in Access that you use to sum data without having to alter the design of your queries. https://support.microsoft.com/en-us/office/sum-data-by-using-a-query-430a669b-e7fd-4c4b-b154-8c8dbbe41c8a

You can also use Microsft tools to find if there is any process that is interfering with the MS access tool.

Process Monitor is an advanced monitoring tool for Windows that shows real-time file system, Registry and process/thread activity. You can get the tool from here https://docs.microsoft.com/en-us/sysinternals/downloads/procmon

System Monitor (Sysmon) is a Windows system service and device driver that, once installed on a system, remains resident across system reboots to monitor and log system activity to the Windows event log. You can get the tool from here https://docs.microsoft.com/en-us/sysinternals/downloads/sysmon

Similar discussion here https://answers.microsoft.com/en-us/msoffice/forum/all/totals-function-no-working-in-access-query/e22e603c-f36d-47e8-83c2-54a6cecfc7c2

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer–

Answer 2

Thanks to Limitless Technologies. I will follow all the provided leads and promptly post my results.