Category: Random Tidbits

Access Europe August 5th: Automate Client Distribution

Access Europe has a special session lined up for you this time. On August 5th we will demonstrate how to automate pushing updates out to your users. Now if you’r an access developer with multiple users, you are probably aware

Tagged with: , , , , ,

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

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

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

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,

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

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

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

Top