Results for "Author: masino sinaga"

This project shows how we can print a very simple report to text file using RichTextBox control and to printer. The report contains simple information with quantity and sum of item per page, the sum of money per page, and total of sum of money in the end of report. User can select category to display the report. User also can change the number of record would be displayed in the screen/printer, and can change which printer will be used in combobox. The selected printer is the default installed printer in your computer. Including functions to adjust text-alignment in the report. This is very useful for you who want to print a simple report with many record to your screen and to your printer, without using the third party activex control. Any comments, feedback, and votes would be truly appriciated.

Confused how to make a database programming using ADO Code? This project shows you how to make a complete ADO Code database programming with: navigation (move first, move next, move previous, move last), add, update, delete, cancel, refresh, find first, find next, filter, unfilter, sort (ascending-descending), bookmark, and adjust datagrid's column. This project uses reference "Microsoft ActiveX Data Objects 2.0 Library" and database Microsoft Access 97. I made this project by using "VB Application Wizard" in Visual Basic's Project Type Dialog Box and I choose "ADO Code" and "Master-Detail" through "Data Access From". Then I modified the code by adding find, filter, sort, and bookmark procedure - each of them in one form. I made findfirst and findnext procedure because there is no findfirst and findnext in ADO. I added "Match whole word only" checkbox in Find form, also in filter procedure/form. I made "Bookmark" procedure, too. I didn't use ADO's bookmark property. The first time I posted this code, I used Indonesia language for comments in source code. Now I have translated them to English, include Label, Field Name, Help, etc. I hope this will help you to understand the code. Any comments and votes would be appreciated. Enjoy!!!

When you display data from a database to a DataGrid, you will see that DataGrid's columns width cannot adjust to the longest data in the field. I made one procedure that can fix the problem. This procedure will adjust DataGrids column width based on longest field in underlying source. Enjoy!!!

Confused how to make a database programming using ADO Code? This project shows you how to make a complete ADO Code database programming with: navigation (move first, move next, move previous, move last), add, update, delete, cancel, refresh, find first, find next, filter, unfilter, sort (ascending-descending), bookmark, and adjust datagrid's column. This project uses reference "Microsoft ActiveX Data Objects 2.0 Library" and database Microsoft Access 97. I made this project by using "VB Application Wizard" in Visual Basic's Project Type Dialog Box and I choose "ADO Code" and "Master-Detail" through "Data Access From". Then I modified the code by adding find, filter, sort, and bookmark procedure - each of them in one form. The comments in the source code using Indonesia language (because I am an Indonesia ;) ). Sorry for this. May be I will translate them to English some other time. I hope you understand the code because the name of procedure using English language, for example: cmdAdd_Click, cmdUpdate_Click, cmdDelete_Click, etc. Enjoy the code! Any comments and votes would be appreciated.

This is the first wizard I made and uploaded to PSC. I never saw the one like this on this site. So I made it. This program/wizard will help you and save a lot of your time to build an ADO Code Project. You can build your ADO Code Project by entering and selecting data/tables/fields based on Database or DSN or parameter you entered/selected to connect to your database. Everything is available in this wizard, included if the .mdb file was password protected. This you can't find in VB Data Form Wizard. So you don't have to build your project from beginning by adding controls on your forms, write the code, adding the components and references, etc. The wizard will automatically add those to your new project. You can also add the find, filter, sort, and bookmark procedure/form to this new project. I made this wizard because I often make ADO Code Database project in my office, and this is really really save a lot of my time. You can learn how to make wizard from this program. I got the template of this wizard from Visual Basic, and I modified as I want to, and I added a Help file that you can call from the wizard. As a matter of fact, this wizard is rather similiar to VB Data Form Wizard in Visual Basic, but I had modified the wizard by adding a lot of enhancements. Please download and prove it now. Any comments, feedback, and votes would be truly appreciated.

Many tips (and trick) tell us that if we want the textbox control ignore the character which is not numeric character, then we can just put the code that shown in KeyPress event procedure below. But, sometimes we forgot that although we have put the code in KeyPress event procedure, user still can input the alpha character to textbox control by doing copy and Paste to textbox. So, here is another tips to fix the problem. I hope this helpful.

This project shows you how a user login to program and access menu based on his/her level. Program will display every possibility fails message whenever user failed try to login. The chances for login are only 3 times. After that, user must try again from begining. I also made a form to manage user account, that can be accessed only by user with level 'Admin'. Password field was encrypted in database. 'Admin' can manage all user accounts (add, edit, update, delete, change password, decrypt password, view user activity that saved in database, convert/transfer user activity data to log text file, and view that log text file). User can change his/her password. If user level is 'Operator' or 'Manager', he/she can only change his/her own password, but 'Admin', he can change all password user, and his too, of course. And I made menu to compact, repair, and backup database to manage your database performances. I use database Access97 password protected. I also made setting menu to change program setting (run program at startup - this will be occured if you had made an .exe file named 'LOGIN.exe', display screen saver if program idles in for a certain time, protect screen saver with user password, and don't show tips at startup. There is a 'Tips of Day' which display its data from text file. You can learn how to make a tips form and display the tips form or hide it at startup. The user activities that saved in database can be transfered to text file, and this log text file can be displayed from this program, too. So, user activities data can be transfered to text file, and you can delete the records from database. This will reduce your database file size. I made a screen saver form with analog clock. I used Thaha Husain's code to make the needle clock movement (just like a clock in your wall). Thanks to Husain for this code. Screen saver cannot be interrupted by 'Ctrl-Alt-Del', 'Alt-F4', 'Ctrl-Break', etc. Only active/current user can quit form screen saver. If user quit from this program, there will be an offers from program whether your computer would be shut down directly by program or not. Well, that's all I think. Hope it's very useful for you. Any comments, feedback, and votes would be appreciated. Thank you.

This project shows how we can print a very simple report to text file using RichTextBox control and to printer. The report contains simple information with quantity and sum of item per page, the sum of money per page, and total of sum of money in the end of report. User can select category to display the report. User also can change the number of record would be displayed in the screen/printer, and can change which printer will be used in combobox. The selected printer is the default installed printer in your computer. Including functions to adjust text-alignment in the report. This is very useful for you who want to print a simple report with many record to your screen and to your printer, without using the third party activex control. Any comments, feedback, and votes would be truly appriciated.

Confused how to make a database programming using ADO Code? This project shows you how to make a complete ADO Code database programming with: navigation (move first, move next, move previous, move last), add, update, delete, cancel, refresh, find first, find next, filter, unfilter, sort (ascending-descending), bookmark, and adjust datagrid's column. This project uses reference "Microsoft ActiveX Data Objects 2.0 Library" and database Microsoft Access 97. I made this project by using "VB Application Wizard" in Visual Basic's Project Type Dialog Box and I choose "ADO Code" and "Master-Detail" through "Data Access From". Then I modified the code by adding find, filter, sort, and bookmark procedure - each of them in one form. I made findfirst and findnext procedure because there is no findfirst and findnext in ADO. I added "Match whole word only" checkbox in Find form, also in filter procedure/form. I made "Bookmark" procedure, too. I didn't use ADO's bookmark property. The first time I posted this code, I used Indonesia language for comments in source code. Now I have translated them to English, include Label, Field Name, Help, etc. I hope this will help you to understand the code. Any comments and votes would be appreciated. Enjoy!!!

When you display data from a database to a DataGrid, you will see that DataGrid's columns width cannot adjust to the longest data in the field. I made one procedure that can fix the problem. This procedure will adjust DataGrids column width based on longest field in underlying source. Enjoy!!!

Confused how to make a database programming using ADO Code? This project shows you how to make a complete ADO Code database programming with: navigation (move first, move next, move previous, move last), add, update, delete, cancel, refresh, find first, find next, filter, unfilter, sort (ascending-descending), bookmark, and adjust datagrid's column. This project uses reference "Microsoft ActiveX Data Objects 2.0 Library" and database Microsoft Access 97. I made this project by using "VB Application Wizard" in Visual Basic's Project Type Dialog Box and I choose "ADO Code" and "Master-Detail" through "Data Access From". Then I modified the code by adding find, filter, sort, and bookmark procedure - each of them in one form. The comments in the source code using Indonesia language (because I am an Indonesia ;) ). Sorry for this. May be I will translate them to English some other time. I hope you understand the code because the name of procedure using English language, for example: cmdAdd_Click, cmdUpdate_Click, cmdDelete_Click, etc. Enjoy the code! Any comments and votes would be appreciated.

This is the first wizard I made and uploaded to PSC. I never saw the one like this on this site. So I made it. This program/wizard will help you and save a lot of your time to build an ADO Code Project. You can build your ADO Code Project by entering and selecting data/tables/fields based on Database or DSN or parameter you entered/selected to connect to your database. Everything is available in this wizard, included if the .mdb file was password protected. This you can't find in VB Data Form Wizard. So you don't have to build your project from beginning by adding controls on your forms, write the code, adding the components and references, etc. The wizard will automatically add those to your new project. You can also add the find, filter, sort, and bookmark procedure/form to this new project. I made this wizard because I often make ADO Code Database project in my office, and this is really really save a lot of my time. You can learn how to make wizard from this program. I got the template of this wizard from Visual Basic, and I modified as I want to, and I added a Help file that you can call from the wizard. As a matter of fact, this wizard is rather similiar to VB Data Form Wizard in Visual Basic, but I had modified the wizard by adding a lot of enhancements. Please download and prove it now. Any comments, feedback, and votes would be truly appreciated.

Many tips (and trick) tell us that if we want the textbox control ignore the character which is not numeric character, then we can just put the code that shown in KeyPress event procedure below. But, sometimes we forgot that although we have put the code in KeyPress event procedure, user still can input the alpha character to textbox control by doing copy and Paste to textbox. So, here is another tips to fix the problem. I hope this helpful.

This project shows you how a user login to program and access menu based on his/her level. Program will display every possibility fails message whenever user failed try to login. The chances for login are only 3 times. After that, user must try again from begining. I also made a form to manage user account, that can be accessed only by user with level 'Admin'. Password field was encrypted in database. 'Admin' can manage all user accounts (add, edit, update, delete, change password, decrypt password, view user activity that saved in database, convert/transfer user activity data to log text file, and view that log text file). User can change his/her password. If user level is 'Operator' or 'Manager', he/she can only change his/her own password, but 'Admin', he can change all password user, and his too, of course. And I made menu to compact, repair, and backup database to manage your database performances. I use database Access97 password protected. I also made setting menu to change program setting (run program at startup - this will be occured if you had made an .exe file named 'LOGIN.exe', display screen saver if program idles in for a certain time, protect screen saver with user password, and don't show tips at startup. There is a 'Tips of Day' which display its data from text file. You can learn how to make a tips form and display the tips form or hide it at startup. The user activities that saved in database can be transfered to text file, and this log text file can be displayed from this program, too. So, user activities data can be transfered to text file, and you can delete the records from database. This will reduce your database file size. I made a screen saver form with analog clock. I used Thaha Husain's code to make the needle clock movement (just like a clock in your wall). Thanks to Husain for this code. Screen saver cannot be interrupted by 'Ctrl-Alt-Del', 'Alt-F4', 'Ctrl-Break', etc. Only active/current user can quit form screen saver. If user quit from this program, there will be an offers from program whether your computer would be shut down directly by program or not. Well, that's all I think. Hope it's very useful for you. Any comments, feedback, and votes would be appreciated. Thank you.

This project shows how we can print a very simple report to text file using RichTextBox control and to printer. The report contains simple information with quantity and sum of item per page, the sum of money per page, and total of sum of money in the end of report. User can select category to display the report. User also can change the number of record would be displayed in the screen/printer, and can change which printer will be used in combobox. The selected printer is the default installed printer in your computer. Including functions to adjust text-alignment in the report. This is very useful for you who want to print a simple report with many record to your screen and to your printer, without using the third party activex control. Any comments, feedback, and votes would be truly appriciated.

Confused how to make a database programming using ADO Code? This project shows you how to make a complete ADO Code database programming with: navigation (move first, move next, move previous, move last), add, update, delete, cancel, refresh, find first, find next, filter, unfilter, sort (ascending-descending), bookmark, and adjust datagrid's column. This project uses reference "Microsoft ActiveX Data Objects 2.0 Library" and database Microsoft Access 97. I made this project by using "VB Application Wizard" in Visual Basic's Project Type Dialog Box and I choose "ADO Code" and "Master-Detail" through "Data Access From". Then I modified the code by adding find, filter, sort, and bookmark procedure - each of them in one form. I made findfirst and findnext procedure because there is no findfirst and findnext in ADO. I added "Match whole word only" checkbox in Find form, also in filter procedure/form. I made "Bookmark" procedure, too. I didn't use ADO's bookmark property. The first time I posted this code, I used Indonesia language for comments in source code. Now I have translated them to English, include Label, Field Name, Help, etc. I hope this will help you to understand the code. Any comments and votes would be appreciated. Enjoy!!!

When you display data from a database to a DataGrid, you will see that DataGrid's columns width cannot adjust to the longest data in the field. I made one procedure that can fix the problem. This procedure will adjust DataGrids column width based on longest field in underlying source. Enjoy!!!

Confused how to make a database programming using ADO Code? This project shows you how to make a complete ADO Code database programming with: navigation (move first, move next, move previous, move last), add, update, delete, cancel, refresh, find first, find next, filter, unfilter, sort (ascending-descending), bookmark, and adjust datagrid's column. This project uses reference "Microsoft ActiveX Data Objects 2.0 Library" and database Microsoft Access 97. I made this project by using "VB Application Wizard" in Visual Basic's Project Type Dialog Box and I choose "ADO Code" and "Master-Detail" through "Data Access From". Then I modified the code by adding find, filter, sort, and bookmark procedure - each of them in one form. The comments in the source code using Indonesia language (because I am an Indonesia ;) ). Sorry for this. May be I will translate them to English some other time. I hope you understand the code because the name of procedure using English language, for example: cmdAdd_Click, cmdUpdate_Click, cmdDelete_Click, etc. Enjoy the code! Any comments and votes would be appreciated.

This is the first wizard I made and uploaded to PSC. I never saw the one like this on this site. So I made it. This program/wizard will help you and save a lot of your time to build an ADO Code Project. You can build your ADO Code Project by entering and selecting data/tables/fields based on Database or DSN or parameter you entered/selected to connect to your database. Everything is available in this wizard, included if the .mdb file was password protected. This you can't find in VB Data Form Wizard. So you don't have to build your project from beginning by adding controls on your forms, write the code, adding the components and references, etc. The wizard will automatically add those to your new project. You can also add the find, filter, sort, and bookmark procedure/form to this new project. I made this wizard because I often make ADO Code Database project in my office, and this is really really save a lot of my time. You can learn how to make wizard from this program. I got the template of this wizard from Visual Basic, and I modified as I want to, and I added a Help file that you can call from the wizard. As a matter of fact, this wizard is rather similiar to VB Data Form Wizard in Visual Basic, but I had modified the wizard by adding a lot of enhancements. Please download and prove it now. Any comments, feedback, and votes would be truly appreciated.

Many tips (and trick) tell us that if we want the textbox control ignore the character which is not numeric character, then we can just put the code that shown in KeyPress event procedure below. But, sometimes we forgot that although we have put the code in KeyPress event procedure, user still can input the alpha character to textbox control by doing copy and Paste to textbox. So, here is another tips to fix the problem. I hope this helpful.