UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
5 Pages V « < 3 4 5  (Go to first unread post)
   Reply to this topicStart new topic
> Holiday Planner Demo, Access 2003    
 
   
Mickjav
post Jan 28 2019, 08:22 AM
Post#81



Posts: 30
Joined: 25-November 18



Hi masa1 sorry but no I won't release it until I am happy all the works have been carried out but with the works left on my project management system it says it should only take up to a couple of weeks depending on how much time I can put to it.
Go to the top of the page
 
Mickjav
post Jan 28 2019, 04:31 PM
Post#82



Posts: 30
Joined: 25-November 18



Posting this for peter I just created a new Leave type and had to edit the images thanks peter for pointing me in the right direction as me and images don't mix lol

The reason I wanted to add a new type is when I have a day off sick I don't like losing the money, as I get on with my manager he converts the sick day(s) to holidays for me.

Now I have that record you could add a report if needed to see how many days an employee has had off and how many were converted.

Also updated the days left for the new type.
This post has been edited by Mickjav: Jan 28 2019, 04:34 PM
Attached File(s)
Attached File  2019_01_28__1_.png ( 120.54K )Number of downloads: 21
 
Go to the top of the page
 
Mickjav
post Feb 2 2019, 04:27 PM
Post#83



Posts: 30
Joined: 25-November 18



At last all my work on the holiday screen has been completed and had hrs of testing I am happy with it both when half days are allowed and not.

Had a lot of fun trying to get the total days booked for annual leave and the new Converted To Holiday In the end I created a table to hold just those types that are deducted from the holiday allotment This has the advantage of not slowing the system down but somebody will prob find a way around that lol.

I am renaming the db to employee example as I have decided that my current diary needs updating so will build a new one in the example for next version
Added a image of both below
This post has been edited by Mickjav: Feb 2 2019, 04:46 PM
Attached File(s)
Attached File  2019_02_02__1_.png ( 101.79K )Number of downloads: 16
Attached File  2019_02_02__2_.png ( 92.18K )Number of downloads: 13
 
Go to the top of the page
 
Mickjav
post Feb 4 2019, 04:13 PM
Post#84



Posts: 30
Joined: 25-November 18



All I have left now is the holiday Allotements screen then just a bit of checking and adding comments where needed

this is the requests system I was in two minds how to go about this I.E. Code adding the dates of allowing the user to add the date in the end I went for the simple version which worked much better than I could have hoped.

The first image is of the main screen I'm using as a Nav and preferences screen just for this example.

You will see the last button is the requests button under this if the manager/Admin Has holidays to approve red text will be displayed when the screen opens
plus you can see a list of the current users requests with the status this screen allows the user to edit a request should it show as not approved/needs edit

The second image is of the holiday planner with the request assignments screen these two screens work together the list will display in the same place everytime (Thanks to isladogs For that bit of code)

The screen acts like the find screen but allows you to work with the holiday planner as well you can do multiple seaches the holiday planner will light up the employee for you and move the start date to the first week.

The third image is the request entry screen and yes I cheated I copied the holiday edit and recoded it

I am looking at saturday/sunday to being able to upload this, it will be added to a new topic as there is a lot I wish to to with this


Future Improvments:

The Time in service should allow for part time and full time employees it only allows for full time at present
I intend building a new employees works diary wich will be included with version 2 of the employees example


This post has been edited by Mickjav: Feb 4 2019, 04:28 PM
Attached File(s)
Attached File  2019_02_04__2_.png ( 83.05K )Number of downloads: 9
Attached File  2019_02_04__1_.png ( 131.25K )Number of downloads: 12
Attached File  2019_02_04__3_.png ( 77.96K )Number of downloads: 10
 
Go to the top of the page
 
Mickjav
post Feb 5 2019, 04:00 PM
Post#85



Posts: 30
Joined: 25-November 18



Uploaded a copy of my Employee Example to a new topic of same name I will cross link as soon as it's approved
Go to the top of the page
 
Mickjav
post Feb 6 2019, 12:36 PM
Post#86



Posts: 30
Joined: 25-November 18



I have added my demo/example Here:

I did add it here but it's not been enabled so might be I haven't enough posts.
Go to the top of the page
 
Mickjav
post Feb 9 2019, 03:00 PM
Post#87



Posts: 30
Joined: 25-November 18



It's taken me 15.43 Hrs To get to this point I've allowed 83 hrs for the complete works.

I found using the Colour system from the Gautt chart slowed it down to much as there are 18 fields so Added 20 conditions per field with set colours which I think will be more then enough maybe when I finish it somebody will find a way but for now there are 20 colours.


Attached File(s)
Attached File  2019_02_09.png ( 97.39K )Number of downloads: 22
 
Go to the top of the page
 
5 Pages V « < 3 4 5


Custom Search


RSSSearch   Top   Lo-Fi    16th February 2019 - 01:01 PM