Results for "Author: chris kesler"
This is an example of how to create an ActiveX EXE Server that does three things. 1) retrieves file listing of databases from the server directory, 2) retrieves a list of reports and then lets you retrieve the pre-defined parameters in that report and 3) allows you to fire off the report to a Word file in the server directory and then attach it to a MAPI Session and mail it. I have currently set it to MS Exchange Setting (hard coded), but you can change that to your own personal profile. This was put together in a limited amount of time so there is some spaghetti code involved as well as some untrapped errors, but I am still working on it. If you like it please vote on it and let me know if you like it and I will continue to clean up the code and release later versions in the future. A test Database is included (Rentals2000.mdb) which is an Access 2000 database, there is also an Access 97 Database included (Rentals.mdb). However, the code was created for Access 2000 due to the VBA library that was used. Good luck!
***UPDATED 01/22/2003*** This is the same as my VB6 program only it's been adjusted to compile in the .NET environment. It does as stated below. To retrieve a list of jobs on a given SQL Server (7.0 or 2000) and track it's progress through it's numerous jobsteps. This is typically a nice little app to have if you have many jobs that run throughout the day and you want to see if one of those steps has hung up. To make this app truly useful I added a monitoring timer that refreshes every ten seconds or so. The Restart Jobs button is not activated at this time, but the coding should be a snap someone wanting the ability to stop and start jobs from this application. This application is in it's infancy at this moment since I've been working on it for only a couple of days, but is useful even now as far as I'm concerned. Please vote if you like it...
***UPDATED 02/19/2003*** This is a quick and simple documentor for SQL Server. It returns a list of registered Servers in your EM. You choose the one to connect to, then you choose the database - once connected it will return a list of Databases - then you choose what you want to document and how you want it returned in an Excel Spreadsheet. It's well documented code so you should be able to make changes without much pokin around.
This code snippet is actually a Macro for Outlook 97, 98 or 2000 but can be easily instituted into VB by creating your Outlook.Application object to completely automate the mod from VB. It could also be used with MAPI mail as well.
Ever want to be able to automate a web page process through a Visual Basic front end or form you've created? This code helps you control a web page through the WebBrowser control to emulate actually entering data and submitting it through the web page itself. Check it out. This code is from http://vbpoint.cjb.net/ and there are more useful code there also.
Have you ever wondered how to remotely fire a DTS Package in SQL Server 7 from a Visual Basic Application? Me too... So through rigorous research and aggrevation I figured out a very simple way to do this.
UPDATED - 12/07/01!!! This kind of goes against my article earlier this this week. In a new environment I was able to do two things. I was able to query a list of DTS Packages from my Server and then execute a chosen Package remotely. This can be easily modified to accept collections and remotely fire multiple Packages on a timer (which is what I'm using it for). If you downloaded the zip file earlier you may want to download it again since I've updated it and revised some of the references. NOTE: If you use a DSN connection it must be pointed at the MSDB database to get the list of DTS Packages, not the Database you are trying to run the DTS Packages Against.
This is an update to the Versatile Mask Control and Ultimate Making Control. I have added functionality for Numbers and Number Precision as well as cleaned up the code for setting up the code at design time to make changes during run-time. I have also enhanced a couple of items withing the code to allow for better control of data being entered. I hope you enjoy this Completely revamped control.
This is an example of how to create an ActiveX EXE Server that does three things. 1) retrieves file listing of databases from the server directory, 2) retrieves a list of reports and then lets you retrieve the pre-defined parameters in that report and 3) allows you to fire off the report to a Word file in the server directory and then attach it to a MAPI Session and mail it. I have currently set it to MS Exchange Setting (hard coded), but you can change that to your own personal profile. This was put together in a limited amount of time so there is some spaghetti code involved as well as some untrapped errors, but I am still working on it. If you like it please vote on it and let me know if you like it and I will continue to clean up the code and release later versions in the future. A test Database is included (Rentals2000.mdb) which is an Access 2000 database, there is also an Access 97 Database included (Rentals.mdb). However, the code was created for Access 2000 due to the VBA library that was used. Good luck!
***UPDATED 01/22/2003*** This is the same as my VB6 program only it's been adjusted to compile in the .NET environment. It does as stated below. To retrieve a list of jobs on a given SQL Server (7.0 or 2000) and track it's progress through it's numerous jobsteps. This is typically a nice little app to have if you have many jobs that run throughout the day and you want to see if one of those steps has hung up. To make this app truly useful I added a monitoring timer that refreshes every ten seconds or so. The Restart Jobs button is not activated at this time, but the coding should be a snap someone wanting the ability to stop and start jobs from this application. This application is in it's infancy at this moment since I've been working on it for only a couple of days, but is useful even now as far as I'm concerned. Please vote if you like it...
This is an update to the Versatile Mask Control and Ultimate Making Control. I have added functionality for Numbers and Number Precision as well as cleaned up the code for setting up the code at design time to make changes during run-time. I have also enhanced a couple of items withing the code to allow for better control of data being entered. I hope you enjoy this Completely revamped control.
This code snippet is actually a Macro for Outlook 97, 98 or 2000 but can be easily instituted into VB by creating your Outlook.Application object to completely automate the mod from VB. It could also be used with MAPI mail as well.
Ever want to be able to automate a web page process through a Visual Basic front end or form you've created? This code helps you control a web page through the WebBrowser control to emulate actually entering data and submitting it through the web page itself. Check it out. This code is from http://vbpoint.cjb.net/ and there are more useful code there also.
Have you ever wondered how to remotely fire a DTS Package in SQL Server 7 from a Visual Basic Application? Me too... So through rigorous research and aggrevation I figured out a very simple way to do this.
UPDATED - 12/07/01!!! This kind of goes against my article earlier this this week. In a new environment I was able to do two things. I was able to query a list of DTS Packages from my Server and then execute a chosen Package remotely. This can be easily modified to accept collections and remotely fire multiple Packages on a timer (which is what I'm using it for). If you downloaded the zip file earlier you may want to download it again since I've updated it and revised some of the references. NOTE: If you use a DSN connection it must be pointed at the MSDB database to get the list of DTS Packages, not the Database you are trying to run the DTS Packages Against.
This is an example of how to create an ActiveX EXE Server that does three things. 1) retrieves file listing of databases from the server directory, 2) retrieves a list of reports and then lets you retrieve the pre-defined parameters in that report and 3) allows you to fire off the report to a Word file in the server directory and then attach it to a MAPI Session and mail it. I have currently set it to MS Exchange Setting (hard coded), but you can change that to your own personal profile. This was put together in a limited amount of time so there is some spaghetti code involved as well as some untrapped errors, but I am still working on it. If you like it please vote on it and let me know if you like it and I will continue to clean up the code and release later versions in the future. A test Database is included (Rentals2000.mdb) which is an Access 2000 database, there is also an Access 97 Database included (Rentals.mdb). However, the code was created for Access 2000 due to the VBA library that was used. Good luck!
***UPDATED 02/19/2003*** This is a quick and simple documentor for SQL Server. It returns a list of registered Servers in your EM. You choose the one to connect to, then you choose the database - once connected it will return a list of Databases - then you choose what you want to document and how you want it returned in an Excel Spreadsheet. It's well documented code so you should be able to make changes without much pokin around.
This code snippet is actually a Macro for Outlook 97, 98 or 2000 but can be easily instituted into VB by creating your Outlook.Application object to completely automate the mod from VB. It could also be used with MAPI mail as well.
Ever want to be able to automate a web page process through a Visual Basic front end or form you've created? This code helps you control a web page through the WebBrowser control to emulate actually entering data and submitting it through the web page itself. Check it out. This code is from http://vbpoint.cjb.net/ and there are more useful code there also.
Have you ever wondered how to remotely fire a DTS Package in SQL Server 7 from a Visual Basic Application? Me too... So through rigorous research and aggrevation I figured out a very simple way to do this.