Solved

Sum totals on subforms disappear

Posted on 2014-02-10
6
233 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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

708 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now