Sales and Inventory System for Computer Sales Store

Submitted by jonseguin on Wednesday, January 13, 2010 - 02:36.

Language

Sales and inventory system - manage incoming and outgoing stocks, sales ordering and quotation, inventory reports, etc.

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

very clean code.. 5 stars

very clean code.. 5 stars from me

I agree sir. After I finish

I agree sir. After I finish my IT I'll submit all my works but not now hehehe. All I can do is to help others ^_^ 10/10 for me

HELP!!!!!

Sir i had read your comment, I'm an Computer Science student, i need help about my database propose system which is pet shop sales and inventory system... my teacher would like to see it using visual basic programming language, but i have no back ground about it... A help would be appreciated sir... thanks in advance .

Thesis

Sir can you help us on our IT Project :Inventory System of RTW ,vb 6.0 and MS access as the backend

odbc error

WHEN I LOG-IN RUN-TIME ERROR [MICROSOFT][ODBC DRIVER MANAGER] DATE SOURCE NAME NOT FOUND AND NO DEFAULT DRIVER SPECIFIED

Age Count

Please help me how can i Count my Age like as Birth Date 01/01/1989 End date 13/01/2010 Year= Months= Days= Prog Vb 6.0

More projects soon

I got a lot of finished projects to be posted soon such as biometric applications, point of sale, school management, payroll, courier management. I haven't finished preparing them yet because i'm still loaded on my current clients. anonymous - try this one Private Function Compute_Age() As Long Dim y As Long, BirthDate As String BirthDate = txtDOB y = DateDiff("yyyy", BirthDate, Date) If DateDiff("d", Day(BirthDate) & "/" & Month(BirthDate), Date) 0 Then Compute_Age = y - 1 Else Compute_Age = y End If End Function hope it helps.

Hai sir

What software language i will use to run that code sir?????? i will use VB sir? or what?? ask lang po. . .

just use vb 6.0 in able to

just use vb 6.0 in able to run the codes. :)

I like to be a programmer....

I like to be a programmer.... i want to study .net.. can u give a site where i can download sample program so i can explore it.

error found in the code

error found in the code why?????? rs.Open sql, conn, adOpenForwardOnly, adLockReadOnly

help

anong mali dito? rs.Open "SELECT DISTINCT TOP 5 * from tbl_sold Where qty > 5 Order by Desc", 1, 2 mar error ksi, gusto koi mkuha ung fast moving item using ms sql server na backend

help

copy mu yan sql statement mu tapos paste mus sql pane pra mlaman mu if ano error

kulang..

kualng ng connection rin kea ng error.. rs.open"string",con,1,2 ung con ung connection mo sa database...tama ba?^^,

code

hello po! What is the username and password? Thanks

username:admin password:admin

username:admin password:admin you can check the table ref_user, dun kasi nakastore ung user informations though its not encrypted.

I need this project details please‏

Hello sir, i am a final year student and also working on computer sales and inventory system. could you please help me with the project report of your project. could you please mail it to me on [email protected] thank you i will be wating for your mail.. Amit

How to create and connect database script with this project

Hi.. As i am new to VB6.Can u pls tell me how can i create database from script file and attach it with this project..?? I have already create a database in sql2005 using your script but nw dont know how to connect it with project. Pls help..

cancel na lang po eheh

na connect ko na ung database sa dns lang pala ung mali tnx for this nice system tho

How to create and connect database?

Hello Sir, I am tried to pen this project but unable to create the database. Can u please tell me how can I create database from script file and attach it with this project..?? I have Sql server 2005 & vb6.0. It's good project I would lean many more Please help me on this problem.

imDB with code insql2005

db code insql2005

Hi

Hi, I have created the datatbase but when i run the projects it does not connect the database. Can u pls guide me how to connect the database. Thanks Jay

salamat

salamat sa site na ito thums up!! boss tnx

what database should i

what database should i connect in a ordering system??

GOT ERROR

WHEN I LOG-IN RUN-TIME ERROR [MICROSOFT][ODBC DRIVER MANAGER] DATE SOURCE NAME NOT FOUND AND NO DEFAULT DRIVER SPECIFIED

help me how to run this program

WHEN I LOG-IN RUN-TIME ERROR [MICROSOFT][ODBC DRIVER MANAGER] DATE SOURCE NAME NOT FOUND AND NO DEFAULT DRIVER SPECIFIED

error

rs.Open sql, conn, adOpenForwardOnly, adLockReadOnly yan po ung lumalabas na error eh

HELP ME

HOE TO CREATE A SIMPLE WEB SITE NG SALES AND INVENTORY.. PLS PASS A CODE....... USING HTML AND CSS.. THNKS

connect error

Dear Sir, Thanks for the project first. Sir I have installed mysql database for sales and inventory for computer hardware. But It is not running properly after writing the connection code and provide error in the login form in rs.open in login click. So please update with the code for connection with the database will help me to use in my computer sale store. I shall really grateful if u do it and also if you have any project completed for point of sales and inventory and mail me. Thank You again for the project again. Enam email :- [email protected]

sir, when your next project

sir, when your next project will be posted ? Really I am looking forward your next projects from which. I can learn lot. Thanks.

Pls help me code remove

Pls help me code remove button in DataGrid. I want to minus the price(total amount field) of the item i want to remove (when clicked the remove button) and show it on a textbox (total cost). I have a datagrid (connected on a database in access), remove button (command) and a textbox (total cost)

hai keyjey_06

hmmm y not to use listview rather than data grid?

sir

i encounted to much error i cant run your program....

Repost ERROR

WHEN I LOG-IN RUN-TIME ERROR [MICROSOFT][ODBC DRIVER MANAGER] DATE SOURCE NAME NOT FOUND AND NO DEFAULT DRIVER SPECIFIED

thesis_dsn

ano po use ng thesis_dsn? pa answer nman po please asap

I want a demo in video tutorial

cant log-in

can you help me...if you still exist. please. i realy realy need it so bad!

I have a error this project

I have a error this project, Errors during load.Refer to C:\InventorySales\Forms\MAIN.log'for details

BEAUTIFUL CODE

I LIKED YOU CODE AND THE INTERFACES GENERALLY YOU WORK IS GOOD ,YOU USED THE FUNCTION, CLASSES WELL ,CAN PLEASE SEND THE DATABASE SCHEMA IF POSSIBLE IN ACCESS I WOULD LIKE TO EXPLORER FURTHER WITH YOUR CODE THANKS NOTE;we have the same programming style so it was not hard to underfstand your code

how can i connect it

i already run the query at mysql but i can find the provider and data source name??how can i connect it ?? please help

can i get computer shop

can i get computer shop inventory management system on c++?!

can't login

I can't log in sir,,.Open sql, conn, adOpenForwardOnly, adLockReadOnly this is the error appears.Thanks sir..your reply is so much appreciated.

Good day Lornie, you can

Good day Lornie, you can never login because the public conn variable declaration is erroneous (it is in modMain BAS Module). The said variable should be declared as an ADODB.Connection Object not as String. To fix this, here' how: 1. Modify the Public conn As String declaration into Public conn As ADODB.Connection. 2. Open the Main MDIForm code module. In Private Sub MDIForm_Load(), comment out the code conn = "thesis_dsn" by placing a single quote character (') in front of it. Type the following code just below the commented code:

    Dim connStr     As String
    
    Set conn = New ADODB.Connection
    connStr = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;UID=root;DATABASE=inventorysalesdb;PORT=3306"
    conn.CursorLocation = adUseClient
    conn.ConnectionString = connStr
    conn.Open

Note: Use MySQL 5.1 ODBC Connector and make sure your MySQL Database Server is compatible with the connector. Provided you have correctly installed the database, you should be able to login using the following account details: Username: ADMIN Password: ADMIN Magandang araw and good luck. If you wish to learn more about this program or just anything about the programming language (VB 6.0) used to create this application, please feel free to contact me (+639176951738).

Add new comment

Add new comment
1220 views