Calendar in MS 2007

HI
Using Access 2007
Can I open the calendar that automatically appears next to date fields with
a keyboard shortcut as I dont want to use the mouse
Thanks
Alfred

Re: Calendar in MS 2007

I don't see a built-in shortcut for the date picker.

You could create an AutoKeys macro, and assign a keystroke to RunCommand
with ShowDatePicker.

Alternatively, if you want this for one date box on one form, you could add
a shortcut key to SetFocus to the date field, and then RunCommand
acCmdShowDatePicker

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Alfred" wrote in message
news:n-mdnd3LCa6u2anaRVnyvQA@saix.net...
> HI
> Using Access 2007
> Can I open the calendar that automatically appears next to date fields
> with a keyboard shortcut as I dont want to use the mouse
> Thanks
> Alfred

Re: Calendar in MS 2007

This is a good one, Allen, thanks! I didn't think to use code to force the
button to show for the date picker. I have an issue where, if I use a date
input mask, the date picker button won't show, so doing a got focus event
might be just the ticket. I'd get rid of the input mask, however, some users
do use that option, and would most likely complain if I removed it.

Andy

"Allen Browne" wrote in message
news:4734526f$0$23950$5a62ac22@per-qv1-newsreader-01.iinet.n et.au...
>I don't see a built-in shortcut for the date picker.
>
> You could create an AutoKeys macro, and assign a keystroke to RunCommand
> with ShowDatePicker.
>
> Alternatively, if you want this for one date box on one form, you could
> add a shortcut key to SetFocus to the date field, and then RunCommand
> acCmdShowDatePicker
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Alfred" wrote in message
> news:n-mdnd3LCa6u2anaRVnyvQA@saix.net...
>> HI
>> Using Access 2007
>> Can I open the calendar that automatically appears next to date fields
>> with a keyboard shortcut as I dont want to use the mouse
>> Thanks
>> Alfred
>

Re: Calendar in MS 2007

Okay, you have it sorted out.

There might be a reason why the MS Access team disabled the date picker when
input masks are used. I haven't tested, you probably want to check that it
interprets your mask correctly if the format is non-standard.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ARC" wrote in message
news:nEK_i.6858$TR5.5516@nlpi061.nbdc.sbc.com...
> This is a good one, Allen, thanks! I didn't think to use code to force the
> button to show for the date picker. I have an issue where, if I use a date
> input mask, the date picker button won't show, so doing a got focus event
> might be just the ticket. I'd get rid of the input mask, however, some
> users
> do use that option, and would most likely complain if I removed it.
>
> Andy
>
> "Allen Browne" wrote in message
> news:4734526f$0$23950$5a62ac22@per-qv1-newsreader-01.iinet.n et.au...
>>I don't see a built-in shortcut for the date picker.
>>
>> You could create an AutoKeys macro, and assign a keystroke to RunCommand
>> with ShowDatePicker.
>>
>> Alternatively, if you want this for one date box on one form, you could
>> add a shortcut key to SetFocus to the date field, and then RunCommand
>> acCmdShowDatePicker
>>
>> "Alfred" wrote in message
>> news:n-mdnd3LCa6u2anaRVnyvQA@saix.net...
>>> HI
>>> Using Access 2007
>>> Can I open the calendar that automatically appears next to date fields
>>> with a keyboard shortcut as I dont want to use the mouse
>>> Thanks
>>> Alfred

Re: Calendar in MS 2007

Thanks, Allen. The mask that I use most is: "99/99/0099;0;_"


"Allen Browne" wrote in message
news:473b9167$0$10702$5a62ac22@per-qv1-newsreader-01.iinet.n et.au...
> Okay, you have it sorted out.
>
> There might be a reason why the MS Access team disabled the date picker
> when input masks are used. I haven't tested, you probably want to check
> that it interprets your mask correctly if the format is non-standard.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "ARC" wrote in message
> news:nEK_i.6858$TR5.5516@nlpi061.nbdc.sbc.com...
>> This is a good one, Allen, thanks! I didn't think to use code to force
>> the
>> button to show for the date picker. I have an issue where, if I use a
>> date
>> input mask, the date picker button won't show, so doing a got focus event
>> might be just the ticket. I'd get rid of the input mask, however, some
>> users
>> do use that option, and would most likely complain if I removed it.
>>
>> Andy
>>
>> "Allen Browne" wrote in message
>> news:4734526f$0$23950$5a62ac22@per-qv1-newsreader-01.iinet.n et.au...
>>>I don't see a built-in shortcut for the date picker.
>>>
>>> You could create an AutoKeys macro, and assign a keystroke to RunCommand
>>> with ShowDatePicker.
>>>
>>> Alternatively, if you want this for one date box on one form, you could
>>> add a shortcut key to SetFocus to the date field, and then RunCommand
>>> acCmdShowDatePicker
>>>
>>> "Alfred" wrote in message
>>> news:n-mdnd3LCa6u2anaRVnyvQA@saix.net...
>>>> HI
>>>> Using Access 2007
>>>> Can I open the calendar that automatically appears next to date fields
>>>> with a keyboard shortcut as I dont want to use the mouse
>>>> Thanks
>>>> Alfred
>