Display Issues

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Having an issue with Access 2007 not displaying a row. We created a database
for our companies timesheets. Columns added up hour spent on various
projects each day, with a row of Total Hours at the bottom. Everything
displays correctly, except the Total Hours. If Access is minimized, then
maximized or if another program is displayed over the top then minimized the
Total Hours row displays. This is only happening on our Windows 7 64bit
computers. Vista 64bit and 32bit, and XP computers run the program with no
issues. Any thoughts on what may be causing this issue?
 
Did you ever find a resolution? We are experiencing the same problem on one
of our forms. Totals are not displayed unless Access is made inactive. (ie
we click on a different application then the totals display) Form is like
your form in that we are tracking time. Do you use the DateDiff function in
either your line items or totals?
 
I believe my issue is now resolved. One of the tables used in the query that
was the datasource on the subform had data in a field that did not match up
to data in another table for which it was related. (The data is in SQL).

I'm not sure why it worked everywhere but on Windows 7 machines though. It
appears Windows 7 may just be pickier.
 
Nancy said:
Did you ever find a resolution? We are experiencing the same problem on
one
of our forms. Totals are not displayed unless Access is made inactive.
(ie
we click on a different application then the totals display) Form is like
your form in that we are tracking time. Do you use the DateDiff function
in
either your line items or totals?
Click to expand...
 
Back
Top