I have an application that uses an access database with several large tables. I want to write a program that will dynamically build the database for new users instead of having to provide them with a copy of a blank database.
I prefer not to have to manually type up the code to create each of the tables with the correct field names, type, and sizes. I figure that I could load the table and go through the fields collection and append each field to a build a create table command.
But is there an automated way that would do this for me from an existing table structure.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple. The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…