473,326 Members | 2,048 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,326 software developers and data experts.

Scheduling Template

I am looking for a scheduling template or will maybe have a go at creating
the database myself.

Basically, the database will include a table listing certain volunteers,
their volunteer number (employee number) and the group they are attached to
(department.) All volunteers are split up into 8 groups and each group is
led by a supervisor.

Now what I would like is for each volunteer to be able to access the
database on the Thursday of every week and enter their planned working hours
from the coming Sunday to the following Sunday. This would include the date,
start time and finish time.

Ideally, the end result will be that individuals will be able to enter their
hours and then, from an administrative menu / form, the supervisors will be
able to choose their group and see in advance of what volunteers they have
coming in and when.

Any ideas? I am looking for either a template I can modify or any advice on
structuring my tables.
Nov 13 '05 #1
7 3626
TblVolunteer
VolunteerID
FirstName
MI
LastName
EmpNumIsSupervisor (Yes/No)
<<Any Other Fields Of Information About Volunteers You Need>>

TblGroup
GroupID
GroupName

TblGroupSupervisor
GroupSupervisorID
VolunteerID

TblGroupMember
GroupMemberID
VolunteerID

TblVolunteerWorkHour
VolunteerWorkHourID
VolunteerID
Workdate
StartTime
FinishTime

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Neil Greenough" <ne***********@btopenworld.com> wrote in message
news:cl**********@hercules.btinternet.com...
I am looking for a scheduling template or will maybe have a go at creating
the database myself.

Basically, the database will include a table listing certain volunteers,
their volunteer number (employee number) and the group they are attached to (department.) All volunteers are split up into 8 groups and each group is
led by a supervisor.

Now what I would like is for each volunteer to be able to access the
database on the Thursday of every week and enter their planned working hours from the coming Sunday to the following Sunday. This would include the date, start time and finish time.

Ideally, the end result will be that individuals will be able to enter their hours and then, from an administrative menu / form, the supervisors will be able to choose their group and see in advance of what volunteers they have
coming in and when.

Any ideas? I am looking for either a template I can modify or any advice on structuring my tables.

Nov 13 '05 #2
TblVolunteer
VolunteerID
FirstName
MI
LastName
EmpNumIsSupervisor (Yes/No)
<<Any Other Fields Of Information About Volunteers You Need>>

What does "MI" stand for?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3
How about Middle Initial? Just a guess
Patrick

On 18 Oct 2004 18:48:18 GMT, Neil Greenough
<ne***********@btopenworld.com> wrote:
TblVolunteer
VolunteerID
FirstName
MI
LastName
EmpNumIsSupervisor (Yes/No)
<<Any Other Fields Of Information About Volunteers You Need>>

What does "MI" stand for?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Nov 13 '05 #4
Yes, that's correct!
"Patrick Fisher" <in**@psoftuk.com> wrote in message
news:9h********************************@4ax.com...
How about Middle Initial? Just a guess
Patrick

On 18 Oct 2004 18:48:18 GMT, Neil Greenough
<ne***********@btopenworld.com> wrote:
TblVolunteer
VolunteerID
FirstName
MI
LastName
EmpNumIsSupervisor (Yes/No)
<<Any Other Fields Of Information About Volunteers You Need>>

What does "MI" stand for?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #5
The GroupMemberID in the tblGroupMember, does that relate to the =
department if you like and that is how the Volunteer is matched up with =
their specific group? I am just looking at the relationships now in this =
database you see.....
"PC Datasheet" <no****@nospam.spam> wrote in message
news:Xg**************@newsread3.news.atl.earthlink .net...
Yes, that's correct!
"Patrick Fisher" <in**@psoftuk.com> wrote in message
news:9h********************************@4ax.com...
How about Middle Initial? Just a guess
Patrick

On 18 Oct 2004 18:48:18 GMT, Neil Greenough
<ne***********@btopenworld.com> wrote:
TblVolunteer
VolunteerID
FirstName
MI
LastName
EmpNumIsSupervisor (Yes/No)
<<Any Other Fields Of Information About Volunteers You Need>>

What does "MI" stand for?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Nov 13 '05 #6
The GroupMemberID in the tblGroupMember, does that relate to the
department if you like and that is how the Volunteer is matched up with
their specific group? I am just looking at the relationships now in this
database you see.....

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #7
Sorry, Neil, I omitted a field ---
Should be:
TblGroupMember
GroupMemberID
GroupID
VolunteerID

GroupID identifies the specific group a member belongs to.

Steve
PC Datasheet

"Neil Greenough" <ne***********@btopenworld.com> wrote in message
news:cl**********@hercules.btinternet.com...
The GroupMemberID in the tblGroupMember, does that relate to the =
department if you like and that is how the Volunteer is matched up with =
their specific group? I am just looking at the relationships now in this =
database you see.....
"PC Datasheet" <no****@nospam.spam> wrote in message
news:Xg**************@newsread3.news.atl.earthlink .net...
Yes, that's correct!
"Patrick Fisher" <in**@psoftuk.com> wrote in message
news:9h********************************@4ax.com...
How about Middle Initial? Just a guess
Patrick

On 18 Oct 2004 18:48:18 GMT, Neil Greenough
<ne***********@btopenworld.com> wrote:

>TblVolunteer
>VolunteerID
>FirstName
>MI
>LastName
>EmpNumIsSupervisor (Yes/No)
><<Any Other Fields Of Information About Volunteers You Need>>
>
>What does "MI" stand for?
>
>
>
>
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!



Nov 13 '05 #8

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

Similar topics

6
by: Tony Proctor | last post by:
Hi everyone We're experiencing some serious anomalies with the scheduling of ASP threads. I'd be interested to hear if anyone knows what algorithm is used (e.g. simple round-robin, or something...
13
by: Mike | last post by:
Normally scheduling a job is a very elementary operation but for some hidden reason I've been unable to schedule a job which runs on a 28 day cycle, even though I have at least 16 other jobs...
3
by: Muscha | last post by:
Hi, In our application we need to have a high performance scheduling framework. We want to be able to say for item 21 do an update on such and such time. We will have around 1 million items of...
3
by: mirek | last post by:
Hello, My ASP.NET application must have additional functionality which isn't typical for ordinary web use. It is: - connecting to the other server using specified protocol (an option to...
3
by: Alphonse Giambrone | last post by:
Can anyone point me toward a good example of an asp.net scheduling app? Preferrably in vb.net. TIA -- Alphonse Giambrone Email: a-giam at customdatasolutions dot us
1
by: Majed | last post by:
hi I'm planing to make scheduling app and need your advice on the best way to do that,and how to save the tasks to be executed and retrive their data at the right time. your input will be highly...
0
by: Lemune | last post by:
Hello. I need some help on building my sms services application (using modem). My application is to do some scheduling task based on daily, weekly and monthly. On the daily the choice are everyday,...
4
by: Dinsdale | last post by:
I'm looking at adding scheduling features to an application and I wanted to ask the community about any experience with scheduling components, either open source like from code project or from a...
2
Ritchie
by: Ritchie | last post by:
Please can anyone help me with d programs in C for CPU scheduling: WAP to show FCFS scheduling algorithm. WAP to show SJF scheduling algorithm. WAP to show Priority scheduling algorithm. WAP...
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: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.