|
|
-
|
|
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 ha......
|
|
-
|
|
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 Processe......
|
|
-
|
|
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 dat......
|
|
-
|
|
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 pr......
|
|
-
|
|
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 O......
|
|
-
|
|
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 eas......
|
|
-
|
|
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......
|
|
-
|
|
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
Databas......
|
|
-
|
|
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 ......
|
|
-
|
|
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 ......
|
|