Connecting Tech Pros Worldwide Forums | Help | Site Map

Calendar in MS 2007

Alfred
Guest
 
Posts: n/a
#1: Nov 9 '07
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



Allen Browne
Guest
 
Posts: n/a
#2: Nov 9 '07

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
ARC
Guest
 
Posts: n/a
#3: Nov 14 '07

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
>
Allen Browne
Guest
 
Posts: n/a
#4: Nov 15 '07

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
ARC
Guest
 
Posts: n/a
#5: Nov 15 '07

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
>
Closed Thread