Category: VBA
-
Deploying Access Databases
When deploying Access databases, it’s essential to enforce best practices for both security and performance. One key strategy I follow is ensuring users only run the program from a local location, such as their personal PC or the My Documents folder, rather than directly from a shared server. The program is linked to either a…
-
Application Deployment
Application Deployment for Access or Excel Apps; When distributing apps I usually create an install program to setup the application correctly for the user. I use Inno setup which does a great job of packaging the files creating the user shortcut and ensuring they have installed the program into the correct location. When deploying these…
-
Checking the References in an Access Database
This code from microsoft learning site is useful to check your references Older version used in our MDBs. This code from the MS site checks the references and can fix broken references – the compile will only work in an mdb version
-
Benefits of using Pass-through queries
We have recently converted a database from Access to SQL and needed to increase the speed of the reports when working with a large recordset. We amended this code from the web to a pass-through which significantly increased the speed on 2 reports but reduced the speed on another – so its a case of…
-
Preserving Excel Comments Across versions
You may need to save excel comments from one excel model and load them into another file. This can be a time consuming task and this routine will eliminate if (Â big IF) you have a key column to store the comments on. In this case it was the crystal ID. You need an access database…
-
Importing Data into Access
A lot of my applications involve importing data into access from an external source, executing some transformation and applying business rules. When I first started using Access I would have written an import specification for each file, and then added queries or code to load the data and apply business rules. This approach involves a…
