Solved

Sum totals on subforms disappear

Posted on 2014-02-10
6
244 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

777 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