Recurring Event 1

[tqd123]

I am writing a module for our HR department on recurring events, but I am not sure on how to do it in Microsoft Access. The goal is similar to Outlook's recurring tasks (i.e. repeat daily, weekly, or certain day, etc.)

Any help would be greatly appreciated.

TQD

 

[TheAceMan1]

How are ya tqd123 . . .

Your post is vague at best. An example . . . would open the door for you! . . .

See Ya! . . . . . .

 

[tqd123]

Sorry AceMan,

What I want to do is to set a task in MS Access, then set the same task for recurrence of daily, weekly, or monthly.

Hope that's enough info.

Thanks,

TQD

 

[Eupher]

tqd123,

Do you mean like the backup scheduler in MS Backup? I have done something similar. Lemme tell ya, it was a fair amount of work, both from a coding and form design standpoint.

Unfortunately I don't have any of the code at hand right this moment. It's in a production DB at work, and I'm on vacation until Monday. If this thread is still alive (and someone hasn't already adequately addressed your question), I'll post some code.

Ken S.

 

[tqd123]

Eupher,

I want to schedule recurring appointments or things to do similar to Outlook Calendar where I can shedule daily, weekly, monthly, etc.

I am writing a module for my HR department without using Outlook.

Thanks,

TQD

 

[MajP]

I have done this before and as Eupher said it can be complicated but it depends how you want to do it. You are going to have to provide some details. I assume you have some kind of table that holds appointments and you show these somehow in a calendar type view.
In my application I saved all reocurring events in a seperate table with fields such as start, stop, reoccurence rate,etc. The trick is that these appointments get loaded dynamically on all views first, since unlike the other appointments they are not assigned to a specific date.
Making a reocurring appointment is easy, but there are usually a lot of places in the application where you have to dynamically populate these appointments.
You are going to have to supply much more details. Depending on what you want to do this could be simple or extremely complicated.