Sales and Inventory Management Software Microsoft Access (VBA)

Submitted by vaibhav02 on Saturday, January 16, 2021 - 15:19.

Language

This is a Sales and Inventory Management System in using Microsoft Access. Here all the records are stored in the software. Record about the products and bills. Sales and Inventory Management Software In VBA (Microsoft Access) is Developed Using VBA + Access Database. This system manages records such as the suppliers, stocks, product categories, customers, employees, products, sales, reports and etc of a certain business. This system updates the product stock automatically after the system user encodes the purchases list. This feature serves as the receiving stock in feature of the system. The available stocks in inventory also update automatically every time the sales transaction is being done. This system also generates reports.

Features :

Company Entry
Customer Entry
Supplier Entry
Salesman Entry
Employee Entry
Products Entry
Users Registrations
Purchase Entry
Sales Entry
Product Stock

Reports :

Customer Report
Sales Report
Sales Receipt
Purchase Report
Stock Report
Sales Man Report
Employee Report
Product Report

How to Run

Requirements:

MS Access Software / MS Access Runtime

Setup

Download and Extract the source code zip file. (Download button is located below)
Open the extracted folder and locate the "SALES AND INVENTORY MANAGEMENT SOFTWARE.accdb" file.
Open the file with Microsft Access

Admin Credentials

User: admin
Password: 12345

Inventory Management System (Microsoft Access) - DEMO

I hope this Sales and Inventory Management System in MS Access will help you with what you are looking for and for your future project using MS Access.

Developed By: Vaibhav Patidar

ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ |

Anyone who needs program or source code for thesis writing or any Professional Software Development (desktop/Web):-
Facebook: https://www.facebook.com/vaibhav.patidar.524
My WhatsApp Number: +919630014949
My Contact Number: +919630014949
Email: [email protected]

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

Nice work! Thanks for sharing

Nice work! Thanks for sharing it.

admin user's password

Thank you for sharing but is it fully open or I have to purchase the admin password to run the application?

Awesome Work

Really Great Work. Thanks for Sharing.

Appreciating

Thanks to all of you for appreciating my work .....!!!

This may be what I was

This may be what I was looking for

Excellent

Excellent work dud every useful

Regarding Downloaded file is not opening

Dear Sir, when i try to open downloaded file, it opens the web page which has this article. please help me to open the downloaded file and see all codings. Thank you

required admin login

sir i have download your file but admin login required please provides us admin login .

i put the user admin and…

i put the user admin and pass 12345 but it is not opening

ADMIN PASSWORD

ADMIN PASSWORD NOT WORKING

admin password not working

thanks u man

Application edit

How to edit the application

Sales and Inventory Management Software Microsoft Access login

Sir, your login credential "admin" and password "12345" are not working. Can you please reply and tell me how to login?

make sure to enable the file…

make sure to enable the file to function> by default, ms access will disable any acro or executing any code. there is a yellow banner, enable it.

Log in id and password

Please help me, not working user id and password

wow this is very good. nice…

wow this is very good. nice job

USER ID AND PASSWORD

HELLO SIR NICE WORK, BUT USER NAME AND PASSWORD NOT WORKING , WOULD YOU PLEASE PROVIDE ME THE RIGHT ID AND PASSWORD. THANKS

waste of time fake

username and password not working. waste of time

Easy to make it work. Interesting code solution.

It is a very nice piece of software. Some nice code examples. I made a few tweaks. 1. Open the software with shift such that you get into the development. I made sure the password is 12345 in the table tbUser and in tblUser. 2. in the table tblCompany, change the address in the Pic field to where you have a picture for the "Margo Sales and Service" company. There are some nice chuncks of code in this program. Dor not use this for production, without adding some extra security and onError code.

Thanks for this inventory example. Fix the code errors...

Thanks for this. The username and password work fine after enabling the database. It looks like an excellent example of an inventory system written in MS Access, which I was looking for. I downloaded the file and tried to debug/compile it in VBA. It won't compile without fixing a lot of VBA code errors. I recommend you fix those errors when you have time so new users don't have to sort it all out. I also wish it had better code documentation and error trapping. It is a valuable example of inventory tracking written in Access!

Excellent Project

Hello sir, you have created an excellent inventory program using MS Access. If you have its tutorial, plz upload it on YouTube.

Guidelines

Hi Sir, plz guide me on how to update recent data of any Form like invoice, purchase, etc. When I open recent data from the list button then "Add" "Remove" buttons are inactive state and listbox rows "double click" to fill data to source boxes also not working.

Add new comment

Add new comment
42091 views