Recent Blog
-
Running SQL Stored Procedures from Access VBA
Once the backend data was migrated to SQL from an Access accdb file we created a number of Stored Procedures to dramatically increase the processing speed.
-
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.
-
Working with Text or CSV Files
Anyone who works with Text or CSV files will know this issue. The CSV file was generated by a machine or exported from a database. But it was opened and saved as a CSV file in Excel by the user to check the contents and in doing so the number value is saved as an exponential value…
-
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.
-
Export a List of Posts from Wordpress
I needed to export a list of posts from wordpress to check the category and posting status. I got code from ChatGPT and did some testing which works correctly. I deactivated the plugin and run it as required as I dont want this available to any site visitors, although the code should not allow this!.…
-
Listing all Wordpress Posts
I wanted a list of all wordpress posts in a single lists. I used the plugin “List category posts” by Fernando Briano which worked as described but I had to add each category. If new categories were added it involved updating the page. I posed the problem to ChatGPT and through a number of iterations arrived…
-
Software Listing
I wanted a directory listing of access or vba add-ons for my website to share details of items I had used or reviewed. I checked some WordPress plugins but many didn’t give the details I wanted and those that had the items were classed as premium. I asked ChatGPT to write a plugin. After a…
-
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.
-
Think Recycled
A shout out for my recycled hardware supplier Refurbed.ie 👍.Over the last number of years I have purchased and configured multiple laptops either for clients or staff. I have always used refurbed.ie , as the name suggests you get a refurbished laptop in perfect working order for a fraction of the price you would pay…
-
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…
