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 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