date manipulation

[WindAndWaves]

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

[Darryl Kerkeslager]

Re: date manipulation

Search Google for "Access date picker"


"WindAndWav es" <access@ngaru.c om> wrote in message
news:aMp5d.6639 $JQ4.527460@new s.xtra.co.nz...[color=blue]
> 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[/color]
drag[color=blue]
> scenario rather than entering data.
>
> Is there anyone that can send me in the right direction. I am happy to[/color]
pay[color=blue]
> for it, but it has to be versatile, good looking and user friendly.
>
> Any suggestions? ( I have searched significantly)
>
> Thank you
>
>
> - Nicolaas
>
>[/color]

[WindAndWaves]

Re: date manipulation


"Darryl Kerkeslager" <Kerkeslager@co mcast.net> wrote in message
news:jqOdnQZ_H6 BvssvcRVn-iQ@comcast.com. ..[color=blue]
> Search Google for "Access date picker"
>
>
> "WindAndWav es" <access@ngaru.c om> wrote in message
> news:aMp5d.6639 $JQ4.527460@new s.xtra.co.nz...[color=green]
> > 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[/color][/color]
my[color=blue][color=green]
> > 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[/color]
> drag[color=green]
> > scenario rather than entering data.
> >
> > Is there anyone that can send me in the right direction. I am happy to[/color]
> pay[color=green]
> > for it, but it has to be versatile, good looking and user friendly.
> >
> > Any suggestions? ( I have searched significantly)
> >
> > Thank you
> >
> >
> > - Nicolaas
> >
> >[/color]
>
>[/color]

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

[Darryl Kerkeslager]

Re: date manipulation

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



[color=blue][color=green][color=darkred]
> > > I am looking for some sort of
> > > plug-in/active X/code/link to outlook/what have you, which I can add[/color][/color][/color]
to[color=blue]
> my[color=green][color=darkred]
> > > MS Access database for my users to manipulate dates.
> > >[/color][/color]
>
> 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).
>[/color]

[WindAndWaves]

Re: date manipulation


"Darryl Kerkeslager" <Kerkeslager@co mcast.net> wrote in message
news:Mt6dnQ_gR-6598rcRVn-uQ@comcast.com. ..[color=blue]
> 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[/color]
it[color=blue]
> 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[/color]
you[color=blue]
> 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
>
>
>
>[color=green][color=darkred]
> > > > I am looking for some sort of
> > > > plug-in/active X/code/link to outlook/what have you, which I can add[/color][/color]
> to[color=green]
> > my[color=darkred]
> > > > MS Access database for my users to manipulate dates.
> > > >[/color]
> >
> > 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).
> >[/color]
>
>[/color]



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

[Pieter Linden]

Re: date manipulation

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.