Results for "Author: erick asas"

This submission was deleted due to the recent hacker attack. So I'm re-posting it to give access to other users who want this code.

With SQL Server, to save a value to a field with an IMAGE data type, a programmer must provide the proper means to save the data so that the data can be properly interpreted by a bound picture box or an image control. Simply binding the image field to a picture box and populating your picture box with a LoadPicture command will not save the image to the database. Here, I will share with you how I tackle this problem so that I can make use of the bound capabilities of an image or picture box. I've tried this way both in SQL Server 2000 and MS Access database, and it all works. With this program, a MS ACCESS database is used, but don't worry, with SQL Servers, you will just have to change the connection string definition in order to access the database and off you go.... Enjoy.

This application illustrates basic manipulation of the treeview control like populating a treeview with items from a database, expanding the treeview nodes manually by clicking or by automatically by code, searching a tree for an item and others. This also illustrates how to simply create a splitter by using pure vb code. Please give feedbacks.

Well guys, due to several requests for an update on this project, I decided to create a complete inventory application where most transactions involved the manipulation of the treeview control. This update contains several more features, besides the one featured in my first release. This update features revised tree search, node expansion, adding, editing and deleting nodes, cutting, copying and pasting a node and all its children, and set and reset node colors. Creation of pure vb splitter just like windows explorer splitter is also featured here as well as adding bitmaps to menu items. Saving an ado recordset to excel form is another added feature as well as compacting and repairing a MS database. The zipped file was already updated to include the missing splash screen. Also, don't forget to make a reference to the ms excel library so you can make use of the SaveAs Excel function. Please give feedbacks on what you think of this project, and do'nt forget to vote...

This project will show you how to utlize MS Access as your report generator. If you are tired of designing your report using other third party report generators and if you want to create dynamic reports without making major revisions of your app, then perhaps this project can help you. Be sure to reference the MS DAO library, MS ADO Library and MS Access Object library. If you have comments, email me.If you like it, then vote. Use the following: Username: BetaTester Password: BetaTester

Display Checkboxes in Listbox Horizontally I've been searching the internet and PSC on how to display checkboxes in a listbox in a horizontal manner but I didn't found any. Perhaps my search keywords are wrong but really I found nothing. I decided to re-examine the listbox property if I can find something that I have overlooked before and there it is. Who would have thought that by merely CHANGING THE COLUMNS PROPERTY TO ANY NUMBER OTHER THAN 0 WOULD ACCOMPLISH WHAT I WANTED TO DO. Many of you may have already known this but for newbies out there, this might help. See the screenshot to see what I mean. For the screenshot below, the setting is: Listbox1.columns = 4 OR In the properties list, change Columns = 0 to Columns = any number you want. The number of columns specified will configure the listbox to show 4 columns in its display window. A horizontal scrollbar will be displayed if the data display occupies more than 4 columns.

This submission was deleted due to the recent hacker attack. So I'm re-posting it to give access to other users who want this code.

With SQL Server, to save a value to a field with an IMAGE data type, a programmer must provide the proper means to save the data so that the data can be properly interpreted by a bound picture box or an image control. Simply binding the image field to a picture box and populating your picture box with a LoadPicture command will not save the image to the database. Here, I will share with you how I tackle this problem so that I can make use of the bound capabilities of an image or picture box. I've tried this way both in SQL Server 2000 and MS Access database, and it all works. With this program, a MS ACCESS database is used, but don't worry, with SQL Servers, you will just have to change the connection string definition in order to access the database and off you go.... Enjoy.

This application illustrates basic manipulation of the treeview control like populating a treeview with items from a database, expanding the treeview nodes manually by clicking or by automatically by code, searching a tree for an item and others. This also illustrates how to simply create a splitter by using pure vb code. Please give feedbacks.

Well guys, due to several requests for an update on this project, I decided to create a complete inventory application where most transactions involved the manipulation of the treeview control. This update contains several more features, besides the one featured in my first release. This update features revised tree search, node expansion, adding, editing and deleting nodes, cutting, copying and pasting a node and all its children, and set and reset node colors. Creation of pure vb splitter just like windows explorer splitter is also featured here as well as adding bitmaps to menu items. Saving an ado recordset to excel form is another added feature as well as compacting and repairing a MS database. The zipped file was already updated to include the missing splash screen. Also, don't forget to make a reference to the ms excel library so you can make use of the SaveAs Excel function. Please give feedbacks on what you think of this project, and do'nt forget to vote...

This project will show you how to utlize MS Access as your report generator. If you are tired of designing your report using other third party report generators and if you want to create dynamic reports without making major revisions of your app, then perhaps this project can help you. Be sure to reference the MS DAO library, MS ADO Library and MS Access Object library. If you have comments, email me.If you like it, then vote. Use the following: Username: BetaTester Password: BetaTester

Display Checkboxes in Listbox Horizontally I've been searching the internet and PSC on how to display checkboxes in a listbox in a horizontal manner but I didn't found any. Perhaps my search keywords are wrong but really I found nothing. I decided to re-examine the listbox property if I can find something that I have overlooked before and there it is. Who would have thought that by merely CHANGING THE COLUMNS PROPERTY TO ANY NUMBER OTHER THAN 0 WOULD ACCOMPLISH WHAT I WANTED TO DO. Many of you may have already known this but for newbies out there, this might help. See the screenshot to see what I mean. For the screenshot below, the setting is: Listbox1.columns = 4 OR In the properties list, change Columns = 0 to Columns = any number you want. The number of columns specified will configure the listbox to show 4 columns in its display window. A horizontal scrollbar will be displayed if the data display occupies more than 4 columns.

This submission was deleted due to the recent hacker attack. So I'm re-posting it to give access to other users who want this code.

With SQL Server, to save a value to a field with an IMAGE data type, a programmer must provide the proper means to save the data so that the data can be properly interpreted by a bound picture box or an image control. Simply binding the image field to a picture box and populating your picture box with a LoadPicture command will not save the image to the database. Here, I will share with you how I tackle this problem so that I can make use of the bound capabilities of an image or picture box. I've tried this way both in SQL Server 2000 and MS Access database, and it all works. With this program, a MS ACCESS database is used, but don't worry, with SQL Servers, you will just have to change the connection string definition in order to access the database and off you go.... Enjoy.

This application illustrates basic manipulation of the treeview control like populating a treeview with items from a database, expanding the treeview nodes manually by clicking or by automatically by code, searching a tree for an item and others. This also illustrates how to simply create a splitter by using pure vb code. Please give feedbacks.

Well guys, due to several requests for an update on this project, I decided to create a complete inventory application where most transactions involved the manipulation of the treeview control. This update contains several more features, besides the one featured in my first release. This update features revised tree search, node expansion, adding, editing and deleting nodes, cutting, copying and pasting a node and all its children, and set and reset node colors. Creation of pure vb splitter just like windows explorer splitter is also featured here as well as adding bitmaps to menu items. Saving an ado recordset to excel form is another added feature as well as compacting and repairing a MS database. The zipped file was already updated to include the missing splash screen. Also, don't forget to make a reference to the ms excel library so you can make use of the SaveAs Excel function. Please give feedbacks on what you think of this project, and do'nt forget to vote...

This project will show you how to utlize MS Access as your report generator. If you are tired of designing your report using other third party report generators and if you want to create dynamic reports without making major revisions of your app, then perhaps this project can help you. Be sure to reference the MS DAO library, MS ADO Library and MS Access Object library. If you have comments, email me.If you like it, then vote. Use the following: Username: BetaTester Password: BetaTester

Display Checkboxes in Listbox Horizontally I've been searching the internet and PSC on how to display checkboxes in a listbox in a horizontal manner but I didn't found any. Perhaps my search keywords are wrong but really I found nothing. I decided to re-examine the listbox property if I can find something that I have overlooked before and there it is. Who would have thought that by merely CHANGING THE COLUMNS PROPERTY TO ANY NUMBER OTHER THAN 0 WOULD ACCOMPLISH WHAT I WANTED TO DO. Many of you may have already known this but for newbies out there, this might help. See the screenshot to see what I mean. For the screenshot below, the setting is: Listbox1.columns = 4 OR In the properties list, change Columns = 0 to Columns = any number you want. The number of columns specified will configure the listbox to show 4 columns in its display window. A horizontal scrollbar will be displayed if the data display occupies more than 4 columns.

This submission was deleted due to the recent hacker attack. So I'm re-posting it to give access to other users who want this code.

With SQL Server, to save a value to a field with an IMAGE data type, a programmer must provide the proper means to save the data so that the data can be properly interpreted by a bound picture box or an image control. Simply binding the image field to a picture box and populating your picture box with a LoadPicture command will not save the image to the database. Here, I will share with you how I tackle this problem so that I can make use of the bound capabilities of an image or picture box. I've tried this way both in SQL Server 2000 and MS Access database, and it all works. With this program, a MS ACCESS database is used, but don't worry, with SQL Servers, you will just have to change the connection string definition in order to access the database and off you go.... Enjoy.