This is the basic steps on how you to select your own start-up form or Object(s) or run your program that can read first  the Sub Main which some programmer's store or write their main connection from their database , so here where to start with:                        ...

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 6.0

...

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 2008

How done it with code?, just check the code belo...

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 6.0

This is a simple way on how to Attach and Detach Database on your SQL Server, to work with it just follow this few step's: here where to Detach your Database, just right-click on your database then click Task, and hit Detach and your done 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: Database, SQL Server

Hello guy's, at this time i will show you on how to make or create a MDI child in VB 2008 so this is a simple line of code that will saved your day on how to deal with this, situationfirst thing to do is Add MDI Parent on the Project Tab or if you want not to Add MDI parent, just Adding to forms, that way is fine, so the code's will look like this:         Form1.MdiParent = Me  ...

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 2008

This sample tutorial will demonstrate to you on how to change or convert the text content of a text box control in VB6 on a special character like Asterisk(*) or any special character you want to, this is method will commonly used on hiding the cha- racter for confidential purposes, like user's Password for any computer's System, there are...

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, Visual Basic 6.0

Are you encounter this kind of error?, if you, you are in the right place at the right time, this error says Violation of Primary key, obviously the problem is on my database, that also indicated on the error dialog, 'dbo.BO' is my database name on my SQL Server, so the main problem is when i'm trying to INSERT a duplicate...

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, Visual Basic 6.0

...

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: ListView, Vb6 Controls, Visual Basic 6.0

Hello Guys, at this time i will share to you the code on how to highlight all the text box content when you set the mouse cursor on it, like shown at the image below at the Text Box Got-focus event just place this two basic lines of Codes Textbox1.SelStart = 0 Textbox1.SelLength =  Len(Textbox1.Text) and you're done,...

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 will demonstrate to you on how to Add MDI Form on your Visual Basic 2008, to do that just follow this few steps below:                                                  Figure 1.0 ...

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: MDI Form, Visual Basic 2008

Hello Guys, At this time i will show to you on how to execute or call a stored procedure of SQL Sever, here we go>>>>>>>>>> Make sure that your Database Connection and Command, like shown at code below Public MrCmd As ADODB.Command 'just put it on amodule Public Conn As ADODB.Connection i declare MrCmd as my ADODB.Command and Conn As ADODB.Connection as Public for me to access or use it every-time...

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, Visual Basic 6.0

If you are getting trouble on this kind of error prompting  Run-time error '-2147217900 (80040e14)' Syntax Error or Access Violation like shown at 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: Database, SQL Server, Visual Basic 6.0

If you encounter this kind of error on your SQL Server while you are attempting to connect or logging in on your server, getting this error message shown at the image below, the only reason of this, your Database Engine Service Status is Stopped you are in the right place at the right time, all you have to do is go to SQL Server...

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: SQL Server, SQL Server Errors, Tech. Support

To Configure your IIS, just follow this few steps and saved your day in trouble Note: Before do this following steps you must insert first your Windows XP installer on your DVD or CD drive first you have to do is go to Control Panel and click the Add Remove Programs Icon asyou can see at the image above, and this is the second scena...

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: Tech. Support

Hello guys, this is a sample tutorial on how to load or integrate a .RTF file on your VB6 program, all you have to do is to Add a Components named Microsoft Rich Textbox Control 6.0(SP6), like shown at 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: Rich Text, Vb6 Controls, Visual Basic 6.0

Hello guys at this time i will show to you on how to convert your MS Access Database to SQL Server Database, to do this, just follow those few steps below. on your MS Access database, go to Database Tools, go to Move Data tab, then click SQL Server then the Up-sizing wizard will prompt, allowing you to use an option,...

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, SQL Server

Since OCX files is little bit important to us, as  a programmer, for some reasons, so i will show to you on how register an OCX files:   go to Run then type Regsvr32  then follow by the Path or the Directory of your OCX file, then click O...

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: Tech. Support, Visual Basic 6.0

This sample steps will show to you on how to make your hidden files or folders visible at the figure above, you can simply open My Computer, then go to Tools Tab, then click  Folder Options Then Folder Options Property Pages will prompt, just select the View Tab, then find Hidden Files and Folders,...

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: Tech. Support

If you are encounter this error, says "Run-time Error '380', "Invalid Property Value" at my case i encounter this , when i used a List-view control, the cause is when i forgot to create another column  for the List-view control, instead of declaring like this: Format$(LvLoans.ListItems(ako).SubItems(2),"General Number") i declare like...

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 Errors, Visual Basic 6.0

This sample tutorial will demonstrate to you on how to create a Menu Bar in Vb6 and also creating a Sub Menu on a Menu Bar: Tip: On creating a Menu and Sub Menu, the most used transaction menu module must be at the first line on a Menu and Sub Menu's so we can do this like shown on the image below: 1.) You can simply...

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: Menus, Visual Basic 6.0

After exploring the Visual Basic 6.0 Data Report, i found out the 3 different printing layout so i want it to share on you on how to do this, first you must install VB6SP6, or download it at Microsoft Website, and it will done through this following codes: DataReport1.Orientation = rptOrientLandscapeDataReport1.Orientation = rptOrientDefaultDataReport1.Orientation = rptOrientPortrait Hope you like it, Happy Coding ^_^ The Hardest...

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 Reports, Visual Basic 6.0

This is my sample tutorial on how you to connect your Crystal Reports on your Visual Basic 6.0, this version of Crystal Reports is 8.5, so here we go............. Just follow those few steps: 1.) Project >Add Crystal Reports 8.5  2.)  if you can't see Crystal Reports on the Project Tab, just Click Components>       ...

Continue Reading with Borgy's Blog »

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

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

8 Comments

Tags: Crystal Reports, Database, Visual Basic 6.0

Hello guys this is my sample database manipulation, using the 3 basic transaction, the INSERT, UPDATE and DELETE like shown at the image below. INSERT: Dim rs As New OleDb.OleDbCommand("Insert INTO Info(F_Name,M_O,SSS,Phic,Pagibig,Tax,Net_Inc) VALUES ('" &StrConv(TextBox2.Text, VbStrConv.Uppercase) & "','" & (TextBox3.Text)...

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, Visual Basic 2010

Hello Guys, at this time i will show to you on how to load a Agent Control in your own program, loading this control is to make your program entertaining specially if you are developing games or to warn the user in animated way, so try to use MS Agent Control, to do this just go to Project tab>Components>Microsoft Agent Control 2.0,...

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, Visual Basic 6.0

Are you getting bored about your Sql Server User Log-in?, at this time i will demonstrate to you on how to add a new User Log-In on your Sql Server,by the way the default user log-in on the Sql Server Authentication mode is "sa", so we want to do is try something new so to do this, just follow those few steps below and those will saved your...

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: SQL Server

To do this,first you must add this control to your  form layout , just right click the tool box pane, at the pop up menu just click components,and the Control  Dialog appear,then hunt Microsoft FlexGrid Control (SP6),then mark check the box then hit the Apply button,finally Microsoft FlexGrid Control (SP6) is on your tool box,just...

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: MS Flexgrid, Vb6 Controls, Visual Basic 6.0

" [Microsoft][OBDC SQL Server Driver][SQL Server] the normal parameter "@Status" was not declared as an an OUTPUT parameter,but the actual parameter passed in requested output " This error will get you in trouble????????????????? at my own experience this error comes out when i call a stored procedure on my SQL Server database and after compiling it this error will appear saying those message,i double check my code then traced...

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, VB6 Errors, Visual Basic 6.0

Hello guys have a good day to all who is reading this article, go back in the problem " oledb  exception was unhandled " i encounter this type of problem when i worked at the database this little error will prompt to me,and i wonder why this error will come out,i double check every single of my code then i found out the only problem is the  spelling of a column name on my database instead of ID_Num i wrote only ID, after...

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 2010, Visual Basic 2010 Errors

Hello guys,at this time i will show to you on how to connect a MS Access Database on  Visual  Basic 2010, make sure that your database is inside of the Debug Folder created by  Visual Basic 2010,then the codes will look like this: Public Class Form1  Dim con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = |DataDirectory|\Panoy.mdb;") End Class first you must establish the 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, MS Access, Visual Basic 2010

" Item cannot be found in collection corresponding to  the requested name or ordinal " Hello Guys,if  this error will came out when  youre running your program, the cause of this problem is on your database or on your procedure on how you to fetch the data from the database,here a sample procedure that makes error when fetching data from database:         With Lv1        ...

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, VB6 Errors, Visual Basic 6.0

"Msg 102, Level 15, State 1, Procedure Holidays, Line 19 Incorrect syntax near '@App_By'." This Error come out when i wrote a simple stored procedure at m...

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, SQL Server Errors

I think this simple program will saved you on your work and get an idea about the smart searching,this will saved your day,because of its nice searching effects,like what we experience on  Google search engine; Download sample of Smart Search Hope you like it ^_^ The Hardest Thing to do is to Do Nothing ...

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 Flexgrid, Visual Basic 6.0

"Application uses a value of the wrong type for the current operation" This error will appear on your current environment specially if you are working Sql Server  stored procedure and call it via VB6. To fixed this problem, you can double check the Data  Type fields on your database and make it sure that you assign it on their respective...

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, Database, SQL Server, Visual Basic 6.0

Hello guys,this is sample code on how you to generate a Auto-Generated ID Number or a Primary Key, because many programmers like me are want the ID Number or Primary Key become Dynamic, so we can do the basic solution like this: In my case i put it on a Sub Procedure that i placed it on a Module,so the this is the Code: Sub EmployeePosition_ID()Set rs=New Adodb.Recordset    If rs.State = adStateOpen Then rs.Close       ...

Continue Reading with Borgy's Blog »

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

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

5 Comments

Tags: Database, VB6 Functions, Visual Basic 6.0

[MICROSOFT][OBDC Sql Server Driver][Sql Server] procedure or function (Get_Emp) expects parameter  '@empid',which was not supplied I encounter this error when i call a stored  procedure from my SQL SERVER database, the cause of this error is when i forgot to declare the parameters of my stored procedure that supposedly declaring like this: Mycmd.Parameters.Append _Mycmd.CreateParameter("EmpID",Advarchar,AdparamInput,...

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, Visual Basic 6.0

Hello guys,this time i will show to you, the use of  DateAdd Function, this function will use for adding day(s) to a given date, for example i want to add 5 days on this given date   "2/7/2011",so obviously we want the answer become "2/12/2011", to get this answer,just simply follow this code: DateAdd("d", 5, "2/7/2011") since i am dealing with day(s) to add, this will represent with "d" if you want to add a month(s),...

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 is the basic way on how to subtract the minutes elapsed on the given time. for example i have a time 12:00 PM and 1:00 PM so we can solved the elapsed time by using  DateDiff function, so supposedly the answer is 60 mins. so enough words, the code will look like this: DateDiff("n", "12:00 PM", "1:00 PM") the "n" there is represent the minutes value its similar on how to get the day elapsed that represents by "d": Note:...

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

First you must add the component named Microsoft Windows Common Control(sp6), at the  Project Tab>Component or just simply right click the tool box then the pop-up menu will appear. after adding the components just drag it on your form window then right click on the list view control,then click properties,like shown...

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

This is a sample process of Sales and Inventory system that monitor the process of one Department store,all those process in this program is a basic process of one Department Store,if you want this system just download it Below: Happy Coding!!!! The Hardest thing to do is to do nothing!!!! Download sam...

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

To do this, you must add first a component go to PROJECT>COMPONENTS>Microsoft Windows Common Controls SP6, then add tool bar on the form, and follow the steps on the image below: 1.) Right-click the tool bar and click properties at the Caption text property just write,for example Reports and at the Style: 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: ToolBar, Vb6 Controls, Visual Basic 6.0

This is the very basic way on how to code or create your own timer using VB 2010, you must add 2 Labels Control and 1 Timer control and also a 3 command button for you Handle whether you want to start,stop and reset So this is the main code for you set up and get the output shown  in the image above, i used the very...

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, Visual Basic 2010

This is a sample code on how you to easy Calculate the sum of a list-view column this is my way on how to do this,determine the listview count, i used FOR LOOP,the most powerful loop among the loop structures and it will show you like shown in the image below: so here we go,the code will look like this: Dim 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: ListView, Vb6 Controls, Visual Basic 6.0

"Data Type Mismatch in Function Object " Solved After i encounter this error message i found that my Data Type on my database is mismatch, because i want to display a Currency type on a data report of my project which is a current data type is varchar(50) so obviously Data Type Mismatch so i found my own solution by changing the Data Type to Float, for me to display a sum of my database field on my data report through the used...

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 Reports, Database, VB6 Errors, Visual Basic 6.0

This code will teach you on how to load a picture or image on a Picture Box Control from your hard drive,the basic and simple code will look like this: Private Sub Command1_Click()    Picture1.Picture = LoadPicture("E:\Button Cancel copy.jpg") End Sub Hope this will help your simple Problem!Happy Coding ...

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: Picture Box, Vb6 Controls, Visual Basic 6.0