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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have put new controls in both the footer and header and still nothing
It is and mdb.
It is and mdb.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
not a problem. In this data base I have hundreds of pages if not thousand
running code every day.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
and everything works. There may be something wrong with access any thoughts?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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?
(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?
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 :) ).
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 :) ).
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
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
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.
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.
ASKER
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.