Access , Excel VBA Samples and Wordpress Plugin Posts
-
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 software 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…
-
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 Lottoraiser, a dedicated software solution that allows players to participate in our club lotto online. With Lottoraiser, players can conveniently choose their numbers, pay through the platform, and…
-
Dynamic Report Heading in an Access Report
When I design an access report which can be used by multiple clients I code the report headings and the data selection for the months to allow the client to change this if required. In the sample above the client financial year starts on the 1st of March. They can set the column report heading…
-
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…
