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