Access can easiily handle 48,000 rows. All I know is Access, and I've had databases with tables with over one million rows. Depending on your queries and forms, the speed my be slow, but it hasn't mattered for any of my clients.
Using a combo box allows me to type in an item, and have Access Auto-fil the rest of the name as I type. I have several items that are helpful to group together and view without having to go back to a drop down combo box.
Problem: I want my list box to shift and make the first visible entry...
I have a database created by someone else. What is the easiest way to document where the tables, queries, forms and reports go to and where they come from? Is there an add-in out there that will create a report in flowchart format? i have not found the documenter under the tools/analyzer menu...
I want to create a VBA procedure that will record changes made to the data, like an archive. I would like to have it record the table and field name in addition to the old and new data when any change is made to the data. In this way, I can keep all changes in one "archive table" and...
I want to automate the ability to find the missing dates in a set of data.
Currently, I can run a query that finds the min and max date of the data set. From those min and max dates, I type that into a VBA code that populates a table with all the dates between those min and max dates. Then I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.