Archive for the ‘Visual Basic 6.0’ Category

Mysql in visual basic Sample Source Code

Posted by rodolfo_panganiban on 21 January, 2010
No comments yet
This item was filled under [ Database, FREE SOURCE CODE DOWNLOAD, Programming, TIPS AND TRICKS, Visual Basic 6.0 ]
    


  1. 


    'Here I create a variable named MySQL as a new connection object for MySQL
    



    2. 




  2. 


    Global MySQL As New MySQL_CONNECTION
    



    3. 




  3. 


     
    



    4. 




  4. 


    Private Function MySQL_Connect() As Boolean
    



    5. 




  5. 


    Dim res_MySQL As MYSQL_CONNECTION_STATE
    



    6. 




  6. 


     
    



    7. 




  7. 


    MySQL_Connect = False
    



    8. 




  8. 


    res_MySQL = MySQL.OpenConnection("server", "username", "password", "database", 3306, CLIENT_COMPRESS)
    



    9. 




  9. 


     
    



    10. 




  10. 


    If res_MySQL = MY_CONN_OPEN Then
    



    11. 




  11. 


      MySQL_Connect = True
    



    12. 




  12. 


    End Function
    



    13. 




  13. 


     
    



    14. 




  14. 


    ' Query -> MySQL query to execute.
    



    15. 




  15. 


    ' CloseRS -> Optional. Close recordset created after executing Query.
    



    16. 




  16. 


    ' RS -> Optional. Reference to externaly created variable, declared as MYSQL_RS. If not closed, it will be available to the program after the query is executed.
    



    17. 




  17. 


    ' lAffected -> Optional. Numer of rows affected after te Query.
    



    18. 




  18. 


    Public Sub SQLQuery(ByVal Query As String, Optional ByVal CloseRS As Boolean = False, Optional ByRef RS As MYSQL_RS, Optional ByRef lAffected As Long)
    



    19. 




  19. 


      Dim ERR As MYSQL_ERR
    



    20. 




  20. 


     
    



    21. 




  21. 


      Set RS = MySQL.Execute(Query, lAffected)
    



    22. 




  22. 


      Set ERR = MySQL.Error
    



    23. 




  23. 


     
    



    24. 




  24. 


      If ERR.Number <> 0 Then
    



    25. 




  25. 


        ' Handle any eventual errors that occurred during MySQL query
    



    26. 




  26. 


      End If
    



    27. 




  27. 


      ERR.Clear
    



    28. 




  28. 


      Set ERR = Nothing
    



    29. 




  29. 


     
    



    30. 




  30. 


      If CloseRS Then
    



    31. 




  31. 


        RS.CloseRecordset
    



    32. 




  32. 


        Set RS = Nothing
    



    33. 




  33. 


      End If
    



    34. 




  34. 


    End Sub
    



    35. 




  35.  Continue reading...
    36.
Tagged with: [ ]

Hotel Management System (VB6 Source Code)

Posted by rodolfo_panganiban on 6 January, 2010
1 comment so far
This item was filled under [ Complete Application System Source Code, FREE SOURCE CODE DOWNLOAD, Visual Basic 6.0 ]

ABC Hotel Management System (VB6 Source Code)

ABC Hotel Management System (VB6 Source Code)

ABC Hotel offers accommodation, meals and other services to local and foreign guests. It also offers additional facilities to individuals or groups. When a Guest arrives at the receptionist, his personal details are first entered and then he selects one of the available unoccupied rooms depending on his/her taste.

Continue reading…

Tagged with: [ ]

Accounting System Source Code In VB6

Posted by rodolfo_panganiban on 28 December, 2009
No comments yet
This item was filled under [ Complete Application System Source Code, FREE SOURCE CODE DOWNLOAD, Visual Basic 6.0 ]

Accounting System Source Code In VB6

Accounting System Source Code In VB6

 

This software handles 4 main parts of Accounting Cycle i.e  General Journal/Ledger, Balance Sheet, Trial Balance, Income Statement, (with Transactions) This is my first posting on PSC. I had to make a project on Accounts Management. I Continue reading…

Tagged with: [ ]

Inventory and Account Receivable System (RE-UPLOADED)

Posted by roynaparan on 28 December, 2009
7 Comments
This item was filled under [ Complete Application System Source Code, Visual Basic 6.0 ]

pic2005105125472724 Inventory and Account Receivable System (RE UPLOADED)

A Complete Inventory and Account Receivable System – This is an inventory and account receivable system project which I made some of my client here in Philippines.The program uses ADO and have lot of functionalities. The program can be able to run using keyboard,track user updates and etc. If you download this program you will learn the fallowing:(1) Know how to use ADO in real world business software. (2) Know how to handle millions of records using paging techniques.(3) How to use listview in database programming. (4) How to use flexgrid in creading a Master Detail form. (5) How to use crystal report (6) How to how to design a good looking software. (7) You will learn how to use custom define procedures and functions to optimize your codes. (8) You will learn the used of string and file manipulation in real world. (9) The used of API in real world database programming.There is a lot more to learn from this code… so download it and share your comment on what you have learn. Please don’t forget to vote! I CONSIDER YOUR VOTE AS ONE WAY ON HOW YOU WILL ACKNOWLEDGE MY WORK!! have a nice day and GOD Bless :-) -Philip

Continue reading…

Tagged with: [ ]

Cybera is an Internet cafe administration / management system (VB6)

Posted by rodolfo_panganiban on 26 December, 2009
No comments yet
This item was filled under [ Complete Application System Source Code, FREE SOURCE CODE DOWNLOAD, Visual Basic 6.0 ]

Cybera is an Internet cafe administration / management system

Cybera is an Internet cafe administration / management system written in Visual Basic 6.0 (VB6). It works with prepaid cards or client accounts or in a post paid Self Service mode. Features include workstation control, user rights lockdown, accounting, stats and screen replication for client application interface.

Continue reading…

Tagged with: [ ]

Vb6 simple Add, Edit, Delete, Search in Database (MS Access)

Posted by rodolfo_panganiban on 21 December, 2009
No comments yet
This item was filled under [ FREE SOURCE CODE DOWNLOAD, General Programming, Visual Basic 6.0 ]

Vb6 simple Add, Edit, Delete, Search in Database (MS Access)

Vb6 simple Add, Edit, Delete, Search in Database (MS Access)

 

This is a very simple program using VB and MSAccess. This code will allow you to Add, Edit, Delete, and Search entries in the database.

Continue reading…

Tagged with: [ , , , ]

Free Accounting Software Source Code in VB6

Posted by rodolfo_panganiban on 19 December, 2009
No comments yet
This item was filled under [ Complete Application System Source Code, FREE SOURCE CODE DOWNLOAD, Visual Basic 6.0 ]

Free Accounting Software Source Code in VB6

Free Accounting System Software Source Code in VB6.Simple and efficient Financial Accounting Software for small businesses. With Multi company and muliple financial year support. Instant Reports. No codes required for account folios. Built in back up and restore facilty . zip file contains complete source code. This source code contains 35 forms and 2 modules. For Database access, I have used ADO in this application. Database can be any odbc data source. You can use Foxpro, Microsoft Access,SQL Server or Oracle. Database Table structures are published. Continue reading…

Tagged with: [ ]

Accounting Software Code with Balance Sheet in VB6

Posted by rodolfo_panganiban on 19 December, 2009
No comments yet
This item was filled under [ Complete Application System Source Code, FREE SOURCE CODE DOWNLOAD, Visual Basic 6.0 ]

Accounting Software with Balance Sheet

Accounting System Software Code with Balance Sheet, Cash Voucher  Book, Bank Book, Journal Book, Combined Book, Trial Balance, Profit and Lost Statement(P/L), List of Account

Continue reading…

Tagged with: [ ]

Car Garage Service and Inventory System

Posted by rodolfo_panganiban on 16 December, 2009
No comments yet
This item was filled under [ Complete Application System Source Code, FREE SOURCE CODE DOWNLOAD, Visual Basic 6.0 ]

Car Garage Service and Inventory System

Complete Car Garage Service and Inventory System application. Customers Database, inventory system, Customer Service, search database records, cool gui, Debtors alert, password protected. This application is suitable for a car shop. Whenever the mechanic finish a job on a car the only thing he has to do is to use the service wizard and select the parts he used from a list and the number of the parts. Continue reading…

Tagged with: [ ]

Library Management System (Updated)

Posted by roynaparan on 12 December, 2009
3 Comments
This item was filled under [ Complete Application System Source Code, FREE SOURCE CODE DOWNLOAD, Visual Basic 6.0 ]

Library Management System (Updated)

This Library Management System is for the beginners in VB 6 like me. It has a card catalog system, indexing, book inventory and profiling. It shows how to connect with your database. It generates reports, receipts and book inventory. Please vote this program. GOD BLESS YOU ALL!

Continue reading…

Tagged with: [ ]