Can anyone point me in the direction of a room scheduling example or a tutor site. I originally wanted to use Outlook but my boss, after seeing another Acces Project I did, asked for it in the Access. I can build a basic data base on a daily basis showing rooms against hours, but my problem is forward scheduling eg "every Thursday meeting room 1 will be for Group A" etc. Can anyone please get me started - I'm tearing my hair out on this one!
I want to build a room scheduler. Before I get too far in to my first attempts, does anyone know if there any examples out there I can use to give me ideas?
If not I wonder can anyone advise me as to a difficulty I currently can see with what my attempts so far. I have built a very basic database with fields for each room and time slots through each day. This works ok. The problem I see is finding a way of setting a room booked for say "every Thursday between 14.00 and 15:00". I have considered using a query to do it but cannot see how to formulate it.
I am in the process of creating a Room Bookings database using the limited graphical tools of Access 2003. I intend to break up the day from 0700 to 1900 into 48 X 15 minute chunks (the minimum bookable time) and have these graphically represented on the form as boxes whose colour change depending on whether it is booked and who by. It would be normal to have up to 8 colours available for this as any one room would be unlikely to be booked by more than 8 people in one day. I would envisage that each day would be covered by a separate subform.
Has anyone else tried a graphical representation of a booking form?
It would be interesting to hear others views or experiences...
Hi Everyone, hope someone out there can figure this one out.
I am developing an access database and forms based on a hotel booking system. There is a tblRoomState table, which holds the roomID, the date and the state of the room, (so for a 3 night stay, this table holds three entries). I have a query which returns any roomID's from the tblRoomState table which have a state value of 1 at a specified date. I want to run another query which returns roomID's from the tblRoom table which are not part of the recordset of the first query.
Since there is no records held in the database for rooms which are not booked, the only way to access "availability" is to use a recordset of rooms which are booked and test against that.
Hi, I have been reading throguh various articles and learning a lot from you guys, so thank you very much. This place is a fantastic source of information, by far the best of anything i have found online.
I have a question which i would be grateful if someone could advise upon.
Access 2003. I have 4 tables:
list_accommodation (holding host family address details who offer accommodation to students) id (autonum) name (text) address (text) etc.....
list_rooms (table of rooms offered by host families) room_id (autonum) host_id (number) - joined to list_accommodation.id room_name (text) capacity (number)
students (student contact details who want accommodation!) id (autonumber) name (text) dateofbirth (date) address (text_ etc.....
bookings_accommodation (to hold the accomm bookings) booking_id (autonum) room_id (num) - joined to list_rooms.room_id student_id (num) - joined to students.id start_date (date) end_date (date)
This structure therefore enables me to query if rooms are booked between dates:
SELECT bookings_accommodation.room_id, bookings_accommodation.start_date, bookings_accommodation.end_date FROM list_rooms INNER JOIN bookings_accommodation ON list_rooms.room_id = bookings_accommodation.room_id WHERE (((bookings_accommodation.start_date) Between DateAdd("d",0,[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_start_date]) And DateAdd("d",-1,[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_end_date]))) OR ((([end_date]-1) Between DateAdd("d",0,[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_start_date]) And DateAdd("d","0",[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_end_date]))) OR (((bookings_accommodation.start_date)<DateAdd("d",0,[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_start_date])) AND (([end_date]-1)>DateAdd("d","-1",[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_end_date])));
and therefore, using the 'booked' query i can therefore find out rooms are available.
SELECT list_rooms.room_id, list_rooms.room_name, list_rooms.capacity, list_rooms.description, list_rooms.host_id FROM list_rooms LEFT JOIN qry_rooms_reserved ON list_rooms.room_id = qry_rooms_reserved.room_id WHERE (((qry_rooms_reserved.room_id) Is Null));
----
so, now i have found out that there is a necessity to enable students to share a room (the bookings for a room may not happen at the same time). This means that i have to determine the capacity of a room and therefore if the capacity is not full, then show as available.
I was wondering what the best approach to this may be? I have added 'capacity' to list_rooms, but i am unsure as to how to go from there....
Any thoughts and advice woudl be really appreciated.
I have to create a query to calculate the Base Income per room.
Guest 1-4 is the standard room rate say $125/day, guests 5 & 6 pay additional $20 charge per day. Guests staying for seven days or more receive a 10% discount. How to build this expression into a query in access. If it was Excel that would be easier.
Table info I have is: Room Arrival Date Departure Date No of Guest (per room) Daily Rate
So I'm trying to do this database for my ICT coursework and its a full system for dog kennels.
So in actuality the rooms are kennels.
I have a table tblbookings that amongst others has fields:
Kennel No Date In Date Out
I need a way of users entering the requested dates for a new booking and getting an output of a list of all kennels that are available to book for that full date range or even better, a way of running this straight from the form for a new booking frmbookings to just leave the first available kennel no. in the field KennelNo?
I have Table for rooms called Rooms, and the data in the table is roomNumber which is in the format Letter and two Digit number, so A01 would be dorm building A and room building 1, and I then have a seperate row named roomType that is either VIP or Semi Private.
Now I am creating a form where a worker will put in there scheduledCheckin date and scheduledCheckout date and it will be written to the Bookings table. I would like this form however to take the dates they have put in, as well as room type (Semi-Private or VIP, and assign them an available room that isn't booked at all in that range) or list all available rooms for that range of time and they could then just select the room. I would rather it automatically assigns an available room based on room type though because this check in system is going to have about 500 rooms.
I've attached a link for what I have so far. I know how to make a query to list anyone who has booked rooms over that date, but need one for just preventing booking the same room.
Hi all, I'm just starting on a new project to create a scheduling database for a small company (about 20 people). What i aim to do is to edit calander entries (Month view) and view calander entries hopefully using a control that looks as much like Outlook as possible again this would hopefully show what these 20 people are doing over the month.
My question is: Can you use outlook to do this, or would you have to use a control and does anyone know what/how to use this control.
I have a question which I believe I may already know the answer to but Here it goes. I am trying to create a db that can track and employee shift schedules. I have 28 employees and we work 24X7 so we have 3 shifts, days, evenings and night. I cant seem to get my head around how I would create it. I have tried like 10 different ways but I keep running into Form limits. They want to be able to schedule for the whole year out by month. I have attached a sample of what they want it to look like. If anyone knows of anything out there or could assist me in at least a correct starting point, I would be forever in debt to you.
Thank you for taking the time to read this post and I look forward to hearing from you.
I am looking for some scheduling software to meet the following requirements:
The ideal requirements for a new scheduling tool would be: •More robust than LaunchPad, but less complicated that Maestro •ability to initiate specific Access macros (not using an autoexec macro) REQUIRED •must provide detailed audit logs to show success or failure of each job REQUIRED •ability to monitor shares for files or file changes •Networked version for shared access? •Must be controlled from within the team
I need help creating a small Access Database to be able to make Schedules for Conference table Meetings. I am hoping to find an example, or if someone could please direct me to the right place where it’s been done before in Access 2000!?
I was asked to use this Calendar: (“Calendar Control 9.0”) because all my co-workers have this Active X Control, which has Dates but not Time in and Out. I need to add Time or think of some other general Control, to add to this Database along with the Date Calendar.
What my co-workers would like to do is to go inside the Database > choose their Name > pick a Date in a Calendar > pick a Time to RESERVE the meeting > place/ location, etc.
The only thing right now I have is a Table for the Users, and I also need to figure out how to place it in the DB for other people to select their name and precede with other options.
I need to make the DB recurring (like Outlook), notifying (e-mailing) of weekly Staff Meetings, for EX: every Wednesday for next months. So that next time, when somebody goes into the Database, they can see what Time slots are taken or Available on the Calendar. We tried this with Outlook, but it didn’t work due to the Conference table not being customized and not listed in the Company address List. Don’t mean to make it confusing - basically Outlook seems to be out of the question for my Group, therefore I was asked to look into Access :) .
I don’t even know where to start. Can someone please help me modify this or I would be glad if you provide an Example for me to visualize where to start? In this Calendar, people want to be able to choose Hours. In addition, I need help with aesthetics for the Database tables, queries, forms/ Switchboard.
Please let me know if you have any questions. Thanks a bunch in advance, Beginner:confused:
I would like to create a Scheduling database for employees. The database would include:
- list all of the employees -tabs to look at schedule for this week, 1 week from now, 2weeks from now, 3 weeks from now, long term (1-2 months), etc -small comment section within each day for the guys to enter some comments...e.g. dentist at 10, holidays, etc
There has to be something like this already out there that I can modify and work with. Is there anything like this already in the NorthWind Database that comes with Access? What about some free examples Access developers made?
What about Outlook? Can I modify Outlook and use VBA somehow to accomplish this? Outlook is basically on an account basis so I don't know if I could tailor it to my 30+ employee database.
I have never used the calander control in access I am Very new to Access code as well. But I am Learning.
This is what I am trying to do
I have a Customers tbl and a Salesmen tbl
I would like to have a calander that I can use to set appointments for multiple salesmen in a form. I have looked at the calanders posted here and now of them do anything like what I am trying to do. Is this possiable to do?
Hello All I am in need of a lot of help. The situation is as follows I have a table with users that have certain classes that they have to take and in another table I have the dates that these classes are offered. My problem is I want to find a way to map all the students to their required class by scheudling them into the required classes taking into account date conflicts and classes required before taking a certain other classes. I guess my question is if there is any possible to do this in access without me phyically having to schedule each users required classes to the correct time making sure there are no date conflicts. Any help would be highly appreciated because we are talking about 3000 users that need to have schedules and that is extremly time consuming if I have to sit here and do the schedule for each user. Thank you in advance for your time
I need to make a random schedule every week. I have a new DB that I have attached and the current one being used that was built by some one else. The reason for building the new one is I could not figure out what to change to add a new section/Area for scheduleing.
What I have are 3 levels of auditors
Level 1 are the basic auditors which I will need 1 per shift per day Level 2 Are operationl Auditors I will need 2 of the per week Level 3 are management auditors and I need one of those per week.
When I get these compiled per week I will need to make a report to e-mail out.
I attached both DB's the old one to show what I need, and the new for a more stripped down and easier to update version.
I'm putting together a Customer Management dbase, in Access 07, and one of the tables is dedicated to scheduling (and the outcome) of customer appointments.
The tables I'm hoping to get a solution for are:
1: Customer Master Data (parent): contains fields such as Name, Address, Phone #, email etc
2: Appointment Master (child): there are 4 Appointment tables/queries, one for each of the available product groups, and contain such fields as Product Type, Lead Source, Lead Status, Appointment Date, Appointment Time, Sales Rep, Appointment Comments
What I am trying to do is find a solution as described below:
1: When the appointment is created the appointment is then pushed into Outlook 07; along with various customer information from the Customer Master table
2: OR is there an appointment/scheduling calendar, preferably with the same look/feel of outlook, available that forms part of the access 07 dbase? This is probably the preferred solution.
I was wondering is it possible to schedule in windows somewhere to open up my syncfrontend.mdb and then run a routine that i have written inside of that mdb.
The routine is a huge database syncronisation task that needs running every hour, it's all there ready to be run but just need a way to get to it and run it automatically on the hour every hour.
HI all, Im fairly new at Access, nut ive been given the task of creating an appointment scheduling form, so that we can schedule a client for an appointment via this form.
The idea i had in mind was to use a calendar to query the appointments table so that we can view all appointments for any particular day.
Here is my problem. I am hoping that someone here can be my hero on this one.
I am trying to figure out what would be the best possible way to track my hospital's staffing. I need a form that I can click on the Active X calendar and have it populate the staffing table. I have built the code and it works great.
The problem is that the way the code works now, I have to have a field in my table for every single date scheduled. For example, right now, I have the staffing table like this:
Name Date Scheduled Date Scheduled1 Date Scheduled2 Date Scheduled3
Of course, after a month, an employee will have worked more than four shifts. I really don't want to add a field for every shift they could have worked because then, after a month, I'll have thirty date fields, and after a year, I'll have 365. So, do you have any ideas about how I can do this without having 365 date fields?? Thank you! If you can help me figure this out, you are my hero.
I have a normal schedule table in my database that stores the open/close hours for each business unit location.
The problem is some locations are timeshares and some have different business units every other week, every 2 Tuesday, the 1st and 3rd weeks of the month.
I figured I would make an exception table noting all of these somehow and after building a calendar/report plug in the exceptions.
I am creating a scheduling database for patient home visits and need to see specific people assigned to one visit, and it will always be at least 4. Could I create a drop down list that will show all team members? How would I design the scheduling table to have multiple people for one scheduling record? I have table for Teams and one for Team members, but when creating the appointment form realized I will only see one team member assigned to one specific appointment.
I'm able to create a gantt chart template in excel that will use date information to visually display the upcoming work. That's great, its exactly what I need. I'm unsure how to implement it.
The question is: Do I need to export data and have it generate these excel reports, or can I have it done in access somehow?
Either way that I do it I'm not sure where I'm going. I imagine its quite easy to export data to work with but I don't want to be spending time on access/excel creating a solution which isn't the best one.
