Date and Time Picker - and general Service Packs updates

[Guest]

Hi

I use the Date and Time Picker. i know that i can get many other calendars,
however, my theory is that i would rather use something that is directly
supported by microsoft. but as i found out now that may not be the case.

on of my users updated his Office 2003 after he was having problems using my
database (created on 2002 sp3). i know that the same database works on 2003
sp1. however, now microsoft is serving 2003 sp2. so after the update he he
can't use the database.

so my questions:

1. how do i generally prevent users from getting update errors. i would like
to atleast alert them with a meaningful message that their version of Office
needs to be updated.

2. is this true that the Date and Time Picker doesn't work anymore? and if
so, why isn't backwards compatible? and how do i prevent this from happening
with other controls or scripts?

thanks,

sam

 

[Guest]

Hi Sam,

Your problems with this ActiveX control is exactly why many developers avoid
using controls if at all possible. Check out this recent post by MVP Allen
Browne on this subject:

http://groups.google.com/group/micr..._frm/thread/5f2c0bb7b7020190/2d0bd2496f0ad389


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hi

I use the Date and Time Picker. i know that i can get many other calendars,
however, my theory is that i would rather use something that is directly
supported by microsoft. but as i found out now that may not be the case.

on of my users updated his Office 2003 after he was having problems using my
database (created on 2002 sp3). i know that the same database works on 2003
sp1. however, now microsoft is serving 2003 sp2. so after the update he he
can't use the database.

so my questions:

1. how do i generally prevent users from getting update errors. i would like
to atleast alert them with a meaningful message that their version of Office
needs to be updated.

2. is this true that the Date and Time Picker doesn't work anymore? and if
so, why isn't backwards compatible? and how do i prevent this from happening
with other controls or scripts?

thanks,

sam

 

[Guest]

thanks for your reply.
i have seen some of these calendar modules. i am wondering if those are
better than using an activeX control that is distributed by Microsoft?

sam

 

[Arvin Meyer [MVP]]

Try the calendar I wrote as an Access form. It has worked in every version
of Access (including the next one) since Access 2.0, and may even work in 1x
(but it's never been tested there) If changing database format, you do have
to convert it, but that has never been a problem since it converts with the
rest of the database.

http://datastrat.mvps.org/Download/Calendar2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Hi Sam,

Definately much better....unless you enjoy having to deal with such problems
caused by ActiveX control issues.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:
thanks for your reply.
i have seen some of these calendar modules. i am wondering if those are
better than using an activeX control that is distributed by Microsoft?

sam
__________________________________________

:
Hi Sam,

Your problems with this ActiveX control is exactly why many developers avoid
using controls if at all possible. Check out this recent post by MVP Allen
Browne on this subject:

http://groups.google.com/group/micr..._frm/thread/5f2c0bb7b7020190/2d0bd2496f0ad389


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hi

I use the Date and Time Picker. i know that i can get many other calendars,
however, my theory is that i would rather use something that is directly
supported by microsoft. but as i found out now that may not be the case.

on of my users updated his Office 2003 after he was having problems using my
database (created on 2002 sp3). i know that the same database works on 2003
sp1. however, now microsoft is serving 2003 sp2. so after the update he he
can't use the database.

so my questions:

1. how do i generally prevent users from getting update errors. i would like
to atleast alert them with a meaningful message that their version of Office
needs to be updated.

2. is this true that the Date and Time Picker doesn't work anymore? and if
so, why isn't backwards compatible? and how do i prevent this from happening
with other controls or scripts?

thanks,

sam

 

[Guest]

Thanks a lot Tom. I have been looking around and people all over are saying
exactly whar you are saying. that these ActiveX controls have versioning
problems. i didn't check my bible (getz's two volume access book) , but i am
sure he says the same thing.

Arvin - thanks a lot... it looks nice. i am just wondering if i will be able
to redesign it. i need to be a drop bigger. i am sure i'll figure it out.

thanks all,

sam