-
A free mdb edition of the Code Tracker™ for Microsoft Access® is now available for those who cannot use an Add-in. This Code Tracker mdb edition was developed to help someone whose company policies and practices would not allow them to install an Add-in. You can download the CodeTrackerMDB1...
-
The free Code Tracker™ Beta Add-in for Microsoft Access® has been upgraded to Version 1.0 and can be used in Access 2002, 2003, and 2007. It is a free download . The Code Tracker™ 1.0 Add-in records the use of every procedure in your database. You can see how and when your code is being...
-
On June 1, Liz Ravenwood asked the MS_Access_Professionals group on Yahoo, “Is there a way that I can determine if chunks of my vba code is never being used?” As I thought about this I thought that there should be a way to do this without spending a small fortune on expensive software. I...
-
There are a number of reasons to write data to the registry such as saving the settings preferred by an individual user to storing an activation key or a demo version expiration date. But before we can save any values to the registry we must have a registry key to hold the information. We can think of...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
03-25-2010
Filed under:
Filed under: Microsoft Access, Access, VBA, Access Tips, database, Software development, Code, #MSAccess, Registry, Scripting, WMI, Windows Registry
-
In this article I will show you the easiest way to use VBA to get a username, the name of the user’s computer, the Program Files Folder, the user’s My Documents folder, the Start Menu folder, the user’s Desktop folder, or the Shared Documents folder. This information will enable you...
-
I came across this blog post, Hey, Scripting Guy! How can I retrieve the path to the Program Files folder on a computer? — CC, and I began thinking how useful knowing the Program Files Path could be. I thought about how it would not just be helpful but even essential information in certain development...
-
The Registry contains an enormous amount of data, some of which is very useful to the Microsoft Access developer. Microsoft Access VBA allows us to use WMI to access that data. We can get a list of all the System DSNs on a Computer, all of the ODBC drivers, all the Internet Cookies, list the paths of...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
08-06-2009
Filed under:
Filed under: Access Downloads, Microsoft Access, Church Management Software, Access, VBA, Access Tips, database, Software development, Microsoft Access Software Development, Software, Code, Church, Free Microsoft Access Downloads, Microsoft Office, Free Access Downloads, Scripting, WMI, Office Automation, Outlook Automation, Microsoft Outlook
-
Microsoft Access VBA enables you to store a value in the Registry with just one line of code. You can also read the stored value with one line of code. This is possible using Access’ built-in code which has its own section of the Registry. Jimmy Peña, author of the excellent Code For Excel...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
07-23-2009
Filed under:
Filed under: Access Downloads, Microsoft Access, Church Management Software, Access, VBA, Access Tips, database, Software development, Microsoft Access Software Development, Software, Code, Church, Free Microsoft Access Downloads, Microsoft Office, Free Access Downloads, Microsoft Outlook
-
Microsoft Access VBA can read and write to the Windows Registry by using WMI. In this article we are going to show you how easy it is to read 5 different types of Registry Values with VBA and WMI. The Registry provided a solution for the problem caused by the proliferation of separate ini settings files...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
07-16-2009
Filed under:
Filed under: Access Downloads, Microsoft Access, Church Management Software, Access, VBA, Access Tips, database, Software development, Microsoft Access Software Development, Software, Code, Church, Free Microsoft Access Downloads, Microsoft Office, Free Access Downloads, Scripting, WMI, Outlook Automation, Microsoft Outlook
-
You can Stop, Start, Pause, and Resume Windows Services with Microsoft Access VBA by using the power of WMI (Windows Management Instrumentation). This is called “setting the State” of the Service. This can be useful, for example, if we want to make sure the SQL Server Reporting Services is...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
07-07-2009
Filed under:
Filed under: Access Downloads, Microsoft Access, Church Management Software, Access, VBA, Access Tips, database, Software development, Microsoft Access Software Development, Software, Code, Church, Free Microsoft Access Downloads, Microsoft Office, Free Access Downloads, Scripting, WMI, Outlook Automation, Microsoft Outlook
-
You can Stop, Start, Pause, Resume, Disable, and Enable Windows Services with Microsoft Access VBA. Access VBA can do this by using the power of WMI (Windows Management Instrumentation). We are able to do this by using late binding to access the WbemScripting library. With late binding you do not have...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
06-25-2009
Filed under:
Filed under: Access Downloads, Microsoft Access, Church Management Software, Access, VBA, Access Tips, database, Software development, Microsoft Access Software Development, Software, Code, Church, Free Microsoft Access Downloads, Microsoft Office, Free Access Downloads, Scripting, WMI, Outlook Automation, Microsoft Outlook
-
Our last two articles were about using WMI to manage Processes which are software programs that run on our computers. Processes are like CEOs that are up front and visible. Windows Services are like the CEO’s Secretary who is the one who really gets things done in the background. Some Processes...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
06-17-2009
Filed under:
Filed under: Access Downloads, Microsoft Access, Church Management Software, Access, VBA, Access Tips, database, Software development, Microsoft Access Software Development, Software, Code, Church, Free Microsoft Access Downloads, Microsoft Office, Free Access Downloads, Scripting, WMI, Outlook Automation, Microsoft Outlook
-
Microsoft Access can Terminate Processes using WMI. In other words, Access can shut down an application that is running on a computer. This capability is very useful when using Office automation or automation with other applications. For example, you may want to open an Excel Spreadsheet, import data...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
06-10-2009
Filed under:
Filed under: Access Downloads, Microsoft Access, Church Management Software, Access, VBA, Access Tips, database, Software development, Microsoft Access Software Development, Software, Code, Church, Free Microsoft Access Downloads, Microsoft Office, Free Access Downloads, Scripting, WMI, Office Automation, Outlook Automation, Microsoft Outlook
-
Are you curious to know what processes are running on your computer? You may be surprised to discover exactly what programs are running and how many run when you boot up. Just a few minutes ago I had 68 processes running. By using VBA to access WMI, I gathered an abundance of information on those processes...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
06-04-2009
Filed under:
Filed under: Access Downloads, Microsoft Access, Church Management Software, Access, VBA, Access Tips, database, Software development, Microsoft Access Software Development, Software, Code, Church, Free Microsoft Access Downloads, Microsoft Office, Free Access Downloads, Scripting, WMI, Outlook Automation, Microsoft Outlook
-
In our last article we learned that we can access the power of scripting with VBA. This article will show how to get vital information from WMI Classes by listing Class Property names and values. The Win32_OperatingSystem Class grants us access to a wealth of useful information about the Computer Operating...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
05-27-2009
Filed under:
Filed under: Access Downloads, Microsoft Access, Church Management Software, Access, VBA, Access Tips, database, Software development, Microsoft Access Software Development, Software, Code, Church, Free Microsoft Access Downloads, Free Access Downloads, Scripting, WMI