Sum totals on subforms disappear

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.
donhannamAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
Bill RossCommented:
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
 
donhannamAuthor Commented:
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
 
Bill RossCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
dartreeCommented:
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
 
donhannamAuthor Commented:
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

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
donhannamAuthor Commented:
Just closing this question - no solution found
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.