Category: Random Tidbits

Live vs Test? How do you tell?

During my day, I will often switch between development, test, data admin duties, running custom reports and more. This also means I often switch between a backend with test data and a live backend. Now since the test data is a copy of the live

Posted in Misc., Random Tidbits

Tip of the Week #3: PathCompact

Wow, December was a very busy month for me, so I never got around to posting more than 1 tip of the week in December, so seems I am a bit behind. Anyways the inspiration and code for this tip

Posted in Random Tidbits, Tip Of The Week

Center Control on form in design view

Today I had a control that I wanted to place right at the center of my popup form. I could get it roughly right in design mode, but just not 100% there. Thankfully Access vba can be used to write

Posted in Random Tidbits

Track Changes, Compare text and highlight difference, Text Diff

Intro A great deal of my database works revolves around tracking text, whether it be requirement specifications, comments, test procedures or hazard logs the requirement is always there for being able to track changes. Who created the piece of text,

Posted in Misc., Random Tidbits

How To: Switch Access frontend by VBA without leaving Access

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

Posted in Misc., Random Tidbits

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

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

Posted in Random Tidbits

Find out which report or form a control belongs to

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

Posted in Random Tidbits