Entering a Date?

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

In Lotus Approach you can enter a single day number like 6 in a date
field and it will add that date to the record. Example if you are in
the current month of July and enter a 6 it will return 07/06/2005 in
the field. Is there a way to do that in Access to simplify data entry
of dates?

If so could someone explain how to do this.
 
No. You could build it using the datepart or serial functions to tie in the
month of the current month, the day entered, and the year of the current
year.
 
If you are new to Access, then I would not recommend doing it. Instead,
simply go to your date field and type...

"7/6" and press enter or tab. Access will assume the current year.

If you want to do the other, you will need a date field on your form, and
also a separate unbound textbox named something like "DayNumber:" You'd
then have to build code in the field's 'change' event or 'exit' event that
tests the date field to verify it is blank and then writes a date like...


DateField = DateSerial(Year(Date()), Month(Date()),[DayNumber])


Probably more trouble than it's worth since you are simply trying to copy
some strange reflex in another application. You'd have to build similar
features into all your forms. Instead, use the tools and rules that come
with Access.
 
Back
Top