Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SHOW TODAY'S DATE ON FORM 1

Status
Not open for further replies.

barry2004

Technical User
Oct 13, 2004
42
GB
Hi guys, i need to be able to display today's date on a form called "RealTime", date to be taken from my computer's clock. I already have a mini calendar form (one of the freebie ones floating around on the net)It shows you all the days and dates for the current month from which you can pick a date of your choice for all 12 months for any year. It already has todays date higlighted in Red when it's open. The calendar form is opened by an OnClick Event on the "Date" Field on the "RealTime" form.
Second question, I want to create a query so i can sort records based on todays date. It would be pointless setting the Query criteria to Like "14/06/2005" as this would not work tomorrow or any day after.
 
Why not simply put =Date() in a text box on your form? This would always display the current date. Use the same think in the query.


Randy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top