 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / December 2007Calendar To Stay at Last Date Entered
I have a calendar in a form. We do data entry for information that could have occurred today, yesterday, or a couple of days ago, like over a weekend. The form always goes back to todays date. How do I get the calendar to stay at the last date entered? Somehow you will need to record the last date entered in a table somewhere. I use a system table for such items. >I have a calendar in a form. We do data entry for information that could >have occurred today, yesterday, or a couple of days ago, like over a weekend. > The form always goes back to todays date. How do I get the calendar to stay >at the last date entered?  SignatureRuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. I tried to add code to go to table, but it doesn't pull the last date. It pulls a date two months ago. The code I wrote is: Me!calsetdate.value = dlast("[INDEX_DATE]", "tblPROD_DATA") The field is INDEX_NO The table is tblPROD_DATA I have this code once the form opens. Shouldn't it pull the last date in the table? > Somehow you will need to record the last date entered in a table somewhere. > I use a system table for such items. [quoted text clipped - 3 lines] > > The form always goes back to todays date. How do I get the calendar to stay > >at the last date entered? If it is the newest date then use DMax(). >I tried to add code to go to table, but it doesn't pull the last date. It >pulls a date two months ago. The code I wrote is: [quoted text clipped - 11 lines] >> > The form always goes back to todays date. How do I get the calendar to stay >> >at the last date entered? SignatureRuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.