By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,657 Members | 1,029 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,657 IT Pros & Developers. It's quick & easy.

date manipulation

P: n/a
Hi Gurus

This is a cry for help to all of you. I am looking for some sort of
plug-in/active X/code/link to outlook/what have you, which I can add to my
MS Access database for my users to manipulate dates.

For example, as part of my project, I have a roster. I want my users to
change the start and end times of the rostered people using a drop and drag
scenario rather than entering data.

Is there anyone that can send me in the right direction. I am happy to pay
for it, but it has to be versatile, good looking and user friendly.

Any suggestions? ( I have searched significantly)

Thank you
- Nicolaas
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Search Google for "Access date picker"
"WindAndWaves" <ac****@ngaru.com> wrote in message
news:aM*******************@news.xtra.co.nz...
Hi Gurus

This is a cry for help to all of you. I am looking for some sort of
plug-in/active X/code/link to outlook/what have you, which I can add to my
MS Access database for my users to manipulate dates.

For example, as part of my project, I have a roster. I want my users to
change the start and end times of the rostered people using a drop and drag scenario rather than entering data.

Is there anyone that can send me in the right direction. I am happy to pay for it, but it has to be versatile, good looking and user friendly.

Any suggestions? ( I have searched significantly)

Thank you
- Nicolaas

Nov 13 '05 #2

P: n/a

"Darryl Kerkeslager" <Ke*********@comcast.net> wrote in message
news:jq********************@comcast.com...
Search Google for "Access date picker"
"WindAndWaves" <ac****@ngaru.com> wrote in message
news:aM*******************@news.xtra.co.nz...
Hi Gurus

This is a cry for help to all of you. I am looking for some sort of
plug-in/active X/code/link to outlook/what have you, which I can add to my MS Access database for my users to manipulate dates.

For example, as part of my project, I have a roster. I want my users to
change the start and end times of the rostered people using a drop and

drag
scenario rather than entering data.

Is there anyone that can send me in the right direction. I am happy to

pay
for it, but it has to be versatile, good looking and user friendly.

Any suggestions? ( I have searched significantly)

Thank you
- Nicolaas



Hi Darryl

I took up on your suggestion, and I did find some simple date pickers, but
nothing that really cuts the mustard.

Unfortunately, I need something that is more than a datepicker, I need a
date/time manipulation tool, similart to, for example, the calender in
outlook (i.e. something sophisticated that allows the user to visualise
dates and times and move them around).

Thank you

- Nicolaas
Nov 13 '05 #3

P: n/a
Suggestion 1:

Search Google for a third party utility: "ActiveX calendar access"

Suggestion 2:

Try adding the ActiveX calendar control available in Access to a form and
working with that. I've never used it, and don't know what functionality it
gives you. (Calendar Ctrl 10.0 in Access 2002)
Of course, your customization options will be limited.

Suggestion 3:

You can use the functionality of Outlook if all of your users have Office.
This would seem to me to be by far the hardest way to go, but would also
yield by far the best results.

Suggestion 4:

Depending on your skill and time, create your own form, starting with the
same sort of look that the Calendar Control has, then making it do what you
want - 35 buttons, a few labels ... This would be the route I would
personally take, since I'm too cheap to buy third-party tools, Outlook is
too complex to spend the time to learn, and I'm too picky to use the given
ActiveX control.

Hope this is of some vague help.
Darryl Kerkeslager

I am looking for some sort of
plug-in/active X/code/link to outlook/what have you, which I can add
to
my MS Access database for my users to manipulate dates.


Unfortunately, I need something that is more than a datepicker, I need a
date/time manipulation tool, similart to, for example, the calender in
outlook (i.e. something sophisticated that allows the user to visualise
dates and times and move them around).

Nov 13 '05 #4

P: n/a

"Darryl Kerkeslager" <Ke*********@comcast.net> wrote in message
news:Mt********************@comcast.com...
Suggestion 1:

Search Google for a third party utility: "ActiveX calendar access"

Suggestion 2:

Try adding the ActiveX calendar control available in Access to a form and
working with that. I've never used it, and don't know what functionality it gives you. (Calendar Ctrl 10.0 in Access 2002)
Of course, your customization options will be limited.

Suggestion 3:

You can use the functionality of Outlook if all of your users have Office.
This would seem to me to be by far the hardest way to go, but would also
yield by far the best results.

Suggestion 4:

Depending on your skill and time, create your own form, starting with the
same sort of look that the Calendar Control has, then making it do what you want - 35 buttons, a few labels ... This would be the route I would
personally take, since I'm too cheap to buy third-party tools, Outlook is
too complex to spend the time to learn, and I'm too picky to use the given
ActiveX control.

Hope this is of some vague help.
Darryl Kerkeslager

> I am looking for some sort of
> plug-in/active X/code/link to outlook/what have you, which I can add

to
my
> MS Access database for my users to manipulate dates.
>


Unfortunately, I need something that is more than a datepicker, I need a
date/time manipulation tool, similart to, for example, the calender in
outlook (i.e. something sophisticated that allows the user to visualise
dates and times and move them around).



Dear Darryl

I liked your answer, that is interesting. I am already using that active X
thing. It is very useful, but also very limited (it is a date picker and
not a date manipulator that shows you events and the like).

From your options I would choose 4, but the problem is that I do not have a
spare three weeks. Therefore, I reckon I may want to explore 3. I will
start a new post to see if there is anyone out there who has used the
Outlook Calender.

Thank you once more

- Nicolaas
Nov 13 '05 #5

P: n/a
Nicolaas,
If you like to read the background stuff, there's an example of
manipulating the Outlook calendar from Access in Scott Barker's book,
"Access <version> Power Programming". Otherwise, I'm sure it's on the
MS site.
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.