Do you know Visual Basic Programming?

Question

I want to create a warehouse maintenance and monitoring program in our company, and I am a warehouse supervisor.
first, I want to create a Material Master File,
what are the fields do you suggest that i will use to produce this Form?....
Our warehouse uses materials such as RESIN, PAINTS, PLYWOODS, NAILS, GLUES and etc.......
and after that what is the next form to create?...

hmmmnnnn......I guess i have to be more specific...
the only thing that i want to, is to have the fields that is so helpful in building a form about materials....
we are only using a code system....
like "material code : 01-001" and not barcodes or serial numbers...
I just want to computerized the man powered paper works entry of my people(warehouse assitants). so I think you have to trigger a direct answer rather than squeeze my brain into "something"..........

Answer 1

Fields to create in your database
1.) Name ie. PAINT, LATEX, 1GAL,BLUE Note the format allows for grouping by sorting. All the paint will be grouped together when sorted ect.

2.) Internal Part Number - Unique part number used by your company to identify the item and within the database as a foreign key to reference related data in another table.

3.) Unit of Issue - EA(each) ST(set) PK(pack) ect...

4.) Minimum Quantity on Hand (MQOH) - Amount to trigger a reorder

5.) Quantity On Hand (QOH) - amount of in stock items

6) Quantity On Order(QOO) - Amount on order used with QOH to determine ir the MQOH is being met within lead time

7.) Cost per unit - used to compute an inventory value

8) Location - Make a code which uses the same number of characters so that anyone may find the item. By using codes with a well defined pattern and same lenghts like

WH1R1S3B5 (Warehouse 1, Row 1 Shelf3 Bin 5) Again with a well defined locator code printouts will be easier to read and sorting will group invenory by locations

9.) Description - A more detailed desscription of the item

10 Add some Boolean (Yes/No) values for items such as
HazMat, MSDS required,Obsolete,Surplus,

Answer 2

This is a much larger question than can be answered here. Without knowing your industry I can't help much, but here goes.

First off. Figure out all your different entities (Materials, employees, etc). Then figure out all you need to know about each of these entities (such as Employee:Name, Birthdate, HireDate, etc). These will be your base tables. You will probably have to add to them as you go along. Build forms to enter data into these tables. Then you can create more sophisticated forms and reports.

Hope this gets you started (Plus I would buy a couple of books on the subject. Maybe one on Database design as well).

Answer 3

well first of all u have to make sure that all the functions that one could do by paper-work could be done on the program

mostly these are adding/ editing/ deleting

now you have to make a form for each, as fields now that depends on how your records are structured. example if you classify paints by serial number then you have to have a field for serial numbers.

this can be very easily created and maintained, try searchin on yahoo for some visual basic tutorials on forms and databases. they are very very easy to learn and use

Answer 4

check out http://www.pscode.com for excellent source code samples. You will need to have a visual basic development environment on your computer in order to run them.