Results for "Author: chris kesler"
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!
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!
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.