M
morgan
Hello guys
learning new things on access I keep improving my db, that is my family bank
account. I’ll briefly explain how it is.
In the main form there is a single record of my table, a sub form with 3
pages of graphs and several buttons to open forms of specific categories
(car, children, house and so on). Everything works on queries based on the
selected year. I had all this structure redundant for every year. To optimize
and shrink the db, I changed all the queries in order to pass them the
desired year from a list box. Now the annoying problem is that it takes a
couple of seconds to mouse from a record to another one scrolling the mouse
wheel while the change was very quick before. The table contains around 1000
records over 2 year. What’s happened? This kind of query approach can slow
down my db?
I hope to have been clear enough...still learning english too![Smile :) :)](/styles/default/custom/smilies/smile.gif)
Ciao
learning new things on access I keep improving my db, that is my family bank
account. I’ll briefly explain how it is.
In the main form there is a single record of my table, a sub form with 3
pages of graphs and several buttons to open forms of specific categories
(car, children, house and so on). Everything works on queries based on the
selected year. I had all this structure redundant for every year. To optimize
and shrink the db, I changed all the queries in order to pass them the
desired year from a list box. Now the annoying problem is that it takes a
couple of seconds to mouse from a record to another one scrolling the mouse
wheel while the change was very quick before. The table contains around 1000
records over 2 year. What’s happened? This kind of query approach can slow
down my db?
I hope to have been clear enough...still learning english too
![Smile :) :)](/styles/default/custom/smilies/smile.gif)
Ciao