Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Sum totals on subforms disappear

Posted on 2014-02-10
6
Medium Priority
?
322 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

577 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