MS Access Tips & Tricks

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

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

1302, 2013

Display Folder Contents in MS Access

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

Here is another little VBA nugget that will cycle through and display the contents of a folder. I use this in MS Access for those fun times when I need the application to scan for a particular set of files and load them through the database. In addition to this, I have done some other […]

1302, 2013

Dynamically Link to Excel From MS Access

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

Here is a quick and simple solution that will allow you to dynamically link to Excel from MS Access. This routine creates a linked table to MS Access from Excel, that will allow you to pull in the data from Excel and reference it as a table in Access. This can come in handy for […]

802, 2013

Sequence Events in MS Access With Style

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

I’ve put a lot of time and effort in to this little gem, as the root of it solves many issues that I have ran in to over the years. How to sequence events in MS Access that allows for growth and stays flexible. So what does that mean exactly? Let me tell you…

Have you […]

802, 2013

How To Pause VBA While It’s Running

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

Here is a quick and dirty snippet on how to pause VBA while it is running and executing a process. Say for instance you are setting a connection and closing another to an external source, and you need to pause your VBA for a moment of time for the exterior items to transition before continuing […]

2301, 2013

Windows 7 Task Scheduler With MS Access Database

By |January 23rd, 2013|MS Access Tips & Tricks|2 Comments

I’ve been using Windows Task Scheduler for quite some time now, especially with Microsoft Access Databases to trigger them to run at a specific time. I recently switched over to a box running Windows 7 and when it came time for me to migrate some MS Access Databases over I thought it would be fairly […]

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