Carnafex
Registered User.
- Local time
- Today, 15:15
- Joined
- Jan 19, 2004
- Messages
- 38
Just a quick problem that I discovered with some Access 2000 vb code Im trying to write. The situation is thus:
A form lists models with their respective parts in a subform. The subform is to be filtered using some command buttons (easily done). I noticed however through testing that the filters have a speed reduction in moving through the records, which is okay, until I noticed that this happens even with a blank filter.
By this I meanby default the form has no filter applied (as in the filter and filterOn fields are completly blank). After filtering for some data, I remove the filter by calling:
And this returns it to its original unfiltered state
However, running the code above has a massive effect on the speed of the database, even when the filter is completely blank!
As far as I can tell it has something to do with the backend/frontend relationship of my database. By this I mean by calling filter = "", Im telling the database to find the backend table and DONT filter it.
If anyone has any tips to get the speed back to normal, it would be greatly appreciated.
Ta
Jason
A form lists models with their respective parts in a subform. The subform is to be filtered using some command buttons (easily done). I noticed however through testing that the filters have a speed reduction in moving through the records, which is okay, until I noticed that this happens even with a blank filter.
By this I meanby default the form has no filter applied (as in the filter and filterOn fields are completly blank). After filtering for some data, I remove the filter by calling:
Code:
Me!Subform.form.filter = ""
Me!Subform.form.filterOn = falseHowever, running the code above has a massive effect on the speed of the database, even when the filter is completely blank!
As far as I can tell it has something to do with the backend/frontend relationship of my database. By this I mean by calling filter = "", Im telling the database to find the backend table and DONT filter it.
If anyone has any tips to get the speed back to normal, it would be greatly appreciated.
Ta
Jason
