Setting Future Dates, like a scheduler for a to do list

[Lumpierbritches]

Can this be done in access by a lay person? Also, are there any tutorials for
this type of addition to your applications?

I'm trying to use a calendar control to set a date in the future for a to do
list, similar to a PIM. If the date exists, then I want to open that date, if
it doesn't I want to create that date. Thought about make table query, but not
sure to go from there.

Any help would greatly be appreciated. I searched Deja News and Google and kept
seeing the same thing, either buy, or there wasn't anything. Oh and I'm using
Access 97.

Michael

[Mike Storr]

Re: Setting Future Dates, like a scheduler for a to do list

Your question is not entirely clear.
The Calendar control is simply a graphical tool for returning/selecting a
Date value. What you do with it beyond that has nothing to do with the
control. If you are asking if the "lay person" can create a PIM application,
then I would tend to say, "Yes..A simple one." If you are asking how to
create a PIM, then the answer is much longer and would depend a lot on what
exactly you want the app to do. If you are asking what to do with the
returned date, again it depends on what exactly you want the app to do. For
"the lay person" who is not interested in the challenge, purchasing a PIM
(Like Outlook for instance) would be far simpler.

Mike Storr

https://www.veraccess.com

"Lumpierbritche s" <lumpierbritche s@aol.com> wrote in message
news:2004042311 0356.22258.0000 0048@mb-m01.aol.com...[color=blue]
> Can this be done in access by a lay person? Also, are there any tutorials[/color]
for[color=blue]
> this type of addition to your applications?
>
> I'm trying to use a calendar control to set a date in the future for a to[/color]
do[color=blue]
> list, similar to a PIM. If the date exists, then I want to open that date,[/color]
if[color=blue]
> it doesn't I want to create that date. Thought about make table query, but[/color]
not[color=blue]
> sure to go from there.
>
> Any help would greatly be appreciated. I searched Deja News and Google and[/color]
kept[color=blue]
> seeing the same thing, either buy, or there wasn't anything. Oh and I'm[/color]
using[color=blue]
> Access 97.
>
> Michael[/color]

[Lumpierbritches]

Re: Setting Future Dates, like a scheduler for a to do list

Mike,

Thank you for your reply. I'm trying to use the Calendar control to create a
date book in access to schedule future events, with dates only. I'm trying to
find some tips or code on how to do this.

I know the calendar control is just for date input, so how do I create a form,
on the fly to store date events or do I check to see if that date is already
there, so I don't have more than one date floating around for events?

Michael

[Don Leverton]

Re: Setting Future Dates, like a scheduler for a to do list

Hi Mike,

In it's simplest form, it's not too tough:

1.) Create an unbound form called "frmAppointment s"
2.) Add an ActiveX calendar control named "MyCal", and a subform called
"sbfAppointment s" which is bound to "tblAppointment s"
3.) Set the LinkMaster to "MyCal " and the LinkChild to "ApptDate"
4.) Add some code to set the date to today's date when the form loads.
5.) Tools / Startup ... Display Form: "frmAppointment s"


Option Compare Database
Option Explicit

Private Sub Form_Load()
Me.MyCal = Date
End Sub

Private Sub MyCal_AfterUpda te()
Me.sbfAppointme nts.Requery
End Sub

Now as soon as you open your database, all appointments for today are
displayed in the subform.
New appointments can also be added for the date selected, using the same
subform.

IF the subform was a lttle too small to "get all the details", you could do
something like double-click on the "ApptID" field in the subform and have a
new full-sized form called "frmAppointment Details" open to the same record.
(Just an idea.)


--
HTH,
Don
=============== ==============
Use My.Name@Telus.N et for e-mail
Disclaimer:
Professional PartsPerson
Amateur Database Programmer {:o)

I'm an Access97 user, so all posted code
samples are also Access97- based
unless otherwise noted.

Do Until SinksIn = True
File/Save, <slam fingers in desk drawer>
Loop

=============== =============== ==






"Lumpierbritche s" <lumpierbritche s@aol.com> wrote in message
news:2004042418 1330.10667.0000 0219@mb-m17.aol.com...[color=blue]
> Mike,
>
> Thank you for your reply. I'm trying to use the Calendar control to create[/color]
a[color=blue]
> date book in access to schedule future events, with dates only. I'm trying[/color]
to[color=blue]
> find some tips or code on how to do this.
>
> I know the calendar control is just for date input, so how do I create a[/color]
form,[color=blue]
> on the fly to store date events or do I check to see if that date is[/color]
already[color=blue]
> there, so I don't have more than one date floating around for events?
>
> Michael[/color]