Category: VBA
-
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. Once a connection was created we then assigned the bluetooth to a com port and used the following code to output the receipt. Sewoo Print Code Link to Sewoo Printer Configurations…
-
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
-
Using Passthrough query in Access
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 which significantly increased the speed on 2 reports but reduced the speed on another – so its a case of testing to get…
-
Preserving Excel Comments Across versions
You may need to save comment 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 to…
-
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…
