I have separate databases (all very similar in structure but disimilar data and all used by a different user). However I have to extract data from all five databases.
So my idea which I 've worked on a bit is :
I've run a make table query in each of the separate databases thereby creating a specific table in each of the databases.
I have then gone and created a separate program in Access and written a macro which imports all the separate five tables into this one database. And then run a query to join up all five table into one. So far so good.
I now have a separate program that can "stitch" together five tables into one but I am reliant that each separate user run their query to create the initial table.
Now I was wondering whether I could run a macro of some sort or possibly write some VBA code where I could initiate the creation of the initial tables from the New database and therefore not rely on the individual user to do so?
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
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…