date picker problem.

[UsenetUser]

Access 2007 SP1

I have a form with a date field which I would like to use as a subform
on an unbound main form. If I open the form on it's own, I can use the
date picker. If I make it a subform on a main form, whether bound or
unbound, and try to use the datepicker, it doesn't work - the record
does not show the edit pencil and there is no input into the date
field. However, I can enter the date manually!

I repeat - I can enter the date manually, but not with the date
picker. The formatting of the date field is not the problem either.
While I had it at yyyy-mm-dd, that works fine when the form is on its
own but not as a subform. Anyway, I tried removing that formatting and
leaving it blank.

I have tried recreating both the main and subform thinking one might
be corrupted. Behavior is the same with the new forms.

Any ideas?

 

[Tom van Stiphout]

You'll have to use a different control; datepicker does not work in
datasheet view. Because of that limitation I actually never use it.

-Tom.
Microsoft Access MVP

 

[AG]

You'll have to use a different control; datepicker does not work in
datasheet view. Because of that limitation I actually never use it.

-Tom.
Microsoft Access MVP

Tom,

Are you referring to the calendar that appears next to a text box that is
bound to a date field?
I am using Access 2007 SP2 and have a bound main form with a bound datasheet
subform containing a date field.
The calendar does appear and does work for me.

 

[Tom van Stiphout]

On Mon, 6 Jul 2009 16:22:39 -0400, "AG"

No, the OP was referring to the ActiveX control named DatePicker.
Presumably he is using it because he upgraded from a previous version
of Access. Indeed in A2007 there is the much superior calendar control
built-in to date fields.

-Tom.
Microsoft Access MVP

 

[AG]

On Mon, 6 Jul 2009 16:22:39 -0400, "AG"

No, the OP was referring to the ActiveX control named DatePicker.
Presumably he is using it because he upgraded from a previous version
of Access. Indeed in A2007 there is the much superior calendar control
built-in to date fields.

-Tom.
Microsoft Access MVP

Ah ha!