Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   What is the steps of creating Complete Program? (https://www.askmehelpdesk.com/showthread.php?t=220006)

  • May 26, 2008, 11:30 AM
    MUHAIMEN
    What is the steps of creating Complete Program?
    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
  • May 26, 2008, 02:06 PM
    ScottGem
    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.
  • Aug 8, 2008, 02:10 PM
    MUHAIMEN
    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
  • Aug 8, 2008, 04:28 PM
    ScottGem
    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.
  • Aug 9, 2008, 04:11 AM
    MUHAIMEN
    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.
  • Aug 9, 2008, 07:55 PM
    ScottGem
    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.