Hi,
As something of a pet project, I'm looking to develop a tool to track
employee holiday (or vacation for those of us in the US) for my company -
good for the company (if I get something usuable working) and good practice
for me.
Before I even open Access I want to get the relationships sorted.
First looks indicate two basic entities:
Employee
- ID
- Forename
- Surname
- Dept
- other employee details.... etc etc
- holiday allowance (number of days)
Holiday
- Holiday ID
- Employee ID
- Holiday Start Date
- Holiday End Date
Then its a simple one Employee to many Holiday records. Queries can handle
days taken by employee X and so on. Business rules handled by forms (not
letting X take more than their allowance, etc).
Now assuming that is a workable model, what I'd like to do (and this is
where I'm stuck) is to include a feature where I can link employees so for
example, employee X cannot be on holiday if employee Y is on holiday that
date or employee Z is. I.e. with-in a department there may be that only two
of its employees may be off at any one time.
Any ideas? I'm near certain I'm going to require another table linked to
employees but I'm stuck as to how to develop it. Can anyone suggest how I
should develop my table structures. I don't want to be spoon fed but some
pointers in the right direction would be greatly appreciated.
Any and all replies are gratefully received.
Thanks
Chris. 1 14948
1. Your model contemplates all vacations taken in full days, doesn't it?
What about 2 hours at a time?
2. I would store holidays by single day, rather than start date and end
date, so a 5 day holiday would have 5 entries, not just one. For queries,
it would be much faster to query for a specific day, rather than a range of
days
3. I personally would not handle the conflicts by table constraints. If an
employee wants to take a holiday on Nov 25, then run a query to check if the
date is already in use, ex.
"SELECT Count(*) FROM holiday WHERE hol_date = #" & Me.txtDate & "#"
Darryl Kerkeslager
"Chris Strug" <ho*****@solace 1884.com_SWAP_D OMAIN_AND_USERN AME> wrote in
message news:9h******** **********@text .news.blueyonde r.co.uk... Hi,
As something of a pet project, I'm looking to develop a tool to track employee holiday (or vacation for those of us in the US) for my company - good for the company (if I get something usuable working) and good
practice for me.
Before I even open Access I want to get the relationships sorted.
First looks indicate two basic entities:
Employee - ID - Forename - Surname - Dept - other employee details.... etc etc - holiday allowance (number of days)
Holiday - Holiday ID - Employee ID - Holiday Start Date - Holiday End Date
Then its a simple one Employee to many Holiday records. Queries can handle days taken by employee X and so on. Business rules handled by forms (not letting X take more than their allowance, etc).
Now assuming that is a workable model, what I'd like to do (and this is where I'm stuck) is to include a feature where I can link employees so for example, employee X cannot be on holiday if employee Y is on holiday that date or employee Z is. I.e. with-in a department there may be that only
two of its employees may be off at any one time.
Any ideas? I'm near certain I'm going to require another table linked to employees but I'm stuck as to how to develop it. Can anyone suggest how I should develop my table structures. I don't want to be spoon fed but some pointers in the right direction would be greatly appreciated.
Any and all replies are gratefully received.
Thanks
Chris.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: RSH |
last post by:
I am really trying to grasp the concept of OOP as it applies to C#.
I am looking at trying to set up a simple Employee Class but I am having
trouble conceptualizing what this class should look like. I was hoping
someone might be able to simply outline what I envision my class to look
like:
Basically I am envisioning a Class called Employee:
I imagine it would have many properties(?) such as:
|
by: Yeah |
last post by:
I have a web site which changes the header logo based on the upcoming
holiday.
For example, from December 10th to 25th, XMAS.JPG is displayed. From October
20th to 31st, HALLWEEN.JPG is displayed. Etc. etc. If today's date is not
near a holiday, then the default LOGO.JPG is displayed.
A while back, I was looking for a JavaScript that does this automagically.
But each snippet I found traditionally displays the default logo for a...
|
by: Jana |
last post by:
Greetings Access Gurus! I am working on an app to send batch
transactions to our bank, and the bank requires that we place an
effective date on our files that is 'one business day in the future,
excluding holidays and weekends.' I didn't want to build a table of
holidays that would have to be continuously updated, so I searched high
and low for a function that would tell me whether a given date was a
holiday, to no avail. I did find an...
|
by: keri |
last post by:
Hi everyone,
Having learnt a little about the basics whilst creating my first db I
am now about to start creating a good one!
I am about to sit down with a large piece of paper and plan it all
properly but I have some questions about logistics I wondered if anyone
could help with.
1. Can I put command buttons on a table or query?
|
by: Maddy |
last post by:
I manage a small organisation of around 100 employees, with different
specialisations. It becomes difficult to check how many persons of
each specialisation are available at any time, based on their vacation
period. So I have made a ms-acces database as follows -
A table EMPL with details of employees.
A table SPEC with the various specialisations.
The EMPL table has a specialisation field linked to the SPEC table.
Finally a VACATION...
| |
by: dee |
last post by:
My wife is school secretary who inherited the job of tracking about
100 keys to about 150 school employees for thee next school year.
Their current system, comprised of 2 non connected spreadsheets, is a
totally useless inaccurate mess.
I thought I might be able to help out by making a simple access
database, but think I bit off just a little more than I can handle.
My idea was to create 2 tables:
|
by: magicalnepal |
last post by:
Are you planning for vacation, holiday?
We would like you to spare your valuable time!
Visit our website www.magical-nepal.com for information on Nepal,
Tibet and Bhutan.
Thanking you in advance visiting and look forward to assist you.
Regards,
Rath Nepal Tours and Travels
|
by: JennDavila |
last post by:
Hello,
I am running into an issue with adding a form that displays a calendar to where the manager can click a day and it will attach itself to a tracking table. I am new to this and have been given this project as a learning exp. I need all the help I can get on where to begin.
I have created tables- one of with employee information, another with reason codes for day off requests (such as jury duty, vacation, sick time, etc). And a table...
|
by: fjm |
last post by:
I am having a bit of a problem getting my head around how to handle a design issue and hope that someone can offer some assistance.
I am making a front end to a mysql database in PHP. I am at the point where I am coding the forms that will take the user's input for the customer data. In a nutshell, I want to give the user the ability to save multiple contact persons, emails and phone numbers.
OK. There can be many customers on this system...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |