Purchase Requistion

This is an assignment for uni but also requires a real life solution for a small business. It consists of an Access database with a VB front end. I have made a fair bit of progess already but need some help with some of the coding. The business is a small metalwork-engineering firm, which requires a purpose-built computer system that can be used as an aid to ordering materials and supplies, and that can hold all relevant information on suppliers and other purchase related data. Ultimately, the system should simplify the ordering process and be able to hold data in an accurate and reliable manner. A variety of items need to be ordered from new and established suppliers on a daily and/or weekly basis. The required system will address many of the user's purchasing needs and will provide a controlled format for submitting orders. Currently all the supplier and customer elements of the system - adding, editing, deleting and searching for customers and suppliers - work. It is mainly with processing orders that I need some help. I have completed most of the work already, namely all the theory, the database and the design of the VB, as well as some of the coding. However, I am not very good with programming, and so have have come unstuck in regards to some of the coding! Some of the forms may be unnecessary, or there may be a better solution available to some of my requirements, so I would appreciate some advice/assistance in regards to the layout and design, however, this is not essential. Mainly I need programming help. ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. 1. I would like the order forms (frmConsumables, frmMetals and frmStationery) to display a list of suppliers who only supply the relevant category, i.e. the consumables form to display only suppliers who provide consumables in the drop-down box. (I have added a new field in the Suppliers table in the database called Category, which lists what category the supplier provides. I don't know if I did the right thing here, as I already have a table called StockCategory, and maybe it would be better to reference the supplier from there by maybe adding a SupplierID field in that table instead. Anyway to take the frmConsumables as an example, after having tried to code the drop-down box to show only consumables suppliers, I have learnt that currently with ADO, the Recordset Find method is limited to a single column find criteria. And so I can't try to use two or more columns (via AND statement) in the find criteria, to get the list of consumables only suppliers. I'm sure there must be a way around this?) 2. On the order forms there is a command button called Suspend order. The purpose of this is to hold the unfinished order, say if the user is awaiting a response from a supplier with price details etc. (The question is, where can I hold the unfinished order? I could add another field to the Orders table in the database called 'Status' where I could specify whether the order is suspended or processed, but to retrieve the suspended order at a later date would I not encounter the same problems similar to those in question 1, as in the search would need to be performed via two columns in the Orders table? Is there a simpler solution to all this?) So I need a way of storing and retrieving suspended orders easily. 3. I need an easy way to connect to reports in Access. For instance if I had an Orders History report, simply a record of all the orders made, I would need to connect to this through VB. 4. The user will need to be able to update stock records through a stock inventory - basically just a list of stock held in the warehouse and quantities. The user will need to be able to view this and update it through a form in the VB program. 5. I have a login form which needs to allow different users to be assigned with different passwords. Currently there is only one user name and password. 6. The program will need to issue a warning to the user if a stock item reaches a critical low, for instance if aluminium levels fall below 4 units. 7. Finally, once a user has processed an order, the program will need to take the data from a given form and organise it into a printable order, then printed by the user. ## Platform Windows 98