date manipulation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WindAndWaves - 26 Sep 2004 03:23 GMT

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

Reply to this Message

Darryl Kerkeslager - 26 Sep 2004 03:56 GMT

Search Google for "Access date picker"

> Hi Gurus
>
[quoted text clipped - 14 lines]
>
> - Nicolaas

Reply to this Message

WindAndWaves - 27 Sep 2004 00:48 GMT

> Search Google for "Access date picker"
>
[quoted text clipped - 18 lines]
> >
> > - 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

Reply to this Message

Darryl Kerkeslager - 27 Sep 2004 02:16 GMT

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
[quoted text clipped - 5 lines]
> outlook (i.e. something sophisticated that allows the user to visualise
> dates and times and move them around).

Reply to this Message

WindAndWaves - 27 Sep 2004 02:01 GMT

> Suggestion 1:
>
[quoted text clipped - 36 lines]
> > 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

Reply to this Message

Pieter Linden - 27 Sep 2004 14:00 GMT

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.

Reply to this Message