Ask Experts Questions for FREE Help !
Ask
    MUHAIMEN's Avatar
    MUHAIMEN Posts: 44, Reputation: 1
    Junior Member
    		  
    #1

    May 26, 2008, 11:30 AM
    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
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    May 26, 2008, 02:06 PM
    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.
    MUHAIMEN's Avatar
    MUHAIMEN Posts: 44, Reputation: 1
    Junior Member
    		  
    #3

    Aug 8, 2008, 02:10 PM
    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
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #4

    Aug 8, 2008, 04:28 PM
    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.
    MUHAIMEN's Avatar
    MUHAIMEN Posts: 44, Reputation: 1
    Junior Member
    		  
    #5

    Aug 9, 2008, 04:11 AM
    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.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #6

    Aug 9, 2008, 07:55 PM
    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How do I complete this? [ 8 Answers ]

A pellet gun is fired straight downward from the edge of a cliff that is 15.9 m above the ground. The pellet strikes the ground with a speed of 34.3 m/s. How far above the cliff would the pellet have gone had the gun been fired straight upward?

Complete confusion [ 4 Answers ]

Hi I have quite a few things going on for me, creating loads of confusion and a lack of clarity. 1. I have recently moved country and I'm looking for a new job. I did find an OK one, (contract work, part time) but it looks like it might have dried up. Should I be hanging in there or looking...

Program for creating database [ 3 Answers ]

Hello! I have one question: I want to create a database which would act like stand alone program (I hope you understand). So far so good but the problem is that I don't know any of programming languages so I need a program which doesn't require programming. If anybody knows program like that...

View more questions Search