<div>
BINGO!<br />
<br />
=DateAdd(&quot;ww&quot;,[Text2],[Tex<wbr />t1])<br />
<br />
Thanks!<br />
<br />
net
</div>


BINGO!

=DateAdd("ww",[Text2],[Text1])

Thanks!

net

<div>
<div class="content wysiwyg-content">
I would like to learn how to calculate leadtime in VBA. &nbsp;I have a txtbox that has a date. &nbsp;Formatted as date. &nbsp;I have a txtbox that has a number. &nbsp;I have another box that is a calculation of the two. &nbsp;Example<br />
<br />
txtbx1<br />
10/29/08<br />
<br />
txtbx2<br />
10<br />
<br />
txtbx3<br />
needs to equal 10 weeks in the future starting on 10/29/08. &nbsp;<br />
<br />
I have a work around adding another txtbox4. &nbsp;which is calculated as =txtbx2*7. &nbsp;Then<br />
txtbx3 is calculated as =txtbx1*txtbx4.<br />
<br />
There has to be another way. &nbsp;This question is strictly for learning and not any emergency. It would be nice to learn a new trick<br />
<br />
net
</div>
</div>


I would like to learn how to calculate leadtime in VBA.  I have a txtbox that has a date.  Formatted as date.  I have a txtbox that has a number.  I have another box that is a calculation of the two.  Example

txtbx1
10/29/08

txtbx2
10

txtbx3
needs to equal 10 weeks in the future starting on 10/29/08.  

I have a work around adding another txtbox4.  which is calculated as =txtbx2*7.  Then
txtbx3 is calculated as =txtbx1*txtbx4.

There has to be another way.  This question is strictly for learning and not any emergency. It would be nice to learn a new trick

net

Calculating Lead time

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.