Category: Random Tidbits

I’ve been playing with adding a report as a subform. As far as I know, that means the report is displayed in report view. That means no format event, and there are several other events that don’t fire either. The …

Playing with Report View as a subform Read More »

Tagged with: ,

Jeff Conrad from the Access Team recently released this list of new features for Access 2016. Personally I am still on 2010, but it does look like some of the features are features the Access community has been requested for …

Whats new in Access 2016 Read More »

Prevent users from opening multiple instances of access Quite often we want to only allow the user to open the frontend file one and ONLY one time. It could be that some functionality simple doesn’t work if the frontend is …

Stop or Check multiple instances of Access on startup Read More »

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 …

Access Europe August 5th: Automate Client Distribution Read More »

Tagged with: , , , , ,

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 …

Live vs Test? How do you tell? Read More »

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 …

Tip of the Week #3: PathCompact Read More »

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 …

Center Control on form in design view Read More »

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, …

Track Changes, Compare text and highlight difference, Text Diff Read More »

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 »