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