[AccessD] Date data entry

John,

    This thread was initiated by you in Oct 2003. It is not clear whether the best possible solution was eventually reached. In this context, you might like to take a look at my recent sample db named InputMask_Dynamic - at Rogers Access Library (Other Developers Section).

    It features dynamic masks for pure dates with pre-filled values of month & year part as per chosen settings (default is current month & year). Text strings prefixed/suffixed with current month-year are also covered separately.
    
    Apart from the above, data entry for phone numbers featuring pre-filled area codes (if given), is also demonstrated. Two styles are shown (with or without saving the formatting details along with the source data).    
    
Regards,
A.D.Tejpal
--------------
  ----- Original Message ----- 
  From: John Colby 
  To: Access Developers discussion and problem solving 
  Sent: Monday, October 06, 2003 21:00
  Subject: RE: [AccessD] Date data entry


  >Would they accept the default set to =date()?

  Where logical I do that, however in these cases they are entering dates out
  in the future or in the past.

  John W. Colby
  www.colbyconsulting.com

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mitsules, Mark
  Sent: Monday, October 06, 2003 10:55 AM
  To: 'Access Developers discussion and problem solving'
  Subject: RE: [AccessD] Date data entry


  Would they accept the default set to =date()?



  Mark


  -----Original Message-----
  From: John Colby [mailto:jcolby at colbyconsulting.com]
  Sent: Monday, October 06, 2003 10:44 AM
  To: AccessD
  Subject: [AccessD] Date data entry


  I have a specific client that LOVES the input masks for dates.  I don't
  understand this as I personally hate them, but...

  What they want is to have something like that but which "assumes current
  year", i.e. all they have to enter is the ddmm and the rest (the year) is
  filled in.

  Does anyone do this?  Know how to do this?

  John W. Colby
  www.colbyconsulting.com