Tips & Tricks

So I’m in between computers at work and during the process of getting my new one setup I somehow got a virus. Well, I figured out the culprit and as it turns out it snuck in through FileZilla via their SourceForge download link. I have many opinions with this for both FileZilla, and SourceForge, and […]

Creating a linked image in Excel is relatively simple to do, and not sure how many people really know the power behind this little feature. Sure, you the description does exactly what it says it will do. Create an image linked to another image, so when the root image changes, so does the copy on […]

Have you ever noticed when you come across a link on a Google search that some of them contain a picture of the author? Ever wonder how they do that? Well, that is called Google Authorship and is a very popular way to show who the author of the content is. Here is an […]

Social media meta tags are among us, and they are here to stay. Well, at least for the time being. So what is the importance meta tags in social media? As we all know meta tags are those descriptive elements we add to a web page that provide information to the web browsers, search engines, […]

In this article I will be listing out a set of VB functions to convert GMT time in MS Access. If you are creating linked tables in MS Access to larger enterprise applications or data warehouses, more often than not the time is stored in GMT time. This is a standard practice, and if you […]

Google Spreadsheets have some limiting capabilities when compared to Microsoft Excel, no doubt about it. However, you can do some pretty neat stuff with Google Spreadsheets, one of those sexy creations are dynamic reports. Creating dynamic reports in Google Spreadsheets isn’t too difficult, and it utilizes some of the same concepts that you would use […]

If you have ever had a need to validate text within MS Access, then these functions should definitely be in your toolkit. With these functions you can perform simple text validation such as filtering all but alphanumeric characters, stripping out alphanumeric characters, and checking if a string is alpha characters.

This is one of those functions that I use from time to time when it is important that the user is opening a MS Access database from a specific location. This quick little function will determine the file path that the MS Access database resides in, and compares to a specified path. If they match, […]

If you have ever desired to write a program in MS Access, a must for deploying to users is to hide the MS Access window for the database. Hiding the MS Access window will give the program you spent so much time on that ‘real’ feel when a user accesses it. In my opinion, this […]

Here is a quick solution on how to calculate the first and last day in a week, month, or year in MS Access. I’ve always ran in to situations when dealing with data on needing to determine how to calculate the first or last day of a time range. In more instances than not, I’m […]