Using access to schedule help

[scoobz1234]

Good Morning!



I am trying to figure out how to (if possible) to create an Event Table and from that 2 Forms and Report.

TblEvents = an Events table
FrmCreateEvent = to add events to TblEvents
FrmSchedule = i would like this form to be able to have people entered to "schedule" them to attend an event listed in TblEvents
RptAttending = Report to show events and whose attending.



(in the Rpt it will have to show several things about the personnell. i have another Tbl that has all this information located.)
im not asking anyone to do this for me, maybe a little help or a point in the right direction.

thank you in advance for all your help!

[burrina]

Here is an example of table structure you can get ideas from, it is a scheduling db.

EventID PK
EventDescrip Description of what this event is
EventStart First occurance of what event is
RecurCount How many times event will recur.0 for one-off event. Leave blank if opend ended
PeriodFreq Type of period for recurrences (day,month,year)

tblEvent
________________________________________________
EventID PK
InstanceID Number Instance number.Zero for original.Comb of EventId+CountID must be unique
InstanceDate Date instance is to be rescheduled
IsCanned number Checked box indicates this instance is cancelled
InstanceComment Why it was cancelled/rescheduled

tblEventException

__________________________________________________ __

CountID Pk Unique number. Used for Cartesian product queries.

tblCount
__________________________________________________ __

PeriodTypeID PK (text) Unique code for field as defined by DateDiff() 4 Charac Max
PeriodType Text Unique name for this period type 24 character max.
SortOrder Number Lower numbers sort first.

tblPeriodType

[scoobz1234]

Wow, i am so confused. What is all that information you posted? i don't believe i have been subjected to code/information like that yet. thank you for your response though!

[burrina]

It was simply to show you how a scheduler db can be setup. This structure is one that I currently use. Sorry if it confused you. I gave you the table names, and fields with explanations. Good Luck with your project.

[scoobz1234]

no reason to be sorry at all, thank you for your help! im still a beginner with access and i appreciate your help.

[GeminiJoy]

Hi Burrina,
Sorry to bother you but it looks like you might be an expert and I'm having problems working with Allen Browne's recurring tasks database. It looks exactly how you have it above. However I am totally lost when it comes to querying his Cartesian query product. I need to query which tasks are due in the next 30 day, which are overdue, etc. My queries don't work when I try to query his existing query. Anyways the query I started is called 1-testdue . If you have any time to look at it I would be most appreciative. The file is on my Google Drive Here: https://drive.google.com/file/d/1-8W...ew?usp=sharing
Thanks for taking the time to read this and for any information you can provide

[pbaldy]

Post 6 was moderated, I'm posting to trigger email notifications.

[davegri]

Scoo, here's a db for scheduling events. 3 tables, one for events, one for participants and another to link the former two. Includes reports and maintenance forms for the events and participants. Complete solution, VBA with no embedded macros.
Generic-EventsSchedule V001.zip

[GeminiJoy]

Thanks for responding! This is a great tool for scheduling davegri but I need to specifically track recurring events for auditing purposes.
For example, I need to do a certain task every month or quarter.
I'm looking for a system (like Outlook which we can't use for management reasons) that will allow me to enter repeating events based on a time pattern (weekly, quarterly, every 6 weeks, every 10 days, etc.). Then I need to be able to query those event's, which would be easy if each record was it's own but with the cross join (cartesian) query I can't figure it out.

Allen Browne explains more about it here http://allenbrowne.com/AppRecur.html however he doesn't complete each event, he only records the exceptions to the events which is a nice bonus but not exactly fulfilling my needs. I was hoping to just tinker his database.

[davegri]

Thanks for responding! This is a great tool for scheduling davegri but I need to specifically track recurring events for auditing purposes.

Sorry it won't work for you. It totally meets the requirements stated in Post #1, but post #9 describes a quite different animal.

[GeminiJoy]

Yeah sorry I'm new I was hoping to trigger a response from burrina but I should have posted a new question I guess. That's what I get for trying to follow rules lol

[pbaldy]

Burrina hasn't posted in years, so perhaps has other interests now. A new thread specifying your needs would probably attract more attention.