Access , Excel VBA Samples and Wordpress Plugin Posts
-
Access UI Design
When working on multiple tables to create simple Access UI design forms the process to create each UI can become tiresome. To simplify the process I now take all the fields from the table and place them on the form in the desired position and then call the following code on open event. Access UI…
-
Clean QR Code Generator
I was using Canva to make a QR code on my poster but it was a redirect type. I asked Chat GPT for a solution :). While ChatGPT gave the options below the only one which was static was chrome but it has the dinosaur embedded. I did find this conversation on Reddit , which…
-
Importing Oracles ALL_TAB_COLUMNS into Access
If you’re working with Oracle databases and need to recreate tables in Microsoft Access for proof of concept or other tasks, Oracles ALL_TAB_COLUMNS view is an invaluable resource. This table provides detailed metadata about all tables, fields, and data types in a given Oracle instance. Here’s how I used it to streamline my process: Step…
-
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…
-
Pension Calculator
As an accountant I get asked a lot about how long a persons pension pot will last or when I think they can retire. The honest answer is it depends ! What your current outgoings are , do you have debt , what age you are etc etc. I prepared this simple Excel model to…
-
Consolidate multiple excel sheets
This is a very useful macro to add the contents of several excel sheets onto a single sheet. Excel VBA Macro
-
Editing a NK2 files
This is so random that I had to include this here Every time that you type an email address or name in the message window of MS-Outlook, it automatically offer you a list of users and email address that you can choose. This feature is known as ‘AutoComplete’ and Outlook automatically build this emails list…
-
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…
