Point of Sale and Inventory System - VB 6 Version

Submitted by admin on Saturday, November 15, 2008 - 15:12.

Language

Free Point of Sale (POS) and Inventory System.

A must have features:

Barcode support
Point of Sales
Place an order (sales order or purchase order)
Receive or deliver an order by batch
Support for returning of orders
Product inventory according to unit of measures
Run the source code to appreciate the program

Note: Automatic numbering of barcode (field) is used to simulate barcoding system. Just used the correct barcode of the product if you want to use the barcoding system.

Account information:

username: admin
password: a

For the database password please read FAQ.

Download POS and Inventory System v1.0 Installer here.

Note: You need crystal reports 8.5 to run the source code. If you don't have crystal reports you can still open the source code without problem with the ocx by installing the Installer above.

As you may already know, VB 6 is not already supported by Windows 10. So if you have this version, it's better to run a virtual machine like VMWare and install Windows XP to avoid any problem.

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

re: hallo sir hot to change the

Please use the code from the comment below.

Hallo Sir, how to add a

Hallo Sir, how to add a remarks text in to sales reports and how to add remarks text in to sales list in the access

Hello Admin

Hello Admin, how i can add serial nember for the prodects in sales list plz gave me code if you have if iam sale prodects with serial nemder war i can add the serial nember

sending signal back to barcode reader

on the thread: Submitted by Anonymous on Thu, 06/04/2009 - 21:41. you replied: 'My POS supports any barcode reader.' But does your app send a signal BACK to the barcode reader? So your app receives a barcode, validates against a DB and the send OK/NOTOK signal BACK? If so: cool! If not: do you know where to find documentation on how to do it?! Maybe your a bit more of a 'barcode insider' ;) Thanks!

re: sending signal back to barcode reader

I'm wondering about your question. Do you have any problem using a barcode in my app? If yes what it is? So I can help you.

sending signal TO barcode scanner

No, I dont. :) here's the normal process: Your app receives the barcode from a scanner. the barcode is validated against a DB If its found, an OK signal should be sent BACK to the barcode reader indicating the barcode is valid. If its not found a NOTOK signal should be sent to the scanner. My question basically is: where in your app do you communicate a signal TO the scanner instead of receiving the barcode FROM a scanner... I hope this clarifies my question :) Thanks again for your quick reply!

re: sending signal TO barcode scanner

Seems you complicate the whole process. You do not need to know whether the barcode scanner sends an OK or NOTOK signal. This is not an LPT port, or other device which needs to receive an OK or NOTOK command. All you do is validate the character returned by the barcode reader. In this case it is validated in the change event of a textbox control.

Error

Hi sir.Thanks for good work.I have recompiled the code using vb 6.0.I also have crystal reports v 10 and crystal runtime.When I try to run any report,it give an error that there is no physical database but I have already set the database correctly.What might have been the problem please.Thanks.

re: Error

Have you successfully integrate crystal reports 10 with vb 6.0 from other source code? I don't know if there is a compatibility issue with both software, but I haven't tried it. This error was caused by lack of crystal reports runtime library.

What do i need?

Sir, What do i need for This POS system run? do i still need the VB to be Installed?. Coz i haven't Installed VB yet.. if VB is necessary. would it be ok if i use any VB versions for this POS System sir?

re: What do i need?

If you just need the application without the source code then you do not need to install VB.

What do i need?

i think i need to install it.. for editing.. now, can u help me sir on where can i get Crystal Reports 8.0/8.5 for free??. io can't run your system. when i tried to run it it says that crystal reports is missing? according to your previous statement. about .dll thingy. i need or we need to install the crystal reports to run this system.. please help where can i get this Crystal reports. thanks sir..

MS SQL

Hi Sir, Can you help me how can I connect "inventory application" from vb6 in MS SQL database. (through ini file or datalink file or..?) thank of lot. BB.

re: MS SQL

I'm just planning to make a tutorial on how to connect vb in my sql. Comeback anytime for update.

sir pls help

after installing Visual Basic 6.0. and tried to run this POS system and it prompts me with this error message. "Can't find project or library". and when i pressed "OK", "Missing: Crystal Reports 8.5" etc. sir, do you have a installer of Crystal Reports 8.5?. can you give me a link where can i get this missing file for free? Thanks for helping us sir.

re: sir pls help

Crystal reports 8.5 is a commercial software. I don't know if it is legal now to distribute this version. If anyone knows let me know so we can open crystal reports for distribution without violating copyright laws.

POs

sir, do u have other POS System sir.. Pos that can Run without Crystal Report.? and one thing can u give us the code how will i connect our database to our system?.. (microsoft Access).. pls pls pls help us sir.. thank you for helping us.

Migration to sql server 2000 or mysql

Dear sir, I try to migration access on this program to sql server 2000 or maybe mysql.Any suggestion to which i choose ? MSSQL2000 or mysql ? Now on i try ms sql2000,But i always get error 3001 "Arguments are of the wrong type,are out of acceptable range,or are in conflict with one another" what is is mean ? try to debug but error show on recordset 'Procedure used to bind data combo' this is the clue ? Very newbie on programming and database need your adivice,thanks

re: Migration to sql server 2000 or mysql

If I were you I would rather choose sql server 2000 as it is native to vb.net or vb 6.0. But because mysql is a free and open source software sometimes it is worth a try. I don't know when I can make a tutorial for this but sooner or later you will seen it here.

Login problem

Hello, I download "POS and Inventory System v1.0 Installer" After I installed it and select "Db" database, and login with password "a". it is shown "Invaild password, please try again". what is the password? Please help... Thanks a lot!

Pls Help...login problem

Dear Sir, I download "POS and Inventory System v1.0 Installer" After I installed it and select "Db" database, and login with password "a". it is shown "Invaild password, please try again". what is the password? Please help... Thanks a lot!

re: Pls Help...login problem

This is a known issue with the regional settings which you can change from something to English.

hello bro

when open project i find more error MSG like http://img11.imageshack.us/i/hellp2.jpg/ anther MSG http://img18.imageshack.us/i/hellp.jpg/ and i see more MSG NO Stop i wait u bro

re: hello bro

Did you read the readme.html file?

hello

yea bro u read it but why i have that problem bcz i don't have barcode ???? thanx for replay

re: hello

You have to install all necessary files. Read the FAQ.

POS software

Dear Sir, Im Download it, Howto install it

sir Code bout closing or unloading 2 or more forms.

VB Code About Closing 2 or more forms pls.. Ex: Unload me (close the current or 1 form) what about closing 2 or more forms..?? can anyone help me? pls.. thanks..

re: sir Code bout closing or unloading 2 or more forms.

Private Sub CmdClose_Click()
     End
End Sub

re: sir code bout closing.....

sir. i tried that code but it closed only his form.. some other forms or window remain unclosed... what im looking for is code that once it clicks all visible form or windows of the system will close.. some kind of a Private Sub CmdClose_Click() "End all forms or close all forms" End Sub

re: re: sir code bout closing.....

I don't know what you are doing but the code I give you should work. It will shutdown the application so this mean that any open forms will also close.

sir Code bout closing or unloading 2 or more forms.

VB Code About Closing 2 or more forms pls.. Ex: Unload me (close the current or 1 form) what about closing 2 or more forms..?? can anyone help me? pls.. thanks..

Transactions-Cash Sales Return

When i open Transactions-> Cash Sales Return and click on New i get error message "Either BOF or EOF is True,or the current record has been deleted.Requested operation requires a current record". I have not deleted any records from database,what might be the problem ?? Thanks Girish

re: Transactions-Cash Sales Return

I have already answered this question before. Do not click the new button when returning an item. Just click the return button within the form.

Transactions-Cash Sales Return

I also get same error when entering Cash Sales.When i select Stock i get Same error message "Either BOF or EOF is True,or the current record has been deleted.Requested operation requires a current record". Thanks

SIR code again pls.

Sir, Can you pls give us a VB code for the delete button/ cmdDELETE button.. ? Pls Pls Pls. help us. thanks.. here's the sample form of our inventory that needs the DELETE Button codes.. http://img136.imageshack.us/img136/6708/image001caz.jpg we used the Listview to view the Searched Item to be deleted. . Pls help us.. thank you so much..

re: SIR code again pls.

Please browse the tutorial on "Database Programming Made Easy". I included there a tutorial on how to delete a record.

sir pls help

Sir, can you please Give us a VB code for our cmdDelete button? a code that will delete a data from the database (ms access).. our form seems like this >>> http://img229.imageshack.us/img229/7583/image002p.jpg we used the "listview" for displaying the searched item/s and be deleted... note: search and add button is working... so far we need the code for delete button... Please hel sir.. thank you...

manage users

helo po sir, how can we make more than three accounts, i want to add more in the manage users but the application closes, in the source code may error the same happens to the installed one. eto po ang message Run-time error '-214747259 (80004005)': The changes you requested to the table were not successful because they create duplicate values in the index, primary key, or relationship, Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. ano po ibig sabihin nito sir, newbie pa po ako. thanks!

re: manage users

I tested the source code and it does not return any error. May be you are adding the same username. Try different username.

Error

Sir, still have error, i have the screenshot, i can only add 3 accounts but when i add the fourth account i still got this error, see it here >>> http://i530.photobucket.com/albums/dd350/cristin_nor/POS.jpg the one that i installed executable i've downloaded from here will close when i add the fourth account. thanks

re: Error

I will try to debug this program ASAP. Comeback anytime...

re: Error

thank you

Update

Sir good am po, Sir ano po update natin sa code? thanks

Barcode scanner not recognizing the generated barcode from POS

I have downloaded and installed your POS system. I have printed the barcode generated by your program but when i use a barcode scanner to read the printed barcode its not recognizing the barcode. but I tried scanning the barcode printed on some other product label its able to scan and import it to the stocks form. Could you let me know how to fix this?

Add new comment

Add new comment
7727 views