Is there anybody who can help me to create program like receiving, issuing, monthly reporting and inventory program? Just I need the proper organizing. I am just beginner of visual basic. I hope somebody can help me. Thanks in advance
Is there anybody who can help me to create program like receiving, issuing, monthly reporting and inventory program? Just I need the proper organizing. I am just beginner of visual basic. I hope somebody can help me. Thanks in advance
First, do you want to do this in Access or Visual Basic (you posted under the Access forum but referred to VB)? Second, are you referring to a purchase order, sales order, inventory system? Microsoft has Access templates that will do those things, so your best bet is to start with one or more of those.
I am using access, How could I create the (IN) and (OUT) with information both. For example on my (IN) Record I give details like Qty in, cost,supplier etc. if the item will (OUT) I also give details like Qty out, cost, purpose etc. What I want to know is how could I make that after keeping (IN) on my record it will add my qty on hand and if I want to (OUT) on my record it will deduct my qty on hand. Hope you can assist me. Thanks in advance
What you use is ONE transactions table with a field that identfies the type of transaction. To calculate the quantity on hand you add all the icncimingt transactions and subtract the outgoing ones.
I will explain to you what I had done then tell me if I am doing wrong procedure or what is your opinion on it. I have my table 3 tables on (IN) and (OUT). I called it masterlist, item IN and item OUT table. In one form I link this two (IN) and (OUT) on my master list. So my basis on inputting my code no. is my master list so that if I search the code no. it show me the links (IN) and (OUT) on my subform because I locked the code with the master list. So, I think there is proper way on it. I want your comment or Idea regarding this topic. Thanks in advance.
Its not an improper way to do it, but its not the way I recommend it. As I said, I recommend ONE transactions table. You can have different forms bound to that table so you can default to the proper transaction type.
All times are GMT -7. The time now is 09:58 PM. |