Loading

Sales and Inventory System for Computer Sales Store

Submitted by: 
Language: 
Visitors have accessed this post 58821 times.


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

emond's picture

very clean code..

5 stars from me

emond sabiniano
Project Contractor-Developer/Software Consultant

cidfrey's picture

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

Web / System Developer
Contacts :
09327081978
[email protected] >>> Facebook/YM
ICCT Colleges Cainta Rizal

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 .

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

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

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

jonseguin's picture

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.

To God be the glory

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 run the codes.

:)

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

why??????

rs.Open sql, conn, adOpenForwardOnly, adLockReadOnly

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

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

jaysfall's picture

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

Consultant / .Net Developer

::[email protected]::

+09059769698

hello po! What is the username and password? Thanks

username:admin
password:admin

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

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

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..

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

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.

db code insql2005

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

Jayant

salamat sa site na ito
thums up!!
boss tnx

what database should i connect in a ordering system??

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

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

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

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

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 will be posted ? Really I am looking forward your next projects from which. I can learn lot.
Thanks.

keyjey_06's picture

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)

hmmm y not to use listview rather than data grid?

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

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

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

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..

please mail me on how to use this project please sir! help me......
my mail ID: [email protected]

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

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

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

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 inventory management system on c++?!

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

Oelasor's picture

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:

  1. Dim connStr As String
  2.  
  3. Set conn = New ADODB.Connection
  4. connStr = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;UID=root;DATABASE=inventorysalesdb;PORT=3306"
  5. conn.CursorLocation = adUseClient
  6. conn.ConnectionString = connStr
  7. 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).

Lao Tzu - “Give a man a fish and you feed him for a day. Teach a man how to fish and you feed him for a lifetime.”

Oelasor

good afternoon sir we have a problem in doing our sales and inventory system..please help us about the source code of ordering point

this is my email account..joycek[email protected].hoping 4 your positive responce...
thank u

I download it and its error please fix if you have time to do so...I rate it for 3 stars hahaha..

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.