Steve R.
Retired
- Local time
- Today, 18:41
- Joined
- Jul 5, 2006
- Messages
- 4,705
We recently "upgraded" from ACCESS2000 to ACCESS2007. The good news is that I have not had any real problems. The bad news is having to do some tweaks. Currently, I have a form that uses a subform in datasheet view. The subform uses conditional formatting to highlight incomplete projects. It is based on a filter.
Under ACCESS2000 the subform was slow to display. I have some dlookup statements. Under ACCESS2007 the subform basically "freezes". The actual symptom is that one of the fields flickers. After you move the mouse cursor (doesn't really matter where) the flickering stops and the data displays itself. (Could this imply that the program for whatever reason is trying to communicate with the mouse?).
When I open the subform directly, I don't have the slow/flickering problem either.
I did one test where I removed the conditional formatting, and that resolved the problem of the subform datasheet "freezing".
So far, I have "rebuilt" the forms entirely within ACCSESS 2007, but that has not solve the problem. I am currently experimenting with "repaint" and "requery". So far that has not yet worked. I may be pursuing a "wrong" course of action here.
I am also contemplating doing a stand alone query and referencing the subform to get the data from the query to see if that solves the problem. Which actually leads me to a side question that raises a "bigger" programing issue. Is it better (faster/efficient) for a subform to get its data from a stand alone query or by using a filter? Currently, the subform is based on a filter.
The ultimate "solution" of course would be to remove the conditional formatting if there is no other solution. Any additional advice?
Under ACCESS2000 the subform was slow to display. I have some dlookup statements. Under ACCESS2007 the subform basically "freezes". The actual symptom is that one of the fields flickers. After you move the mouse cursor (doesn't really matter where) the flickering stops and the data displays itself. (Could this imply that the program for whatever reason is trying to communicate with the mouse?).
When I open the subform directly, I don't have the slow/flickering problem either.
I did one test where I removed the conditional formatting, and that resolved the problem of the subform datasheet "freezing".
So far, I have "rebuilt" the forms entirely within ACCSESS 2007, but that has not solve the problem. I am currently experimenting with "repaint" and "requery". So far that has not yet worked. I may be pursuing a "wrong" course of action here.
I am also contemplating doing a stand alone query and referencing the subform to get the data from the query to see if that solves the problem. Which actually leads me to a side question that raises a "bigger" programing issue. Is it better (faster/efficient) for a subform to get its data from a stand alone query or by using a filter? Currently, the subform is based on a filter.
The ultimate "solution" of course would be to remove the conditional formatting if there is no other solution. Any additional advice?