• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1399
  • Last Modified:

microsoft access day countdown

Hi, I am looking for a day countdown timer for one of my forms. Is this an easy thing to do. I see lots of articals on timers but nothing for days.

On my main form I would like to have on it a countdown in days and maybe time to a specific point say countdown to christmas for example. Any ideas, or is this a big question
thanks
0
tucup
Asked:
tucup
  • 3
  • 2
  • 2
2 Solutions
 
Rey Obrero (Capricorn1)Commented:

you can use

msgbox DateDiff("d",Date(),DateSerial(Year(Date()),12,25)) & " Days before Christmas"
0
 
Jeffrey CoachmanMIS LiasonCommented:
<I see lots of articals on timers but nothing for days.>
The reason is that there are a lot of issues when doing things on a "Timer" across Days
You must *Guarantee* that the machine will remain on over those days


If you simply need a countdown till a date, use something like this as the controlsource property for a textbox in a form/report:
=DateDiff("d",Date(),#12/25/2011#)

Here "Date()" will always be the current date.

JeffCoachman
0
 
Rey Obrero (Capricorn1)Commented:
in your form, place a textbox and set the Control Source to
=DateDiff("d",Date(),DateSerial(Year(Date()),12,25)) & " Days before Christmas"
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
Jeffrey CoachmanMIS LiasonCommented:
capricorn1's is better...
0
 
Rey Obrero (Capricorn1)Commented:


using a fix date ( #12/25/2011# - not advisable) means you have to change the year every year
0
 
tucupAuthor Commented:
\thanks, I wasnt expecting you to solve it so soon, well done thx to you both
0
 
tucupAuthor Commented:
Wow, a date is so quick to add but I am glad you pointed me in the right direction, I may have messed up otherwise
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now