Author: TheSmileyCoder

Introduction I had a friend ask me today: I need your help in the following situation: I am creating an application with multiple microsoft access files that act as front-end and a sql server database as back-end, I need to …

How To: Switch Access frontend by VBA without leaving Access Read More »

I got a question posted on my blog a while back, by¬†Terrence Kuchel¬†on how I had made my VBE (Visual Basic Editor) look the way it does. The changes I have made involves setting the background color, and setting various …

Customizing the Access or Office VBE – Setting font colors and background Read More »

Today I had an issue, trying to discover which report/form a given control belongs to. At first I thought it would be so simple. Just use the .Parent property of the control. However I soon realised that the .Parent does …

Find out which report or form a control belongs to Read More »

Introduction This blog post is about how to handle record updates so that the treeview is always showing accurate up-to date information. I have also included a few helper functions which will make coding with the treeview a bit easier. …

Treeview in MS Access Part 3 – Refresh treeview on record update Read More »

Introduction Hi and welcome back to my site for part 2 of my series on using the Treeview in MS Access. This part is about how we can take action based on mouse clicks in the treeview. For now we …

Treeview in MS Access Part 2: Navigation by treeview Read More »

The Treeview is a great free part of the Microsoft Common Control Library that lets you create your own Treeview and tie your own data and events into the Treeview. It can present a lot of information in a limited …

Treeviews in Access Tutorial – Part 1 Basic – Loading information into Treeview Read More »

So after my original website (umbraco based) had been going stale for over a year, I decided it was time for some drastic action, and wiped the entire page, and installed Joomla. After playing around with it for a few …

Welcome to my new and third attempt at a blog. Read More »