1.) First you must click the Project Tab shown in the figure below,Then Click Add Data  Environment 2.) Connection Environment will Appear 3.) To connect to Data Source Name,just right-click the connection,then click properties like shown on the image below ...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Data Environment, Database, SQL Server, Visual Basic 6.0

1.) First you must click the Project Tab shown in the figure below,Then Click Add Data  Environment 2.) Connection Environment will Appea...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Data Environment, Database, MS Access, Visual Basic 6.0

1.) First you must click the Project Tab shown in the figure below,Then Click Add Data Environment 2.) Connection Environment will Appear 3.) To connect to Data Source Name,just right-click the connection,then click properties like shown on the image below 4.) Data Link Properties...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Data Environment, Database, DSN Connection, SQL Server, Visual Basic 6.0

This is the basic way and a basic code on how you to Add Data on Combo Box Control of your Vb6 program the code below is show you the static way that the data has never change during runtime: With Combo1    .AddItem "Adrian"    .AddItem "Panoy" End With The Code below show you the dynamic way because the data are fetch from your database: Note: Make sure that your Database Connection is properly established Adrian="SELECT...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Combo Box, Vb6 Controls, Visual Basic 6.0

This is the very basic way on how you to create your own count down timer using timer Control on your Visual Basic Project just add 1 Label,1 Command button,and also a timer control,at label caption property make it 15,then at the timer control property under Enabled=False,and Interval=1000 which is equivalent to 1 seconds,then under command button clivk event place this code below Private Sub Command1_Click()     Timer1.Enabled...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Timer, Vb6 Controls, Visual Basic 6.0

 This Tutorial will Show you on how to add a Toolbar Control on your visual Basic program, just follow the few steps below:  1.) Go to Project Tab like shown on the image below then click Components  2.)the components dialog box will prompt,and just simply find the Microsoft windows  common Controls...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: ToolBar, Vb6 Controls, Visual Basic 6.0

this is the very basic way on how to use the DATEPART function in vb6,to retrieve the day,month,year passed to the current date: CODE: Print "Days: " & DatePart("d", Now) Print "Year: " & DatePart("yyyy", Now) Print "Month: " & DatePart("m", Now) Print "Quarter: " & DatePart("q", Now) Print "Weeks: " & DatePart("w", Now) Print "Hour: " & DatePart("h", Now) Print "Minutes: " & DatePart("n", Now) Print...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: VB6 Functions, Visual Basic 6.0

This sample code will show you on how to Replace a string on a Text-box Control using the   Replace Function and the code will done like this: Add  1 Text-box Control and 1 Command Button at the Text-box,Text property Put a Letter A and put this code under the Command Button Click Event Text1.Text = Replace(Text1.Text, "A", "B") 'this will Replace the letter A on the Text-box Control with Letter B, Hope you get the...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: TextBox, VB6 Functions, Visual Basic 6.0

This is my first sample program using Visual Basic 2010 because i want to upgrade to Vb2010 from Vb6.0 and i hope you like it, this is a Simple program that generate 3 Random Numbers on a label control,and compute the price on each combination,on this program i used the Calling method,the Val function,If and Else Statement,the simple use...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Visual Basic 2010

Generating Random Numbers in Visual Basic 2010 is similar on how to Generate Random Numbers in Visual Basic 6.0, first you must add 1 button and 3 labels on the form then create a Sub Procedures named Randomize that shown in the code below: 'place this code on your button click event Call Randomize Sub Randomize() 'this is your random number generator         lbl1.Caption = CStr(Int(Rnd() *...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Visual Basic 2010

this is the basic way on how to generate a Random Numbers in VB6, Just Add 3 Label Control named it with lbl1,lbl2,lbl3 and 1 command button, and create a Sub Procedure and call it vial click event of your command button and the code will look like this: Private Sub Command1_Click() Call Randomize End SubSub Randomize()         lbl1.Caption = CStr(Int(Rnd() * 10))        ...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

1 comment

Tags: Visual Basic 6.0

this is my sample program on how to Insert, Update, and Delete Via your database: theconnection is Done through system DSN, before running this program first create asimple DSN connection via control panel,if you have no idea on how to create a DSN Connection just follow this Link How to  create a System DSN of MS Access,follow...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Database, Simple application, Visual Basic 6.0

This is the basic way on how to display data on a List View Control in Visual Basic 6.0, First you must Add the control Project > Components > Microsoft Windows Common  Controls  6.0 (SP6), then drag the List view Control: at the general tab, at View: select the Report View: Here the sample Code: 'Declare a variable that holds for ListItem Dim Panoy As ListItem 'set the listitem shown in the code below   ...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

3 Comments

Tags: Database, ListView, Vb6 Controls, Visual Basic 6.0

this time i will show you on how to capitalize every first letter of a word in a Text box Control, follow the codes below: This code will write on a module as a function just copy and paste on a module Public capT As Object Public Sub cap(frm As Form) cr = vbCrLf For Each capT In frm.Controls  If TypeOf capT Is vkTextBox Then  t = capT.Text         If t <> "" Then         ...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: TextBox, Vb6 Controls, Visual Basic 6.0

This sample tutorial is showing you on how to add an icon or image on a List-view control on your own program: 1.) you must Add Microsoft Windows Common Controls  6.0 (SP6) , to simply add a   List-view Control and a  Image-list Control: 2.) set up the List-view Control on your form and also a  Image-list Control, to...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: ListView, Vb6 Controls, Visual Basic 6.0

"Imagelist must be initialized before it can be used" if you got this error message, your   imagelist is need to initialized first before declaring it for the certain used.for example if the imagelist is used as a image container for a Listview control so before you declare it via this code:     panoy.smallicon=1 with out initializing imagelist,you always got this error so to avoid this kind of error you...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Vb6 Controls, VB6 Errors, Visual Basic 6.0

Hello guys this time i will discuss it to you on how to solved this error CANT FIND  PROJECT OR LIBRARY, this is error will usually encounter, if there are missing REFERENCE on your project, to solved  it just go to  Project Tab>Reference> then unchecked all the listed  Missing Reference. on my case, i encounter this error when i reformatted my laptop and i  run my projects, the error dialog box...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: VB6 Errors, Visual Basic 6.0

This sample line of codes will show you on how to filter all the special character on your keyboard that will inputted by the user, this is very important to avoid the typo error, so we want to trap it via this code If KeyAscii >= 1 And KeyAscii <= 7 Or _        KeyAscii >= 9 And KeyAscii <= 47 Or _        KeyAscii >= 58 And KeyAscii <= 64 Or _       ...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: VB6 Functions, Visual Basic 6.0

Here the Following steps on how to create Table on your SQL Server 2005 On your Database that you Created just click the cross box to view it on a hierarchical form shown on  the image below, by creating database just follow this link How to Create a Database on SQL Server 2005, then on the Tables just simply right-click  and press New...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Database, SQL Server

this is the basic steps on how to create your own database on your SQL Server 2005 At the Object Explorer window just right-click the database then click New Database like shown on the image below. After pressing the New Database this will prompt the New DatabaseDialog window, at obviously your database name Database...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Database, SQL Server

this code will show you on how to calculate the difference of  two dates like for example 1 0/10/2010 to 10/01/2010 to find the lapsed day we use a Date Diff function that is  built in VB6 so the code will look like this: Label1.Caption = DateDiff("d", #10/1/2010#, #10/10/2010#) at this code i display the output on a label control did you notice that the Date Diff function i s there,since i am looking for  day lapsed...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: VB6 Functions, Visual Basic 6.0

Hello guys this is the basic way on how to simply Create a Stored Procedure in Sql Server 2005 just follow the Steps that shown on the Image below Click Database then ...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Database, SQL Server

This is the basic Code for Nested IF Structure in vb6 Dim Adrian, Panoy As Integer Adrian = Val(Text1.Text)'holds the value of text1 Panoy = Val(Text2.Text)'holds the value of text2     If Adrian = 100 Then ' if  Adrian=100 then it will  to the next if         If Panoy = 100 Then 'if Panoy=100 then msgbox Prompt            ...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Control Stuctures, Visual Basic 6.0

This the Basic code of Do Loop Until in Vb6 Private Sub Command1_Click() Dim Adrian As Integer 'holds the Value of 1 to 10     Adrian = 1'set the value to 1     Do         Print Adrian ' print the value             Adrian = Adrian + 1 ' increment by 1 from original value    Loop Until Adrian =...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Control Stuctures, Visual Basic 6.0

this is the basic code of Do While Loop Structure in VB6 this structure is similar to Do Loop While Structure Private Sub Command1_Click() Dim co As Integer         co = 1'set co to 1               Do While co <= 10                    Print co 'print the value...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Control Stuctures, Visual Basic 6.0

This is the Basic way on how to do the coding of Do Loop While Structure in VB6 this condition will print vertically 1 through 10 Private Sub Command1_Click()    Dim co As Integer       co = 1 'set the value of co to 1             Do                  Print co...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Control Stuctures, Visual Basic 6.0

this is the basic code of Selection Structure Dim Adrian as Integer Adrian=Text1.Text Select Case Adrian    Case Val(Adrian) > 100         MsgBox"You Enter Greater than 100"   Case Else       MsgBox"You Enter less than 100" End Select Happy Cod...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Control Stuctures, Visual Basic 6.0

This is the Basic way on how to add Data Environment on your Visual Basic 6.0 and adding some commands for your database data manipulation for data reporting 1.) You must go to Project>More Active X > Data Enviroment like shown in the image below 2.) then it will Look like this 3.) to create a connection...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Database, Visual Basic 6.0

Hello guys this single line of codes will show to you on how to connect your database via System DSN connecting your database is very use-full because you can Easily locate your database and open it through your VB6 without typing a lot of Code>>> NOTE Make sure that you Add a Active X data Objects tobuild a Database and Record-set Connection Dim Conn As Adodb.Connection Private Sub Form_Load()      ...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Database, Visual Basic 6.0

This is a few steps on how to Create a System DSN of SQL Server Locate your Control Panel then Click Administrative Tools Then Click Data Source (OBDC)   Click the System DSN Tab then click ADD button hen Locate for the SQL Driver named SQL Server then click Finish then...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Database, SQL Server

This is a few steps on how to create as System DSN of a MS Access Database Locate your Control Panel then Click Administrative Tools Then Click Data Source (OBDC) Click the System DSN Tab then click ADD button then Locate for the MS Access Driver name...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Database, MS Access

This basic and a single line codes will demonstrate to you on how to Format in a Currency form a General Number type like 123456, it will be done  like this      Format$("123456","#,##0.00") So the Output is 123,456.00 it turn into Currency Form in the Other hand you can Insert a single letter in this format like for example,my Currency Symbol is P, it look like this     Format$("123456","P...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Strings and Date Formatting, Visual Basic 6.0

A selection structure is used yo choose among alternative courses of action or instruction. Like for Example the if the Required Number is greater than 50,so we can coded it like this: If NumberOfPeople >50 then  MsgBox"You Meet the Number of People"   Else   MsgBox"Sorry!,You Did Not Meet the Number of People"End If the  pseudo-code of this is If the number of people is greater than 50   ...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Control Stuctures, Visual Basic 6.0

Hello guys this sample code,i will show to you on how to use a Boolean Data Types on your own Visual Basic Program first you must Declare it,whether on a Module for the user can access it or used it all the time, or in a Control Event like Load,click,Mose-move event etc...  we can code it like this Public Adrian As Boolean or Dim Adrian As Boolean Note: Boolean Data Types can only Holds aTrue And False Statement We...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Data Types, Visual Basic 6.0

Hello guys this is my sample Library Management System, this will do the basic task of a School Library System Features>>...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

1 comment

Tags: Database, Simple application, Visual Basic 6.0

This is my simple project Hotel Reservation and Billing System,it can do the basic Process of a Hotel Management ...

Continue Reading with Borgy's Blog »

These icons link to social bookmarking sites where readers can share and discover new web pages.

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

0 Comments

Tags: Database, Simple application, Visual Basic 6.0