essaytee
Need a good one-liner.
- Local time
- Tomorrow, 04:04
- Joined
- Oct 20, 2008
- Messages
- 544
This problem has me stumped and now seeking assistance, I'm hoping someone may have come across this previously.
Microsoft Access 2010, 32 bit, Windows 7.
All office computers are configured the same way. Users reported errors of my main application, and they all originated from the same computer. Attempting to duplicate the error from other computers proved fruitless; there were no errors, all were working as intended.
I've narrowed down the problem to the following. At this particular computer the functions Count(), Sum(), Avg() and Max() do not display any results when used as expressions in Control Sources of Text Boxes on forms. There are probably other functions that don't work either; these are the ones I checked. The functions Date() and Now() do work.
The underlying table of the form has five records. When running the form the text boxes are empty. Attempting to data entry into the text boxes, the status bar correctly advises the control source is an expression. No error messages are generated either when creating the expression at design time or running the form.
When running this same database from another computer in the office everything works as intended. The functions produce and display the correct results.
I've checked references, trust centre settings and version of Access (14.0.7128.5000) and all are the same for all the office computers.
Does anyone have any clues?
Steve.
Microsoft Access 2010, 32 bit, Windows 7.
All office computers are configured the same way. Users reported errors of my main application, and they all originated from the same computer. Attempting to duplicate the error from other computers proved fruitless; there were no errors, all were working as intended.
I've narrowed down the problem to the following. At this particular computer the functions Count(), Sum(), Avg() and Max() do not display any results when used as expressions in Control Sources of Text Boxes on forms. There are probably other functions that don't work either; these are the ones I checked. The functions Date() and Now() do work.
The underlying table of the form has five records. When running the form the text boxes are empty. Attempting to data entry into the text boxes, the status bar correctly advises the control source is an expression. No error messages are generated either when creating the expression at design time or running the form.
When running this same database from another computer in the office everything works as intended. The functions produce and display the correct results.
I've checked references, trust centre settings and version of Access (14.0.7128.5000) and all are the same for all the office computers.
Does anyone have any clues?
Steve.
