Totals Are not working

I am Using access 2010 which we just recently converted from 2003.
All of our formulas and totals worked. Some one just noticed that they no
longer work.

Many of our forms we use formulas are placed in a form header  to gather
totals from the details below. For example   =Sum([estv]) gathers the total
of the estv field.

As I look further anything placed in the header does not work. I really need
help on this
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you opening the forms in standard view, or in the new "Layout" view? Code doesn't run in Layout view.
BillxxxxAuthor Commented:
I am opening it in Form View and all the text boxes that should show totals
Is blank. When I open it in design view you can see the formulas. I tried it in layout view
and it's the same. I am wondering if maybe I am missing a reference. I have been using
access for 20 years and this is very strange.
Jeffrey CoachmanMIS LiasonCommented:
To be sure, ...note that most people put the summary controls in the "form footer". give that a try.

I have had this happen to me as well.
For fun, try simply deleting the controls, ...then recreating them from scratch.

Also, did you "Convert" the db.
Are you simply running the .mdb under Access 2010, or did you save the .mdb as a .accdb?

The safest Scott always mentions is to create a brand new access 2010 database (.accdb) and import all the objects fornm the .mdb file.

Beyond that, ...I am sure Scott can get you sorted...

Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You must also make sure the database is in a Trusted Location. You set this directly in Access using the Trust Center section in the Options dialog.
BillxxxxAuthor Commented:
I have put new controls in both the footer and header and still nothing
It is and mdb.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Did you try the Trusted Location thing? A database that is not in a Trusted Location won't run code.
BillxxxxAuthor Commented:
It must be in a trusted location because it's running code that's
not a problem. In this data base I have hundreds of pages if not thousand
running code every day.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Try compiling the database. Make a copy, then open the VBA Editor and click Debug - Compile. Fix any errors that show up, and continue doing that until the menu item is disabled.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
It must be in a trusted location
Make sure - it'll take a few seconds to insure you're in a Trusted Location, and it can save you a lot of headaches.
BillxxxxAuthor Commented:
I compiled and nothing. I went to my lap top and opened the same file
and everything works. There may be something wrong with access any thoughts?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Could be. Make sure the machine is fully updated in regard to Office and Windows.

And make sure the database is in a Trusted Location (as before).
EirmanChief Operations ManagerCommented:
If repairing, compiling (instructions attached) etc. fails,
recreate the database by importing all db objects (queries, forms, reports, macros, modules etc.)
into a new, completely blank database.

I've done it many times and it only takes a few minutes when you are familiar with the procedure.

Tips that may help to avoid future corruption .....
Luke ChungPresidentCommented:
We experienced this problem last week and have been unable to determine the actual cause. On a machine that was running the program successfully for many months, all of a sudden, the totals in subforms wouldn't work so references to the total failed.

We narrowed it down to a simple test where just viewing a local table in a datasheet wouldn't show values in the totals row. Compact/repairing, etc. didn't matter because the database (front-end) worked fine on other machines.

We still can't figure out why it failed. Fortunately, it was in a VM, so we were able to rollback the VM and the database worked again. Very interested in knowing what could have caused this. As far as we know, nothing new was installed on the VM recently, so we're at a loss as to the cause.

Experts Exchange Solution brought to you by

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
BillxxxxAuthor Commented:
Thanks for everyone's help and time.  I did a repair of office 2010
and it fixed the problem. I would like to know what happened but
guess there are things you'll never know.

Once again thanks

BillxxxxAuthor Commented:
I would like to resubmit the question I first asked about a year ago.
(Totals in sub forms stop working along with any reference to them).

In return I received a fair amount of questions asking me to check this
and try that. All of which I did without any effect. The only thing that actually
worked was doing a complete repair of Office.  This did corrected the issue every
time. However, it does not give me any information as to what actually
needed to be fixed or repaired.

The problem seems to surface about once a month. Does anyone have an idea
as to how we can track this down?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
It would be very difficult to determine the exact cause of your failing Office installation. It could be anything - a hard disc going bad, failing memory, network issues, problems with your motherboard, etc etc.

A good place to start is to review the Event Log when you notice the trouble starting. Many times you will get a good view of what is happening, or at least some hints.

You might also examine your environment to insure everything there is up to par. For example, if you're running this across a network you must be sure that your network is healthy and robust, and that you're running Access in the correct environment (no wireless or WAN, local physical networks only).

If you think this is network related, you can always use something like WireShark to monitor your networks. Those types of programs can capture massive amounts of data, of course, so often you need to have a very good understanding of what you're looking at to be able to glean any information from that data. The Network Experts here on EE would probably be able to help you sort that out most efficiently (not us Access guys :) ).
BillxxxxAuthor Commented:
We are using terminal services with about 12 users and since I do not have
a time when office fails it makes it very difficult to review the event logs and
get useful information.  I guess we will have to monitor it more closely and
try and get the time narrowed down.

If and when we figure this out I will get back to everyone.


Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
In your TS environment:

Does each user have their own copy of the FE that is run in their "local" RDS desktop?

Is the Backend installed on the same RDS server? Many RDS admins refuse to do this, but it is by far the best way to run an Access application in an RDS environment.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.