-
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
-
Lately I have been exploring the powerful capabilities of Scripting and WMI. It was very exciting to discover that it is very easy to convert VBScript for WMI into VBA code that works just like the scripts. While there are a few VBSript functions that cannot be used in VBA, most scripts can be easily...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
05-18-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, Free Microsoft Access Downloads, Microsoft Office, Free Access Downloads, Office Automation, Microsoft Outlook
-
In our last article we learned how to add all the Report Names in the Database to a Listbox by first adding the Report Names to a Table. But what happens if we delete or rename a Report? The names are still in our table and will also be in our Listbox. We do not want to click on the names of Reports...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
04-12-2009
Filed under:
Filed under: Access Downloads, Microsoft Access, Church Management Software, Access, Access Tips, database, Software development, Microsoft Access Software Development, Software, Code, Church, Free Microsoft Access Downloads, Microsoft Office, Free Access Downloads
-
Using the words “New” and “Improved” in advertising, it is claimed, increases sales. We have a New (to some) and Improved way to fill a listbox full of Report Names. We will use a Recordset to fill a Table with all the names of the Reports in your Database. This will allow you...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
03-03-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, Free Microsoft Access Downloads, Microsoft Office, Free Access Downloads, Office Automation, Outlook Automation, Microsoft Outlook
-
Having choices is nice. We all like choices–even 2 year olds! We are going to give you a choice. You can choose from two different ways to fill a Listbox with a list of all the Reports in your Access Database. You can choose an slightly easier undocumented way to fill the listbox with a query or...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
02-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
-
I could hardly believe my eyes. This was some really great code. I had come across some very good code from Remou (F. E. Boyle) before and now a web search turned up this incredible treasure. Could it be true? Could this code really write all of my VBA code in my Database to a text file? I tweaked the...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
01-30-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
-
With this article we will complete our Appointment Dialog Form that will give us more choices and more powerful ways to manage both our Access and Outlook data. We are transforming it into something far better than just a Date Dialog Form. You will also learn new and important methods of managing data...
Posted to
Patrick Wood's Blog
by
Patrick Wood
on
10-06-2008
Filed under:
Filed under: Access Downloads, Microsoft Access, Access, VBA, Access Tips, database, Software development, Microsoft Access Software Development, Software, Code, Free Microsoft Access Downloads, Microsoft Office, Free Access Downloads, Office Automation, Outlook Automation, Microsoft Outlook