DUH! How could I miss something so obvious?? Since the calendar always
shows
the value of the TransDate field in my main table, I simply set the
default
value of the TransDate field to be Date() so that whenever a new record is
created, the current date gets populated there. If that's not the correct
date for the record, I can easily adjust it since the current date will be
near the actual trans date. Sometimes you gotta step away to see the
simple
answer.
"paulold@[EMAIL PROTECTED]
" wrote:
> I believe that would only set the value of the calendar to being the
current
> date, when I need it to show the value of the TransDate field on
existing
> records and the current date on newly created, empty records (until I
choose
> a value for TransDate). What does OnCurrent mean? Wouldn't that apply to
the
> existing records and not just the new ones?
>
> "tkelley via AccessMonster.com" wrote:
>
> > Holy cow, I botched that one. I got a little mixed up.
> >
> > Have you tried putting your calendar8.value=date() in your OnCurrent
event
> > for the form? That's where I meant to go with this.
> >
> > tkelley wrote:
> > >If you look at the properties/events of a calendar control, they
aren't all
> > >listed. However, if you go into the VBA code window and select your
calendar
> > >as the object, you'll see additional events that apply to calendars
in the
> > >events dropdown.
> > >
> > >In that dropdown you can select OnCurrent. Then you can put your
code to set
> > >the calendar.value property.
> > >
> > >Try that ...
> > >
> > >>I have added a calendar control to my data entry form in Access
2003. It's
> > >>called Calendar8. I have it tied to a field in my main table called
> > >[quoted text clipped - 15 lines]
> > >>far)? When I enter transactions, I roughly enter them in date order,
oldest
> > >>to newest. Thanks!
> >
> > --
> > Message posted via AccessMonster.com
> > http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200812/1
> >
> >
|
