Help creating a new database for inventory

[Diamond_Ruby]

Hello I have begun to create a database so that I can track inventory
items. For example the fields I am using are the Procuct code, description,
price, amount used, amount available and quantity. I went ahead and created a
table for the inventory and also a form with the exact information. My
question is: how do I go about making calculations? For example I wanted the
database to subtract the "amount used" from the "quantity" and the
information will show up in the field "amount available". I have done
something similar in EXCEL. I dont know much about ACCESS other than the
basics of inserting fields, switchboards, etc.

Also how to I get my database to open up like a real program without the File
MENU options showing for Access. I hope I am making sense. Anyone with any
help at all, I will be more than happy! Thank you.

 

[Albert D. Kallal]

Also how to I get my database to open up like a real program without the

File
MENU options showing for Access. I hope I am making sense. Anyone with
any
help at all, I will be more than happy! Thank you.

You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you
do not have to bother setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[Diamond_Ruby]

Yay! Thank you so much Albert! : ) This is absolutely what I needed. Now I
have to tackle the calculation issue.