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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Fields in Access 2000 1

Status
Not open for further replies.

BLBurden

Technical User
Joined
Jan 25, 2003
Messages
236
Location
US
Hello guys, been a long time since I've needed help but I am back. I have a form that I input daily records into. In this form I have a date field that reflects the Month, Day and Year the record was inputted. Right now the date field is tied into a pop-up calendar and I am having to drop the calendar down and select the date, which is fine for now.

My question: Is there a way to automate the date field to pull the current date from the pop-up calendar so I dont have to drop it? Or is there another method I can used other than the pop up calendar to input the current date of a record but yet keep the previous date of a past record.

Those you know me know I am not good and explaining myself, but I think this is a clear explanation of what I need. Please help if possible

BLB[elephant2]
Always Grateful
 
Default the date fields value to now() in the table design (that means as the record is crated it assumes todays date.

Have a button on the form which puts now() into the text field (formatted appropriately).


Vince
 
Thanks bunches Vince, but right before I read you post, I figure it out. But is is good to know that somebody out here is always looking out for me. Have a good week and I gave you a star for just being so prompt. [rockband]

BLB[elephant2]
Always Grateful
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top