New database

  • Thread starter Thread starter tbogy
  • Start date Start date
T

tbogy

I am trying to make a parts inventory database for my company. I have
setup a table named Parts List with columns named Category, Part Name,
Manufacturer, Part Number, Previous Quantity, Quantity Received,
Quantity Issued, Quantity Restock Order, Quantity On Hand, Unit Price,
Location and Consignment.
I also have forms for
Parts Issued with columns for Consignment, Manufacturer, Part Number,
Quantity Issued
Parts received with columns for Consignment, Manufacturer, Part
Number, Quantity Received
Parts Restock Order with columns for Consignment, Manufacturer, Part
Number, Quantity Restock Order
All of the columns in the above forms are locked except for Quantity.
then I have a View/Add/Edit Parts information with all of the columns
from the parts list table for updates.
I have it set up for the forms to update the parts list table BUT I
can not get the Quantity on hand field to update. I would also like
the forms to clear after they are closed and update the table. I do
not know anything about code and I could really use some help. Thanks
 
I am trying to make a parts inventory database for my company. I have
setup a table named Parts List with columns named Category, Part Name,
Manufacturer, Part Number, Previous Quantity, Quantity Received,
Quantity Issued, Quantity Restock Order, Quantity On Hand, Unit Price,
Location and Consignment.
I also have forms for
Parts Issued with columns for Consignment, Manufacturer, Part Number,
Quantity Issued
Parts received with columns for Consignment, Manufacturer, Part
Number, Quantity Received
Parts Restock Order with columns for Consignment, Manufacturer, Part
Number, Quantity Restock Order
All of the columns in the above forms are locked except for Quantity.
then I have a View/Add/Edit Parts information with all of the columns
from the parts list table for updates.
I have it set up for the forms to update the parts list table BUT I
can not get the Quantity on hand field to update. I would also like
the forms to clear after they are closed and update the table. I do
not know anything about code and I could really use some help. Thanks
Click to expand...

Are you using bound or unbound forms? If you are using bound forms,
then the record will be updated any time someone navigates to a new
record. I use unbound forms so that I can control exactly when and
whether a record gets updated.
To update the quantity on hand field, you will need to put code in an
afterupdate event, if you are using bound forms. Here is an example:
Docmd.Execute "UPDATE tblStock SET [quantity on hand]=[quantity on
hand] + " & tblSales!quantity & " WHERE tblStock.[ItemNo] = " &
tblSales!itemNo

I don't understand the part about clearing forms ... if they are
closed, then you can't see them. If you can't see it, what is there
to clear?
 
I am trying to make a parts inventory database for my company. I have
setup a table named Parts List with columns named Category, Part Name,
Manufacturer, Part Number, Previous Quantity, Quantity Received,
Quantity Issued, Quantity Restock Order, Quantity On Hand, Unit Price,
Location and Consignment.
I also have forms for
Parts Issued with columns for Consignment, Manufacturer, Part Number,
Quantity Issued
Parts received with columns for Consignment, Manufacturer, Part
Number, Quantity Received
Parts Restock Order with columns for Consignment, Manufacturer, Part
Number, Quantity Restock Order
All of the columns in the above forms are locked except for Quantity.
then I have a View/Add/Edit Parts information with all of the columns
from the parts list table for updates.
I have it set up for the forms to update the parts list table BUT I
can not get the Quantity on hand field to update. I would also like
the forms to clear after they are closed and update the table. I do
not know anything about code and I could really use some help. Thanks
Click to expand...

Are you using bound or unbound forms? If you are using bound forms,
then the record will be updated any time someone navigates to a new
record. I use unbound forms so that I can control exactly when and
whether a record gets updated.
To update the quantity on hand field, you will need to put code in an
afterupdate event, if you are using bound forms. Here is an example:
Docmd.Execute "UPDATE tblStock SET [quantity on hand]=[quantity on
hand] + " & tblSales!quantity & " WHERE tblStock.[ItemNo] = " &
tblSales!itemNo

I don't understand the part about clearing forms ... if they are
closed, then you can't see them. If you can't see it, what is there
to clear?- Hide quoted text -

- Show quoted text -
Click to expand...

I am sorry I am kinda new at this.
I believe that my forms are bound. What I need to do is have a simple
form that we can update when items are received or issued. This form
would update the Quantity on hand and clear it self after the update
and be ready for a new entry.
I would like to track the activity but for now all I am working on is
the update.
Thanks for the help.
 
Back
Top