I have a similar question. I need to implement a recurring event scheduling system similar to the options found in outlook. Basically I need to be able to schedule events on either a weekly basis (eg, every 2 weeks on thursday) or a monthly basis (eg, every 3 months on the 4th wednesday).
I have seen some examples on the web (and on these forums), but non can preform both.
All events would repeat indefinitely, and I don't need to worry about exceptions. The schedule would only include weekdays, excluding Saturday and Sunday.
Thanks!
princess_emef wrote:
Recurring events
16-Dec-09
How do I implement recurring events in MS Access?
Previous Posts In This Thread:
Recurring events
How do I implement recurring events in MS Access?
Need more input!What is recurring? Preventive maintenance inspection? Rent?
Need more input!
What is recurring? Preventive maintenance inspection? Rent?
What will you do with the data?
What will your table structure look like?
--
Build a little, test a little.
:
Best article I found was:
http://www.allenbrowne.com/AppRecur.
Best article I found was:
http://www.allenbrowne.com/AppRecur.html
If you are using some kind of third-party calendar control you could use
some of their built-in logic to handle complex types of recurring events, or
write a lot of code to handle things. The allen browne article i think is
geared more towards creative sql to handle recurring events (simple types of
recurrrence).
You left the question pretty broad.
HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com
It would help if you were a lot more specific regarding your needs.
It would help if you were a lot more specific regarding your needs. However,
there is a sample MDB that might help at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=18.
--
Duane Hookom
Microsoft Access MVP
:
Submitted via EggHeadCafe - Software Developer Portal of Choice
Making Silverlight Emulate Synchronous Requests
http://www.eggheadcafe.com/tutorial...1-c5c717c9b184/making-silverlight-emulat.aspx