Calendar in MS 2007 
November 9th, 2007, 11:35 AM
| | | |
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
|
November 9th, 2007, 12:35 PM
| | | | 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" <adminnaar@gmail.comwrote in message
news:n-mdnd3LCa6u2anaRVnyvQA@saix.net... Quote:
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
| |
November 14th, 2007, 10:35 PM
| | | | 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" <AllenBrowne@SeeSig.Invalidwrote in message
news:4734526f$0$23950$5a62ac22@per-qv1-newsreader-01.iinet.net.au... Quote:
>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" <adminnaar@gmail.comwrote in message
news:n-mdnd3LCa6u2anaRVnyvQA@saix.net... Quote:
>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
| >
| |
November 15th, 2007, 12:35 AM
| | | | 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" <PCESoft@PCESoft.invalidwrote in message
news:nEK_i.6858$TR5.5516@nlpi061.nbdc.sbc.com... Quote:
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" <AllenBrowne@SeeSig.Invalidwrote in message
news:4734526f$0$23950$5a62ac22@per-qv1-newsreader-01.iinet.net.au... Quote:
>>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" <adminnaar@gmail.comwrote in message
>news:n-mdnd3LCa6u2anaRVnyvQA@saix.net... Quote:
>>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
| | | |
November 15th, 2007, 12:45 AM
| | | | re: Calendar in MS 2007
Thanks, Allen. The mask that I use most is: "99/99/0099;0;_"
"Allen Browne" <AllenBrowne@SeeSig.Invalidwrote in message
news:473b9167$0$10702$5a62ac22@per-qv1-newsreader-01.iinet.net.au... Quote:
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" <PCESoft@PCESoft.invalidwrote in message
news:nEK_i.6858$TR5.5516@nlpi061.nbdc.sbc.com... Quote:
>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" <AllenBrowne@SeeSig.Invalidwrote in message
>news:4734526f$0$23950$5a62ac22@per-qv1-newsreader-01.iinet.net.au... Quote:
>>>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" <adminnaar@gmail.comwrote 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
| | >
| |  |
| | |  /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 225,662 network members.
|
