Schedule?
Feb 22, 2007
Hey there
I'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 :P
Hope i've posted this in the right place, sorry if i haven't.
Thanks in advance.
Ben
Just found this website: http://www.aislebyaisle.com/access/calendartool.htm
kinda similar to what i'm looking to do, just wanna know if theres anyway of doing this thats less complex? or free?
View Replies
ADVERTISEMENT
Aug 2, 2007
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 4 Replies
View Related
Dec 29, 2005
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 9 Replies
View Related
Jul 4, 2006
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 2 Replies
View Related
Oct 25, 2006
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 7 Replies
View Related
Dec 12, 2005
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 2 Replies
View Related
Aug 10, 2005
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 2 Replies
View Related
Dec 20, 2004
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 3 Replies
View Related
Sep 7, 2014
I have 6 machines that run jobs Monday thru Friday but I will focus on doing one machine to avoid confusion.
The machine will be running 23 hours a day Monday thru Thursday and 18 hours on Friday and is shut down on Saturday and Sunday. Monday morning at 5am (start of the work week) Job A starts. The job will run for 30 hours. Then Job B will run for 160 hours. I need to know when Job B will start and end. Although it would be nice to know the time of day, just knowing the date would be good enough.
As I said I have 6 machines and each one is running anywhere from 7 to 10 jobs. My end result could be nothing more than a report, but a datasheet form would be ideal. On Mondays, new jobs are added and schedule is updated based on actual productivity from the prior week.
View 3 Replies
View Related
Apr 6, 2015
how to go about creating a report that lists a traditional style class schedule?
I would like the times on the X axis and the days of the week along the Y axis. Ideally, the name of the class and student list would be included.
I have all this information in a database, but right now my classes are being generated in an excel program (by hand) and I'd like to automate it somewhat since some class information is being changed on weekly basis.
View 14 Replies
View Related
May 2, 2013
What I would like to accomplish is to make a report similar to this, except make it automated so I won't have to change the dates. Users would be able to bring up a current schedule without worry that it's updated or not. The schedule repeats itself every 6 weeks. I made a cross-tab query, but I must admit that I'm not too familiar with working on them.
View 14 Replies
View Related
Jan 26, 2015
I have a database thats open all day,
I need a macro to run from it at 9pm 12pm and 3pm
Is this possible?
View 1 Replies
View Related
Aug 21, 2013
I have a database which I use for scheduling production. I would like to know if there is a way to "push" the schedule dates. I have multiple products scheduled for production but at times I need to adjust the production dates by pushing all the schedule dates ahead by one day. I don't want to re-enter all the dates to do this adjustments.
View 14 Replies
View Related
Jul 19, 2013
I'm working on a database where I enter a series of assets and their costs, and I'm trying to build a query that will generate an amortization schedule for each asset.I'm using an amort methodology that amortizes a certain amount each period based on a calculation. I've got a query that generates the amount that would be amortized based on that calculation.
My problem is in the last period of amortization before the asset is fully amortized. In that last period, the amort methodology may generate an amount to be amortized that would be greater than the total value of the asset. In such cases, I want the amort for that period to be the total value of the asset less the cumulative amort up to this period.
So, for example, I may have an asset that is worth $225. My amort calculation generates an amort amount of $50 per period. For the first four periods, the amort would be $50. But in the final period, only $25 would remain unamortized, and in that instance I want the final amort amount to be $25 instead of $50.
[AssetName], [MonthStartDate] (i.e. the first day of the month for the period of amortization), [BusUnit], [RawMonthAmort]. [RawMonthAmort] has an expression that performs the calculation that determines how much to amortize. I've tested this part and it all works (except for during the final month of amortization, as noted above).
I tried including another layer of conditionals in the [RawMonthAmort] expression that would calculate a cumulative total amort and check that against the total asset value (by bus. unit) and give the difference if the cumulative total amort exceeded the asset value, but I couldn't figure out how to make that work.
View 7 Replies
View Related
May 23, 2013
I wana ask about calculation hours for schedule table. lets say how to calculate based on what i select from my schedule table for :
no class: how many hrs
lesson i got class: how many hours.. for example: 1+0.5= 1.5 hrs
total of hours: which is based on "no class" + " lesson i got class" for example: 1+1+0.5= 2.5 hrs
View 2 Replies
View Related
Jul 15, 2015
I have a table called schedule maintenance.
In that table I have a "date" field
Is it possible that if " todays" date = a date in the field date a e-mail can be sent to me to remind me there is a scheduled maintenance to be done.
View 6 Replies
View Related
Mar 3, 2012
I have a report in MS Access. It needs to be converted to pdf and sent to a list of people as mail through MS Outlook at 12:00 Noon on Monday and Thursday. How can I achieve this. I don't have much knowledge regarding macro programming. Any relevant links.
View 4 Replies
View Related
Apr 15, 2013
I need to create a database use access that the access can update the database based on a schedule, like daily.For example, in the table there are several columns, and each column stands for a meter point, and in real world, each meter will have a reading every 5 mins. Now the database consists of all the readings till yesterday 11:55pm, by right, tomorrow for example at 8am, the database will update the readings till tonight 11:55pm, today's readings will be placed right after below yesterday 11:55pm row in the same table. The data source will be generated in CSV file every day 8am and put into a specific folder. What I need to do is to update them into this database.
View 8 Replies
View Related
Apr 13, 2013
I need to make a report that shows a work schedule for 10 employees. I need it to print in a monthyly calendar format with horizontal lines to show start and end date and time. I need it to show that there is or is not any overlap for that machine."
It has been a while since I have created a DB and I get some of this okay. So far I think I need three tables. One is the machines. Two is the product schedule (how long it takes to produce X number of products). The last would be work orders and that pretty much covers the data.
I think most of the data can be maniputated by queries and that is even done on the report. The report as we all know is the reason for a database. If it was just about the data it would be simpler to do a spreadsheet. It could get fancy and make a pivot table. That output can be a calendar of sorts.
View 2 Replies
View Related
Dec 10, 2013
I have been tasked at my work to create a database for tracking time off from work. I have built several databases in Access 2003 and have now transitioned to 2010 and it is seems to be going well. My past databases have been rather simple data in data out not really that big of a deal. However on this database they need a report that will show them a week view that shows them all the employees regular days off and any additional time off they have schedule in that week.
I have an employee info table that has employee basic info, Emp name, Emp number, Work Week code (which identifies which days off the employee has) Hire Dates (for seniority sorting) and then I have 7 fields listed as D1, D2, D3 and so on until D7 (I will try to explain these fields later).
I have another table (Time Requests) that has 3 fields, Date, Emp number, and Time code (which identifies why they are off work or unavailable to be assigned).
The last table I will refer to has 7 fields, they are Date1, Date 2 – Date7
I now have a form. This form has the 7, fields Date1, Date2 – Date7.
On my form Date1 field is updated by a manager with a date that is a Sunday then Date2 = [Date1]+1,
Date3 = [Date1]+2 and so on until I have all 7 fields showing date from Sunday – Saturday.
These fields are lined across the top in a vertical direction positioned above a subform of the employee info table. So directly below the 7 Date fields are the D1, D2, D3, D4, D5, D6, D7 fields then to the right is the Emp name and Emp number, This gives me a Week view of who is working.
I have been able to get the D1, D2….. fields to show their respective Work Week codes by writing very simple “If Then” statements . So here is where I AM STUCK…When I am showing this week view how do I get D1 –D7 to identify what date they are supposed to be in reference to Date1 – Date7 then compare themselves to the table “Time Requests” to see if they have a match and then set the value of D1, D2 …. to the “Time code” in that table. D1 – D7 need to auto populate and do this for about 50 employees.
Here is a screen shot of what I have so far and where I am stuck: [URL] ....
View 2 Replies
View Related
Aug 1, 2013
Is there a way to calculate accrued interest or an amortization schedule in MS Access? I know it's easy in Excel but I have a need to do it in Access.
View 1 Replies
View Related
Aug 6, 2013
I have a database and form that is used to register times and various codes for employees to enter their work schedule for the day. Right now I am using a split form where they enter a ID code in the form and it auto populates with their name/department/and date. They then go and fill out a few boxes regarding time spent, machine used, and purchase order.
Once the information is added it is seen below due to it being a split form.
My question is this: Can I make the bottom portion (split form) filter and display only that specific employees ID number and his previous entries? Right now it is possible to view all of the entries placed and due to it being used on a network connection there are many submissions, I want it to narrow down so that once the employee enters his/her own ID only their previous submissions for that day can be viewed.
View 1 Replies
View Related
Jan 26, 2015
I am trying to create a report for 5 different dentists schedule for their current date ( and also allow a search for upcoming appointments)...
I know it requires a query but im not to sure what direction to take as i have never created a report before...
What needs to appear on the query? im aware it would be all the fields i want on the report but do i need to make changes in the criteria etc..
I also dont really know how i can create a report for each dentist because i dont want to have 5 different reports.. is it possible to have the report set where i type the dentist name and select which one i require and then i can view their schedule?
View 1 Replies
View Related
Oct 9, 2014
I know Access can setup an Outlook Task to auto-export query to Excel, but it requires the Outlook to be always open on the user's computer.
Is there an easy way to setup a schedule that can automatically export a query to Excel and this schedule will then auto-email the exported Excel file to an email address every Monday at 5AM for example?
If this can only be done in VBA, any reference I may start with?
View 4 Replies
View Related
