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

Lester Miazga 21 Reputation points
2023-02-10T21:21:25.9033333+00:00

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.

Screenshot 2023-02-10 112629

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

Windows for business Windows Client for IT Pros Devices and deployment Set up, install, or upgrade
Microsoft 365 and Office Development Other
Microsoft 365 and Office Access Development
Microsoft 365 and Office Install, redeem, activate For business Windows
Microsoft 365 and Office Access For business Windows
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Limitless Technology 44,746 Reputation points
    2023-02-13T16:16:39.4066667+00:00

    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–

    0 comments No comments

  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  3. Lester Miazga 21 Reputation points
    2023-02-18T18:48:08.7033333+00:00

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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.