Staff Schedule - 'how To' Help..
Hi all,
I'm relatively new to Access and would like a few pointers...
I have been asked by work to create a schedule database. We would like to be able to put in dates and see who's working on that day, pull up an individual and see his/hers rota for a week. Also see if they have meetings, annual leave, sickness etc.... We want it to be a very primitive WFM tool. Is this possible and is it relatively easy? The database doesn't have to create the shifts, they will be imported from Excel....
Which leads me to believe I need to think of it differently to excel... Attached is an excel rota, which would need to be importred - but maybe I need to be think a lot differently.
I know thats a big question but any help would be appreciated, or pointers to more resources... Thanks
Neil
View Complete Forum Thread with Replies
Related Forum Messages:
Add Staff Photo
Hi everybody, Recently I created a database for staff details in my company and I used OLE Object in Data type to make it. The problem now there are more than 500 employees in the company so it is very difficult to scan one by one photo. Is there any way that once I click on command button photo will be detected from scanner and saved directly in the field instead of doing it manually. Thanks and regards
View Replies !
Another Staff Rota
I am trying to develop a simple staff rota. Simple being a laughable term. :o My staff is task oriented and changes thier tasks daily. I would like to display a monthly schedule in Timebar scheduling format. Similar to the rolling calendar in MS Project. (Tried using project, but tasks are non-repeatable on the same line) I cannot down load 3rp party programs as they are not allowed on our network, and I would also like to tie it into our SharePoint sites. Q. Is there a ActiveX control like the calendar control that can express dates in a time bar style? Q. If there is no easy way (:rolleyes:) then where does the code start to do the calendar peice... Just looking for ideas. Thanks in advance!
View Replies !
Staff Holidays
Hi All, I need a query to tell me how many staff are on holiday on the same day..here what i have so far. A query with name, startholsdate,endholsdate, totaldays, etc, etc,, records showing; employee A books 01/01/06 to 14/01/06 and employee B books 10/01/06 to 24/01/06 C books 01/02/06 to 10/02/06 and so on, I need to show how many employees are off on what days eg employee A and B are on hols between 10/01/06 and 14/01/06, so only 3 more staff may take days off between the 10th and 14th. I have tried all sorts of calculations but to no avail? can anyone help.. thanks
View Replies !
Line-manager / Staff Relationship?
Hi all, I'm a bit stuck with a db relationship design. I need to hold information in a staff table about a person's Line-manager. My initial idea was to just have the Staff Table and use the PK of a member who is a Line-manager as a FK in the Line-manager field in the same table for their staff. I then came across a problem. I need to be able to select all the staff under a Line-manager. For example a head of department may have 3 team leaders who each manage 10 staff. I need to know all of them, not just the 3 team leaders who are directly managed by the HoD but their staff as well. As it happens there is no rigidgly defined managment structure per se for this organisation which makes things even more difficult. I assume there is a reasonably standard way of doing this as all organisations have some form of line-manager/staff relationship. Anyone care to enlighten me? Cheers TS
View Replies !
Staff Day To Day Work Times And Payments
i am unsure as to whether this can be acheived in a database.. basically this task is almost calendar like. the company operates 7 days a week. i have a table of company drivers and each has their own driver ID. my user would like to store what time each driver comes into work each day and what time each driver leaves. this needs to be quite flexible however because some days certain drivers wont work, but each day..if a driver has a 'come to work' time then they will for sure have a 'leave work' time. each driver also pays rent to the company once a week. within this calendar like system i would also like to store on what day the driver paid what amount towards their weekly rent. i cant quite imagine how this can be done in a database. but if these kind of applications are common, i would be most grateful for some direction. thank you. one more thing.. i would also need to record during each day what time the driver left and returned from lunch (sometimes our drivers leave for a few hours during lunch time) i want to store this because if they miss a job while they are on an extended lunch break im gonna roast em.
View Replies !
Staff Holiday Request Database
hi, i need to design and build a access database for school where staff for a business could request holidays with there holidays then appearing on sum sort of calendar which can be viewed. does nebody know where i can find an example to help me with my desing? thanx glen
View Replies !
Change Staff Assignment Dynamically
Hi...Newbie here! This might be long, but I want to be clear... I'm working on a database for my agency in which clients are assigned to specific staff through use of a staff id number. For administrative purposes, we have one *generic* client that is not assigned to a specific staff member. However, each staff member must be able to save records for that client under their ID number. Currently, I have a form to create client records that uses cascading combos. In the first combo, the user chooses the staff member. The second combo is then limited to the clients of that staff member. I have set the underlying query up to include the *generic* client in each staff members client list, but I cannot save records for that client. I get an error message that indicates it's because the generic client is not assigned to the staff member. Is there a way to temporarily assign that staff member to the generic client, perhaps some sort of AfterUpdate event that is only triggered when the staff member is chosen in the first combo? Thanks for any help!
View Replies !
Query/Update Sales Values For Individual Staff
Hey, I am currently doing an A-level ICT project and seem to be stuck at the first hurdel. My problem being that i wish to update the 'Number of sales' field for all the staff in the 'Staff' table. I have tried serveral queries to count the number of sales, which are in the 'Tickets' table for each and indidual 'Staff ID'. This was suscuessful although i am wondering how to transfer these values into the Staff.[Number of Sales]. Also some staff had the value of 0 so did not come up in results of the querie. Is there any possible solution or is there a more simple way to solve the problem. Many Thanks in advance Dan Parker
View Replies !
Schedule?
Hey thereI'm currently doing an ICT project for some school work, in which we all have to make access databases. My database is based around a fictional company that provide driving lessons. I've set most of the tables up including clients employees, bookings etc, but i'm wondering if its possible to implement a schedule within access?I would like to know if its possible for say if someone booked 2 hours of lesson, 2 blocks within the schedule table would be filled, or similar to a calender function, e.g. each day has 6 openings within it, and as these become booked the next day is filled.i've searched around a bit and can't really find anything but i'm very new to access so any advice would be much appreciated, or just being told that it isnt possible to implement such a schedule or calender would also be useful as then i wont be wasting time looking :PHope i've posted this in the right place, sorry if i haven't.Thanks in advance.BenJust found this website: http://www.aislebyaisle.com/access/calendartool.htmkinda similar to what i'm looking to do, just wanna know if theres anyway of doing this thats less complex? or free?
View Replies !
Schedule Next Appointment Automaticly
Good Day everyone, I am looking at setting up appointments and having Access automaticly schedule the next appointment in either 6 months or a year depending on the Vender. I've search the forum and can't find anything. For Example if their last appointment was 12-1-05 I would like access to automaticly schedule the next appoint 12-1-06. Any ideas? Thanks,
View Replies !
Advanced Employee Schedule
Hello Everyone I need to make an employee schedule in access. I am not sure if it is possible, but here are my constraints: 20 employees 5-6 different truck locations (sm1, sm2, sm3, sm4, sm5, sm6) These locations are scattered within our service area. 2 employees must meet at the same truck, (each truck has 2 employees working on it) some employees can only meet at certain locations (ex. paul can meet at either sm2 or sm3) all employees are PT so they can only work on certain days or a certain amount of days per week. (ex. paul can work up to 4 days a week and jim can work only sat and fri) I would like to make a program in access that will take all these factors into consideration. EX. if i try to schedule paul on sm4 the program will not let me do it or it will give a warning or if i try to schedule paul for 5 days it will give me a warning. It would also be great to have a counter that will show how many days each employee has left to be scheduled for, EX: if i scheduled paul for 2 days it will show that he can actually work 2 days more if i need him to. I know this might be a lot, but i also know there are so many talented people here so i am sure it is feasible. Please let me know if you know how to do this or if you could guide me through it. or if you know about a different program that can solve this please let me know Thanks in advance
View Replies !
Schedule A Task In Access
Hi i would like to know if it is possible to schedule a a task in access, at the moment i refresh all my excel report by using a button on a form in access and would like ot know if i can do this automatically
View Replies !
Schedule A Compact & Repair
I have a database that is split. We want to be able to schedule a compact & repair on the back end. Is there a way within access to schedule a compact and repair?
View Replies !
Using Access To Create A Perpetual Schedule
I am trying to create a database to schedule customer visits. I would like to enter a beginning date and a frequency (IE every week or every two weeks) and then be able to print a schedule by entering a date range. Very similar to how MS Outlook calendar performs. Any suggestions appreciated. Thanks Chad
View Replies !
Recall - Create Schedule (sbaxter?)
This could be one for you Mr Baxter. I want to automatically create interview slots. On a form I've got an interview set up and there is a one to many relationship with a table containing interview slots. I want the user to key in the start time of interviews and the end time and the duration of the interview. It should then create the records (time slots) and display them. I assume it will be some kind of append query, but to be honest I just don't know where to start. Please help. A cyber pint goes to the boffin that susses it. Cheers, Recall.
View Replies !
How To Schedule Update Field Every 4 Week (Friday)
How do I schedule to run update COMMISSION field based on calculation every 4 weeks? For example....every friday, i would like to do this calculation : COMMISSION : FIELD (total sales) * 0.05 All customer that logged into the account will be able to see their own commision, AND all administrators will be able to see ALL commission of all customers. Can anybody guide me on how to do this? This scheduling is VERY important to me. I hope somebody can help me. THANKS!
View Replies !
|
TRACKER
