Avatar of Bill Feder
Bill Feder
 asked on

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
Microsoft AccessVBA

Avatar of undefined
Last Comment
Scott McDaniel (EE MVE )

8/22/2022 - Mon
SOLUTION
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Bill Feder

ASKER
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.
SOLUTION
Jeffrey Coachman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Bill Feder

ASKER
I have put new controls in both the footer and header and still nothing
It is and mdb.
SOLUTION
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Bill Feder

ASKER
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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
SOLUTION
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Bill Feder

ASKER
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?
SOLUTION
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Eirman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Luke Chung

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Bill Feder

ASKER
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

Bill
Bill Feder

ASKER
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?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Scott McDaniel (EE MVE )

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 :) ).
Bill Feder

ASKER
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.

Thanks

Bill
Scott McDaniel (EE MVE )

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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes