Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / July 2007

Tip: Looking for answers? Try searching our database.

Date & Control Button Focus

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bill - 02 Jul 2007 20:06 GMT
I have a form that has the calendar in it and 3 buttons that represent 1st,
2nd, and 3rd shift.  We input up to 50 forms per day.  The forms may be
entered the next day.  The calendar will always go to todays date because of
the code Now() used.  How do I make the date stay at the last date that was
enetered?  How do I make the 1st, 2nd, and 3rd shift buttons stay at last
shift selected after data has been entered?  This would allow the data entry
person not to have to change date or shift if forms are grouped together.
strive4peace - 04 Jul 2007 08:48 GMT
default values
--

Hi Bill,

"The calendar will always go to todays date because of the code Now() used."

are you wanting to store date AND time?  If so, then Now() would be
correct -- but if you just wanted a Date, the you should use Date()

"The calendar will always go to todays date"

it seeems that you are actually wanting the default value to be this:

dMax([DateField},[Tablename])

"How do I make the date stay at the last date that was enetered?"

dLast([DateField},[Tablename])

assuming that the last record entered has the date that you are looking for

... if you provide more details about your forms and controls, we can be
more specific

"How do I make the 1st, 2nd, and 3rd shift buttons stay at last
 shift selected after data has been entered?"

dLast([ShiftField},[Tablename])

assuming that the last record entered has the shift that you are looking for

Warm Regards,
Crystal
 *
     (:  have an awesome day  :)
  *
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
  *

> I have a form that has the calendar in it and 3 buttons that represent 1st,
> 2nd, and 3rd shift.  We input up to 50 forms per day.  The forms may be
[quoted text clipped - 3 lines]
> shift selected after data has been entered?  This would allow the data entry
> person not to have to change date or shift if forms are grouped together.
 
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



©2009 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.