Supplies Inventory System

Submitted by: 
Visitors have accessed this post 4237 times.

After looking at my source code in supplies inventory system. I was amazed by the fact that I am using an old code which is not actually my style of coding.

Although this program works great if you want to calculate a running balance, there is however, a more straightforward method of coding a running balance. If you have downloaded some of my code especially made in VB, you’ll see what I mean.

The code that supposed to be use in the running balance is:

  1. Format(DSum("nz([RQty])-nz([IQty])","Supplies Details","[SupplyDetailsID]<=" & _
  2. [SupplyDetailsIDAlias] & " And [SupplyID] = " & [SupplyID]),"Standard") AS Balance

This will replace my old code that is using a manual calculation for the running balance. If I have time, I will upgrade this program to version 2.0.

Thanks again for patronizing this website.


thank you

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.