Date Picker

[Guest]

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)

 

[missinglinq via AccessMonster.com]

Haven't worked with ACC2007, but I'm assuming the date is assigned to the
given field in the DP's AfterUpdate event. Go into the code editor, find this
event and place your refresh/requery code after the date's been inserted.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Arvin Meyer [MVP]]

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.

 

[Guest]

Many thanks - great. It is just a pity that MS havent given the datepicker
its own property sheet...

 

[Guest]

Sorry, but as far as I can see, the datepicker has no property sheet to
configure events - hence the problem.

 

[missinglinq via AccessMonster.com]

This must be something new in 2007. In previous versions ActiveX items, such
as DatePicker only had limited Property Box items, but their full properties
were available thru the VB Editor, you just had to know to look for them.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Guest]

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?

 

[Guest]

Sorry, let me rephase that.

I have a custom date picker dialog form. I put the button to open that form
next to text boxes where the user enters the date. Because I set the format
to "Date/Time", in VISTA an icon appears over the top of my button.

How do I stop the default Vista date picker icon from appearing when the
user enters my text box?

 

[Arvin Meyer [MVP]]

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

 

[Arvin Meyer [MVP]]

Look at the code in my calendar app.:

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

It uses the Double-Click event. Superfast typists who prefer not to use a
mouse, simply type in a date. Any one who, like me, likes the mouse, simply
reaches over and double-clicks on it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

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]]

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