Access , Excel VBA Samples and Wordpress Plugin Posts
-
Formatting CSV files in Excel
As a csv file is a text delimited file it doesn’t contain any formatting. The process of formatting csv files in Excel is a repetitive process which is an ideal candidate for a macro. You can store macros you need to run on different excel workbooks in your personal workbook. This is a hidden workbook…
-
Wordpress Site Migration
I was testing a number of backup and restore options for our club website in the last few weeks. Many of the plugin will do an excellent job but almost all require some pro features (Understandable but we don’t have the budget ) I came across the plugin Migrate Guru which directly clones the site…
-
User registration using VBA and WordPress
wanted a simple method to allow user registration in order to advise of program updates. I created this plugin in WordPress to make a registration table and I have detailed below the VBA
-
Top 5 Uses for NFC tags
NFC (Near Field Communication) tags are versatile and can be used for a variety of purposes in personal, business, and industrial settings. I have listed below my Top 5 Uses for NFC Tags. 1. Contactless Business Cards 2. Wi-Fi Sharing 3. Digital Marketing and Information 4. Inventory Management 5. Smart Home Automation Bonus Ideas: NFC…
-
Trusted Locations with Access
If you are using the full version of Access you can set the trusted locations as required in the trust center. This option is not available in the runtime version.
-
DSNless Connection in VBA to SQL Server Tables
When we released updated access database which were linked to an sql source the deployment requires re-connection to the client environment ; We would need to ensure the client PC had the DSN setup and tested, to simplify the process we call this DSN-less function. The program tests the connection when opening and advises the…
-
SQL Update Scripts
In the absence of a UI for a given table, updates to records on that table need to be executed as SQL Update Scripts. This process would usually involve some development resource to create the script under the instruction of a given user. The obvious solution would be to add a UI to allow the…
-
We’ve got a new look!
We’re excited to share our redesigned logo for Anything Access. The team behind it did an amazing job, and we’re really happy with how it turned out. The new design feels fresh, modern, and truly reflects who we are.
-
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.
