I have started to learn VB and VB.net recently. I'm a proud owner of MS Office 2007 Enterprise and I have VB 2005 to work with. I would like to write a nice Inventory program for my company. I have a few requirements.
1.) Employee login with restrictions to certain functions (Forms)
2.) Access database as the background.
3.) Buttons to Add and Subtract from inventory count.
4.) E-mail notification when the qty of a particular item is too low.
5.) Background system event logger for all transactions in the Inventory
6.) Each item inventory will have unique serial numbers to them and they will also have Part numbers. I want to be able to change the qty of on-hand counts for a particular part number, however I wish to be able to keep the Serial Number of the machine in a database that will allow me to create messages about repairs/Services performed on said machine and also to log WHO did them and other events regarding the services.
7.) i'd like the program to be as simple as possible but with great functionality because I have some serious Dumb Dumbs working for me.
8.) If at ALL possible, i'd love to find a source which will let me generate/print barcodes for these machines and parts I will be inventorying, as well as use the barcodes to remove 1 count from inventory and/or Add 1 count to inventory by scanning barcode.
Any ideas where I should start? I know Access pretty well and I'm becomming more and more fluent with VB. Got any referenes or perhaps you know of a program already?