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. 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.
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!
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!
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!
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!
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!
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!
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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
|
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...
|
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,...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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....
|
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
|
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: 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...
| |