Product/Stock Access Database

[danian]

I need a basic Product database that allows you to have a drop down menu to select a product from a table. In turn this puts the unit price in for you, you then put the quantity in and it calculates the total.

I also have a stock control. When one is bought it takes the quantity down. Very simple I know but I can’t get it to work….

If there are any good basic database templates i could use let me know

I have attached a sample zip file

D

 

[ThreeCrow]

I can suggest the Microsoft Access Northwind, it should be on your Access disc. If not it can be downloaded from Microsoft.com. This database will give some good pointers and a starting point.

From there you have more tables, queries, forms, and reports. That you will have to add to the database.

Hope this help to get you started

 

[danian]

I have been playing all day. Here is a little update

Problem:

I have 2 tbls tblProducts & tblOrderDetails, i also have 1 form frmSellProduct.

The frmSellProduct form looks at a field called ProductName on tblproducts which is a combo box.

What i require is:

when i click on a product name it automatically adds the unitcost in the form

I added some vba onto the the ENTER button on frmSellProduct. When this is clicked it adds all input info onto tblOrderDetails.

I have attached the database as a zip file