admin
How To Embed A YouTube Video In Access Form
Hi everyone, This post will show you basically how to embed a YouTube video in your Access form. First you need to add a Webbrowser control to your form: You can either activate this control when the form loads, or when a command button is clicked. The code is basically the same: Private Sub btnShow_Click() […]
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 […]
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 […]
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 […]
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 […]
MS Access VBA Basics – Video 1
In this post, I’m going to attempt to update the MS Access Tutorial series you have probably seen elsewhere on this site. So in this post I will show you the VBE, Visual Basic Editor, and some basic ways to use VBA code in your application. VBA is essentially a way of extending the functionality […]
How To Calculate Date Intervals With VBA DateAdd
One of my clients ask me to design a little utility to operate like the Outlook appointment recurrence feature. This the first basic step, so I wanted to share how I did it. I have a basic form where I’ll probably be adding more variables, but the functionality basically works like this: I have an […]
How To Make A VBA Message Box OK Cancel
Ever wonder how you can create a vba message box to gather “ok” and “cancel” answers? This is useful when you want a user to provide confirmation for a delete procedure or other long running process. When you want to gather feedback from the user do something like this: Sub VBAMessageBoxOkCancel() Dim intAnswer As Integer […]
How To Make A VBA Message Box Yes No
Continuing on with our VBA message box theme, here is how to create a “VBA message box yes no” The message box can be used like a function to return a value. Here I am going to return a value to determine if the user clicked “yes” or “no”. For this I am going […]
How To Make A VBA Message Box
This is a fairly basic tool to use to see if something works or to alert the person using your application. Here is a VBA message box example: Msgbox [Message],[Type of Box],[Application Title] Here is the basic usage: msgbox “Your operation was successful!” Then you can fancy it up a bit: msgbox “Your […]