Date picker and afterupdate event

[tricky300]

I have many date controls on different forms in different Access 2007 projects.

At least 2 of them have afterupdate events and it seems as if Access now
triggers an afterupdate event when the date control is entered/receives
focus. If you examine the date in the event sub you find that the oldvalue
and value properties are identical.

I can write code to get around this problem but I think this is an access
bug associated with date picker. I'm pretty sure there is another bug
associated with the date picker too, but a previous post regarding that fault
did not get any replies.

Has anyone else seen this behaviour? Is there a reason for it? Its a pain to
have to go through all my Access projects looking for situations where there
might be problems with what I suspect is an erroneous trigger of the
afterupdate event.

 

[Klatuu]

IMHO, date pickers are not good.
The date picker is an Active X control. I try to avoid them where I can.
Most data entry people can type a date in faster than than they can select
from a calendar. But, that is just me.

 

[Bob Quintal]

IMHO, date pickers are not good.
The date picker is an Active X control. I try to avoid them
where I can. Most data entry people can type a date in faster
than than they can select from a calendar. But, that is just
me.

Ther is a DatePicker on the Dev Ashish's Access Web site, written
in Access by Brian Kidwell, It works very well.

As to data entry, yes typing is often faster, but not when you are
presented with "Set the date to the 3rd friday in next September."

 

[Klatuu]

Good point, Bob; however, given something that specific, I would calculate it
and populate the control. But, with something like pick an available Friday,
it would be a reasonable thing to do.
(But, I still don't care much for Active X controls - kinda like trying to
get a pit bull to be a lap dog - with enough effort you can, but you can
count on getting bitten)

 

[Lungta]

There is a terrific calendar control (no OCX, no ActiveX) on John Viescas'
website, if anyone is interested. It was updated last month to accommodate
users regardless of their regional date settings.

www.viescas.com/Info/links.htm
Look for Calendar.zip (97 but can be converted easily) and select the NoOCX
file once unzipped. We're in a severely locked down environment and it works
great for our users.

 

[Bob Quintal]

Good point, Bob; however, given something that specific, I
would calculate it and populate the control. But, with
something like pick an available Friday, it would be a
reasonable thing to do. (But, I still don't care much for
Active X controls - kinda like trying to get a pit bull to be
a lap dog - with enough effort you can, but you can count on
getting bitten)

My comment was supposed to represent an ad hoc type request, not
something specific.

As to the DatePicker, the one I reccomend, by Brian Kidwell, is
pure Access: no Active X, no ocx, nothing but an Access form with
code.

 

[Klatuu]

I know, my response was somewhat tounge in cheek.
Do you have the link to Dev's web site? I would like to have a look at it.

 

[Douglas J. Steele]

Probably http://www.mvps.org/access/forms/frm0057.htm

 

[Klatuu]

Thanks, Doug

 

[Bob Quintal]

Probably http://www.mvps.org/access/forms/frm0057.htm

Yes, that is the correct url. Alternatively, from the author's site
at
http://www.glump.net/content/accessdatepicker/readme.htm