Category: VBA
-
Automating Test Data Loading
Part of the process of creating reports and reviewing the program design involves loading of test data. For the Club Lotto application I wrote the function below to load test ticket sales into the system.
-
Track Your Application Usage
When you release either commercial or free software its useful to be able to track your application usage by your customers to advise of updates or changes.
-
Printing Receipts to a Sewoo from VBA
For a recent project we needed to print receipts on a mobile sewoo printer. First we connected the printer via bluetooth to the laptop.
-
Offline Club Lotto Automation
Running a club lotto has always been a great way to raise funds, but managing it effectively can be challenging. To streamline this process, we recently introduced Clubforce, a dedicated software solution that allows players to participate in our club lotto online. With Clubforce, players can conveniently choose their numbers, pay through the platform, and…
-
Access Startup on Distributed Applications
When your distributed applications are sent to a wide audience the application may fail to start if the user has not trusted the application and allowed VBA. If your application is programmed to start a form that contains VBA the form may display but all the options will be disabled. To save on support time…
-
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…
-
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…
