Sales and Inventory Management Software Microsoft Access (VBA)

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

  1. Download and Extract the source code zip file. (Download button is located below)
  2. Open the extracted folder and locate the "SALES AND INVENTORY MANAGEMENT SOFTWARE.accdb" file.
  3. 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
LIKE | COMMENT | SHARE |

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

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

Excellent work dud every useful

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

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

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

thanks u man

How to edit the application

Please help me, not working 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

username and password not working. waste of time

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

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

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.

Sir how can I generate reports start date to end date in this project

Thanks excellent work!

Unblock the file from file properties then it would work. This is ecause Microsoft blocks executable files downloaded from the internet.

Add new comment