I actually have a tiny amount of data, I think my who db is 14mb. but my backend is in SQL Server and to long to explain what the setup is or why.
Anyway I have in my db a "Transactions" tbl/qry/frm/rpt. which has all of the financial transactions for the last 3 years. (just like a checkbook register)
it takes a little while to load and when doing anything in the form (sorting by category, or even scrolling) it is really slow.
I really only need the last 12 or 13 months. or actually 90% of the time only the last 6 months. (there is also another area of the db with a similar issue)
PLEASE!! I am not looking for ways to speed up my current qrys or improve my backend speed etc.
for the purpose of this post I am just trying to come up with design ideas that will allow me and the other users to normally deal with the recent data and allow the full set of data when needed.
current ideas are a separate menu item "Recent Transactions" "All Transactions" that would take you to different forms.
or just a button on the main form that would toggle between recent and all transactions.
or the button on the recent transactions form that would open a separate "All Transactions" window.
the biggest problem is that I always try to design for the "lowest common denominator" and for this I definitely need to. if its not obvious people will be using bad data and I will get calls about how the data is not right etc.
anyway, Just looking for some ideas,
thanks for reading, and thanks for any ideas/help