October 2018

How To Add A MS Access Custom Ribbon

In this post I am going to show you how to add a customized ribbon to you Access database so it looks like a real desktop application. In my experience this used to be done with a main switchboard. You would control the user’s navigation through buttons and object frames on a form. You had […]

Continue Reading

How To Determine If A User Clicked The Cancel Button On VBA Input Box

In this post I am going to address the question: “How can I determine if a user clicked the cancel button on a VBA Input Box” I only need to check the length of the InputBox response. If the “Cancel” button was clicked, the variable containing the value of the InputBox will be zero. In […]

Continue Reading

Video: Access report parameter with date range

This video is a result of a question I received regarding how to give a static report a date range. So I created a parameter form allowing the user to choose start and end dates for the report. I also changed the report’s recordsource to reflect what was chosen in the parameter form. Take a […]

Continue Reading

Use This Tool To Find Your Website Rank In A Google Search

I wanted to find out where I ranked on the Google search engine for a certain keyword. I couldn’t find anything that did the job, so I designed one myself. This tool is off the VBA track because it uses PHP. It’s under development, and I’ll probably finish it off but it does for me […]

Continue Reading