Solved

Sum totals on subforms disappear

Posted on 2014-02-10
6
250 Views
Last Modified: 2015-03-28
Hi,

I have an Access 2010 ade which normally works fine but we have instances where the Sum totals on forms are blank. This is typically totals of data in subforms displayed in footer. Control source of text box =Sum([Field1]) or I often use =Nz(Sum([Field1]),0). In some cases you can go to the form and click on field or move between tabs and they will display although erratic and seems to get worse over time. I have researched this and seems to happen occasionally and can be fixed by rebooting the PC.

In this case we have just moved to a hosted terminal services environment where it is not so easy to reboot the PC when there is an issue. There are several users using the program on the same terminal services box (separate copies of ade but using the same MSACCESS.EXE) and if one user gets the issue seems to spread. First happened in Mid Jan - we restarted terminal services server and all OK - Happened yesterday and restarted overnight and all OK now.

However this is an issue as not easy to restart terminal services server during the day as all users logged on - issue effects quite a few forms - I could write some code to put total in an unbound textbox but there are a lot of these to do and hoping for an easier solution.

I am hoping someone else has had this happen and has found out the cause of the issue.

Appreciate any help.
0
Comment
Question by:donhannam
  • 3
  • 2
6 Comments
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39849777
Hi,

If there is a null value in Field1 then the sum will be blank.

=Nz(Sum([Field1]),0) may not help.

the equation should be

=Sum(nz(Field1,0))

Give that a try.

Regards,

Bill
0
 

Author Comment

by:donhannam
ID: 39852096
Bill,

Thanks for that - I'll try and see if this makes a difference but I suspect the issue is more likely an access issue. These formulas have worked OK for a couple of years and now its happening that all totals are not displaying like this. Effects at least 15 totals. When server restarted this solves the issue.
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39852185
Very strange if they have worked for years.  Send a sample db and I'll take a look.  Has there been an upgrade in Access version?  

Regards,

Bill
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

Expert Comment

by:dartree
ID: 40533523
This happened to me too.  It's an Access issue, but what causes it I cannot find out!

I'm using the built-in feature that allows totals for Count, Sum etc. for the bottom of a datasheet.  The dropdown box still shows None, Sum, Average, Count, and even that in my case, the Sum function is selected in the dropdown box but still no Sum is shown.  In the same database, another datasheet with totals works fine!

Have Googled for hours and found nothing to help.
Why has it come back this week?  I recently updated my graphics driver for my "AMD Radeon HD 7700 Series" graphics card, maybe it has something to do with that.  I'm also using Windows 8.1 64-bit.
0
 

Accepted Solution

by:
donhannam earned 0 total points
ID: 40683265
Need to close this post - no solution found - This happened on a terminal services environment - Client restarting once a week to get around this.
0
 

Author Closing Comment

by:donhannam
ID: 40693357
Just closing this question - no solution found
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question