Simple Inventory System

[VISHAL.VODRO]

Hi!



I'm just trying to create a very simple Inventory Application INVENTORY.zip for my small Office, where I just need to keep the record of purchasing Product then Issuing to the Employees as per the requirement. I'm not into selling anything, just receiving the product and issuing for self purpose.

Activities involved are:
================================================
1.Purchase the Products from Suppliers/Shops.
2.Storing into the Warehouse.
3.Issuing to the Employees according to the requirement.
4.Reporting the Closing Stocks.
5.Keeping the track of Minimum Qty alert for re-ording.

Issues I faced so far:
================================================
Require ESC button press to close the form with a Prompt rather using mouse/Alt+F4

Table/Form > ADD_PRODUCT :
Combo boxes to be entered (if it's new item) by pressing F3 so that I don't need to type the same content twice.

Table/Form > PRODUCT_ISSUED :
Employee name (if new entry) to be entered by pressing F3
Designation to auto populate depending upon Employee Name
Multi products list for Issue and Receive scenarios

QUERY :
How to get Item wise Closing Stock rather showing individual and repeated (i.e Goggles repeated twice)
Need to see which products are below Minimum Level.

REPORT :
Specific Date/Month wise transaction report of Issued/Received etc.
Employee wise report.
Category wise report.
Product wise report.

NOTE :
I'm very new at this Access stuff. All this years have been working in Excel with frequent formulas made me puzzled in Access hoping if some formulas like VLOOKUP etc could work.

I wanted a very simple Database and avoid VB Code if possible.

Thank you very much for your Time & Concern.

From India with Love.
Vishal Vodro.

[orange]

I suggest you review the Similar Threads at the bottom of the page for general help.
Do you have specific questions? As you are learning, Access and Excel are built on different object models.
This link Inventory of IT Assets model may be helpful. The facts behind the model are here.

Good luck.

[VISHAL.VODRO]

Thanks for the reply.

And yes, I'm totally new in this forum due to lacking of knowledge in access which I expect to cover up from here...

[VISHAL.VODRO]

Went through some of the links, but found only long long conversation, no proper sample file, my bad, I need to get more deep into it. Yet I'm hoping someone to come up with a simple solution of my queries.

[Minty]

Try downloading the Northwind Sample database that ships with Access, it has many of the building blocks you need to start you off.

Inventory isn't simple. Don't expect it to be no matter how simple you think it should be.

[orange]

Vishal,

You are unlikely to find an application to match your needs. As minty said inventory applications aren't simple.
The links I provided shows an Inventory of IT Assets --the tables, relationships and attributes; and the Business facts involved.
Here is a 26 minute video showing the design,development and operation of a Stock Inventory system
Good luck with your project.

[ssanfu]

Vishal,
I totally agree with comments by Minty and Orange.

"Old Programmer's Rule" is this: If you can't do it on paper then you can't do it in Access. Until you can draw out your tables AND rules for how they change for each function you want to perform, you are going nowhere fast.


I modified your dB to be more normalized. I changed some object names to remove spaces and special characters; I also changed the relationships.
I added a form/sub form to make it easier to issue items. I did not change the supporting forms (adding things).

Again, you need to design the tables/relationships on paper, then design the forms. You would/should try adding info in the paper forms to see if things work right and correctly.


Maybe this will help you move forward.

Good luck with your project....

[VISHAL.VODRO]

Vishal,
I totally agree with comments by Minty and Orange.

"Old Programmer's Rule" is this: If you can't do it on paper then you can't do it in Access. Until you can draw out your tables AND rules for how they change for each function you want to perform, you are going nowhere fast.


I modified your dB to be more normalized. I changed some object names to remove spaces and special characters; I also changed the relationships.
I added a form/sub form to make it easier to issue items. I did not change the supporting forms (adding things).

Again, you need to design the tables/relationships on paper, then design the forms. You would/should try adding info in the paper forms to see if things work right and correctly.


Maybe this will help you move forward.

Good luck with your project....

You people are so generous and helpful! Never knew that the things which just looked simple turned out to be so complicated. But got many new things to learn from you all. Thank you dear for the modification. Will give it a try and revert.

[orange]

cross posted https://www.utteraccess.com/forum/in...ic=2052717&hl=