Tips & Tricks

1402, 2015

Filezilla Virus – Black Screen Error

By |February 14th, 2015|Tips & Tricks|0 Comments

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 […]

1808, 2013

Create a Linked Image in Excel

By |August 18th, 2013|MS Excel Tips & Tricks|1 Comment

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 […]

1203, 2013

Convert GMT Time in MS Access

By |March 12th, 2013|MS Access Tips & Tricks|0 Comments

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 […]

503, 2013

Dynamic Reports in Google Spreadsheets

By |March 5th, 2013|Google Apps Tips & Tricks|0 Comments

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 […]

303, 2013

Validate Text in MS Access

By |March 3rd, 2013|MS Access Tips & Tricks|0 Comments

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.

If needed, I can post […]

2702, 2013

Determine File Path of MS Access Database

By |February 27th, 2013|MS Access Tips & Tricks|0 Comments

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

2702, 2013

How to Hide the MS Access Window in a Database

By |February 27th, 2013|MS Access Tips & Tricks|2 Comments

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 […]

2602, 2013

Calculate the First & Last Day in a Week, Month, or Year

By |February 26th, 2013|MS Access Tips & Tricks|0 Comments

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 […]

Signup For Our Newsletter
Want to be kept up to date with all the latest content?
Signup for our newsletter and we'll let you know when new content is available!
And don't worry, we hate spam too! You can unsubscribe at any time.
Never display this again