Calendar in MS 2007

[Alfred]

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]

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" <ad*******@gmail.comwrote in message
news:n-*********************@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

[ARC]

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" <Al*********@SeeSig.Invalidwrote in message
news:47***********************@per-qv1-newsreader-01.iinet.net.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" <ad*******@gmail.comwrote in message
news:n-*********************@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

[Allen Browne]

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" <PC*****@PCESoft.invalidwrote in message
news:nE*****************@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" <Al*********@SeeSig.Invalidwrote in message
news:47***********************@per-qv1-newsreader-01.iinet.net.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" <ad*******@gmail.comwrote in message
news:n-*********************@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

[ARC]

Thanks, Allen. The mask that I use most is: "99/99/0099;0;_"
"Allen Browne" <Al*********@SeeSig.Invalidwrote in message
news:47***********************@per-qv1-newsreader-01.iinet.net.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" <PC*****@PCESoft.invalidwrote in message
news:nE*****************@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" <Al*********@SeeSig.Invalidwrote in message
news:47***********************@per-qv1-newsreader-01.iinet.net.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" <ad*******@gmail.comwrote in message
news:n-*********************@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