philipnaparan

Q. how can i deduct the purchased item of the customer in my stock?

Posted by philipnaparan on 18 October, 2009
No comments yet
This item was filled under [ MISC. ]


Question: how can i deduct the purchased item of the customer in my stock?

-From rockerz_rule07(at)yahoo.com

Answer:

…

rsMY_STOCK_RECORD.Open “SELECT MY_STOCK_TABLE WHERE MY_STOCK_ID_FIELD = ” & ID_OF_STOCK
rsMY_STOCK_RECORD.Fields(”MY_STOCK_ID_FIELD”) = Val(rsMY_STOCK_RECORD.Fields(”MY_STOCK_ID_FIELD”)) – QTY_TO_DEDUCT
rsMY_STOCK_RECORD.Update

…

Above are pseudocode on how to do it.

 

Note: If you have any question, send it to ask(at)devsource360.com for proper distribution of your question to the devsource360 modulator. thanks.

 

Ref:

sir can u help me for my system, i’m only a beginner in using vb 6.0. i have a project in school, im creating a point of sale and inventory system and i just want to  have a solution in my problem: im using vb.6.0 and ms access

Example: I have a stock of 100 items of a coke for example then the customer by to me 50 items of that item so my stock left only 50 items.

 






Rate this topic:
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Popularity: 118 views
Tagged with: [ ]
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Comment

« Q. How can i add additional 50 items to my stock to become 100 again?
ASP.NET Dynamic HTML Editor »


Q. how can i deduct the purchased item of the customer in my stock? Copyright: You should confirm all information about Q. how can i deduct the purchased item of the customer in my stock? full version edition(freeware/shareware) before downloading or relying on it. Software piracy is theft, Using crack, password, serial numbers, registration codes, key generators or key gen, cd key, hacks, dvd rip is illegal and prevent future development of Q. how can i deduct the purchased item of the customer in my stock? full version edition. Download links are directly from our publisher sites or from the link provided by users, torrent files or links from rapidshare.com, yousendit.com, megaupload.com, netload.in, storage.to or depositfiles.com are not allowed.