Date Picker

Thanks for the reply.

Using Double Click is a great idea, only I like the graphical interface. A
picture of a calendar looks better than a string of text. I guess even
Microsoft proved that when they automated the date picker icon to appear on
text boxes marked with "Date/time" as the format.

I did notice that on your sample, the text boxes do not have the format set
to date/time.

I might post this again in a broader discussion group another time. As
yet, I still haven't found a way to turn it off.


"Arvin Meyer [MVP]" wrote:

I think you can delete it. If you have a 2003 or earlier version, it should
run fine in 2007. Until I get fully used to 2007, I work in 2002 or 2003 (or
sometimes even in Access 97), and then test on a 2007 machine.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Dom" wrote in message
...
I too have always provided a custom date picker in every application I've
developed and now Vista has caused me great grief in the the picker icon
happens to be in the same place as my "Open Calendar Dialog" button.

Is there an Option I can set to stop that picker appearing?


"Arvin Meyer [MVP]" wrote:

This is one of the reasons I use my own Access form as a calendar. The
calling event can also run other code.:

http://www.datastrat.com/Download/Calendar2K.zip

The calendar is written in VBA and will run in 2007 as is or converted to
the 2007 format.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"spike_h" wrote in message
...
The in-built date picker is a great function in Access 2007, but anyone
know
how to
apply an Event Procedure (eg Refresh or Requery) after selecting a date
using
the datepicker? Selecting a date seems merely to enter the data into
the
field and no event actually occurs until tabbing out of the control. I
use
several forms based on queries with a user-defined date range - Have I
missed
something or is this a bug....
(I know it is quicker just to input a date from the keyboard, but users
seem
to like this popup datepicker function)

Use a command button with a calendar image, or even a plain small calendar
icon, with a transparent button on top.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Dom" wrote in message
news
Thanks for the reply.

Using Double Click is a great idea, only I like the graphical interface.
A
picture of a calendar looks better than a string of text. I guess even
Microsoft proved that when they automated the date picker icon to appear
on
text boxes marked with "Date/time" as the format.

I did notice that on your sample, the text boxes do not have the format
set
to date/time.

I might post this again in a broader discussion group another time. As
yet, I still haven't found a way to turn it off.


"Arvin Meyer [MVP]" wrote:

I think you can delete it. If you have a 2003 or earlier version, it
should
run fine in 2007. Until I get fully used to 2007, I work in 2002 or 2003
(or
sometimes even in Access 97), and then test on a 2007 machine.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Dom" wrote in message
...
I too have always provided a custom date picker in every application
I've
developed and now Vista has caused me great grief in the the picker
icon
happens to be in the same place as my "Open Calendar Dialog" button.

Is there an Option I can set to stop that picker appearing?


"Arvin Meyer [MVP]" wrote:

This is one of the reasons I use my own Access form as a calendar. The
calling event can also run other code.:

http://www.datastrat.com/Download/Calendar2K.zip

The calendar is written in VBA and will run in 2007 as is or converted
to
the 2007 format.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"spike_h" wrote in message
...
The in-built date picker is a great function in Access 2007, but
anyone
know
how to
apply an Event Procedure (eg Refresh or Requery) after selecting a
date
using
the datepicker? Selecting a date seems merely to enter the data into
the
field and no event actually occurs until tabbing out of the control.
I
use
several forms based on queries with a user-defined date range - Have
I
missed
something or is this a bug....
(I know it is quicker just to input a date from the keyboard, but
users
seem
to like this popup datepicker function)