Re: Macro? ode?

Tech-Archive recommends: Fix windows errors by optimizing your registry

You could use the DateDiff function. In the control source of an unbound
text box:
=DateDiff("d",Date(),#7/5/08#)
See Help for more information about DateDiff. Note that the fixed date
needs the # delimiters. If the date in question is a control on the form or
a field in the form's record source, you can refer to that instead:
=DateDiff("d",Date(),[YourField])

"Sue" <Sue@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EEF282AA-D531-4866-AC0D-12D823EBEB63@xxxxxxxxxxxxxxxx
I want to place a control on my form which will calculate the number of
days
from now until a specific date in the future - always the same date in the
future, in this case July 5, 2008. Not sure how to achieve this. Help?

Thanks.

--
Thanks for your time!


.

Relevant Pages

  • Re: Help with DOB formula.
    ... Directly as the control source of an unbound control: ... You do know, I hope, that this Age computation should NOT be stored in ... Just compute it and display it on a form or report, ... "A More Complete DateDiff Function" at ...
    (microsoft.public.access.queries)
  • Re: Changing the parameters of a form
    ... Thanks Sean, you are right, my form is unbound. ... I am using the form so that a user can simply select a StartDate and EndDate ... just put Available in the Control Source text box. ... I also tried to creating a new textbox, and making that control source equal ...
    (microsoft.public.access.queries)
  • Re: calling a function from a sub
    ... You could put the following into the control source of the unbound textbox in your form and see if it works: ... I have constructed this select case sub and placed it in the current event, ... strRR = "RR1L1" ...
    (microsoft.public.access.modulesdaovba)
  • Re: Sum in a continious form footer
    ... I had two other unbound fields in the footer that was causing ... Get rid of the txtSumOfFootage textbox in your detail section ... is named txtfootage and its control source is named FOOTAGE. ...
    (microsoft.public.access.gettingstarted)
  • Re: Calculated Field in a Subform
    ... <MS ACCESS MVP> ... Watts, Total Watts (unbound txt containing Fixture Qty * Watts), ... When I recreate the calculation and refer to column 1, ... control source of the unbound subtotal field is: ...
    (microsoft.public.access.forms)