473,320 Members | 1,857 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

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
Nov 12 '05 #1
3 1290
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
www.veraccess.com
"Lumpierbritches" <lu*************@aol.com> wrote in message
news:20***************************@mb-m01.aol.com...
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

Nov 12 '05 #2
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
Nov 12 '05 #3
Hi Mike,

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

1.) Create an unbound form called "frmAppointments"
2.) Add an ActiveX calendar control named "MyCal", and a subform called
"sbfAppointments" which is bound to "tblAppointments"
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: "frmAppointments"
Option Compare Database
Option Explicit

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

Private Sub MyCal_AfterUpdate()
Me.sbfAppointments.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 "frmAppointmentDetails" open to the same record.
(Just an idea.)
--
HTH,
Don
=============================
Use My*****@Telus.Net 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

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


"Lumpierbritches" <lu*************@aol.com> wrote in message
news:20***************************@mb-m17.aol.com...
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

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

19
by: Eric | last post by:
I'm trying to have some scripts run periodically on Windows XP and found the "Task Scheduler" did not execute my scripts. My scripts are of the form scriptName.py, and will run just by invoking that...
242
by: James Cameron | last post by:
Hi I'm developing a program and the client is worried about future reuse of the code. Say 5, 10, 15 years down the road. This will be a major factor in selecting the development language. Any...
3
by: Lumpierbritches | last post by:
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...
8
by: MLH | last post by:
Anybody's solution would be appreciated. Pls, do not pause to write anything for this. I'm not looking for that kind of a handout. I have an idea about how to do it, but I wanted to see if anyone...
7
by: Shane Story | last post by:
Have an app and would like to allow easy addition of MYAPP.EXE /F /P (for example) my prog with command line args, as a job to be run. Would like to make it easier on the user to run the app. ...
1
by: Liam.M | last post by:
I currently HAVE a form...a "Summary List" it could be called...which is a contineous form...AND on this form are "Four fields" from EVERY record (each on their own line) so to seak...like a...
1
by: laredotornado | last post by:
Hi, I'm using PHP 4.4.4 on Apache 2 on Fedora Core 5. PHP was installed using Apache's apxs and the php library was installed to /usr/local/php. However, when I set my "error_reporting"...
3
by: lsmith | last post by:
Dear group, I am the new volunteer coordinator for a non-profit organization in Tucson, AZ. One of my main focuses is to develop our own volunteer pool using either MS Access 2002 or Excel...
2
by: =?Utf-8?B?Sm9ubnk=?= | last post by:
I have an ASP.NET 2.0 C# web application that is contacting an Exchange server using WEBDAV. It allows the users to look up appointments for a future date. The problem I have is determining the...
3
by: NDayave | last post by:
How Do, Is there any way to get a drop down menu to show all dates into the future, without entering them into a table beforehand? I really don't want to use the calendar control, but I need to...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.