<div>
mrmick: Thanks.. I tried creating the function (Which is the first time) and get an Invalid Object Reference in the following line (Tables!([Invoice table]![Total Labor]) and it highlights ([Invoice Table]<br />
<br />
That is the correct name of the invoice table. &nbsp;Do I have to declare the DB I am using?<br />
Thanks!!<br />
Alexander!!<br />
&nbsp; &nbsp;<br />
Agongora@voicenet.com<br />
<br />
<br />

</div>


mrmick: Thanks.. I tried creating the function (Which is the first time) and get an Invalid Object Reference in the following line (Tables!([Invoice table]![Total Labor]) and it highlights ([Invoice Table]

That is the correct name of the invoice table.  Do I have to declare the DB I am using?
Thanks!!
Alexander!!
   
Agongora@voicenet.com




<div>
Adjusted points to 60<br />

</div>


<div>
Millos, If you're now satisfied with the answer you've received - you should grade it.<br />

</div>


Millos, If you're now satisfied with the answer you've received - you should grade it.


<div>
<div class="content wysiwyg-content">
I would like to create a function in VB. &nbsp;I never wrote or used functions before. &nbsp;Here is the situation:<br />
I have two tables: &nbsp;Invoice table &amp;&nbsp;Account Receivables Table. Here are the fields:<br />
Invoice Table: &nbsp;Invoice#, Date,(all customer Info fields), Total Labor.<br />
A/R Table: Invoice#, Date, (all customer Info fields), Late Charge, Amount Paid.<br />
<br />
I would like to have a Function to calculate the Total Invoice Balance so I can put it in several forms. &nbsp;<br />
Here is the calculation:<br />
<br />
([Invoice table]![Total Labor])+([Account Receivables Table]![Late Charges])-([Account Receivables Table]![Amount Paid])<br />
<br />
I have no idea how to do this. &nbsp;Any help will be appreciated.<br />
<br />
Thanks!!<br />
<br />
Alexander!!!<br />
<br />

</div>
</div>


I would like to create a function in VB.  I never wrote or used functions before.  Here is the situation:
I have two tables:  Invoice table & Account Receivables Table. Here are the fields:
Invoice Table:  Invoice#, Date,(all customer Info fields), Total Labor.
A/R Table: Invoice#, Date, (all customer Info fields), Late Charge, Amount Paid.

I would like to have a Function to calculate the Total Invoice Balance so I can put it in several forms.  
Here is the calculation:

([Invoice table]![Total Labor])+([Account Receivables Table]![Late Charges])-([Account Receivables Table]![Amount Paid])

I have no idea how to do this.  Any help will be appreciated.

Thanks!!

Alexander!!!



Invoice Total VB Function

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.