I am currently creating a data base in access for reservation of audiovisual equipment. My form provides the selection of the equipment, the date and hour to be used and hour to be returned. My mayor concern is to not reserve the equipment twice(same day and hour). I want to be able to have a message telling the user that the equipment is not available upon the selection of the hour. Any ideas on this.
Thanks
Hi there,
I'm working on my A2 IT Access project atm, and my aim is to produce a fully functional db for use by a golf course, incorporating membership information and tee-time reservation system.
I've got the membership side pretty much sorted, so now I need to start work on the reservation system.
But where to start?
Basically, the user needs to be able to view slot availablity on a specific day, and make/change/delete bookings quickly and easily. The booking also needs to contain the party size. The bookings themselves should relate back to the specific member that made it via the MemberID field.
The user should be able to make bookings upto 6months in the future.
Block bookings should also be possible, so that the admin can block an entire day out for a tournament therefore preventing member bookings.
The first available and last available slots also need to be editable by the system admin to take into account time of year, light conditions etc.
Right, so i know there's quite a lot there, and i'm sure i'll come up with more features that would make it better.
But as it stands, that's something to get me started.
I'm not asking for someone to do the project, just to point me in the right direction as to suitable table structure, how to "make" the slots, how to store the bookings in the table, etc.
So, any input and ideas are greatly appreicated.
Cheers
Gavin W
Thanks in advance for any help.
I have drawn a blank and can't figure this one out.
I have a reservation database and would like to reject the reservation if room is already booked.
When the reservation is entered into the database I would like it limit the ability to select that room or choose new dates.
any help would be great .
There are only three rooms available so I need it to only allow one reservation per room by date range.
thanks
Deborah
I have been looking for a way to sync a table holding reservation dates to MS outlook calendar automatically when dates are inserted in the table.
View 2 Replies View RelatedI need help finding an existing or making a db. This db does not have much to it, so I am getting frustrated finding/making one.
My company has equipment that is stored in one of three places, customers, trucks of employees, and other(like warehouse, or out for repair). The db should be able to give me a report of where everything is on a given day, and a report of what was in a given customers property during the job(this is not for a single day, but for the duration of the job).
If someone knows of an existing db like this, I would appreciate a link. If you want to help, it is appreciated. At this point I would not mind paying someone to do this for me, as long as it wont cost too much.
Hi
I am new to db and would like to do a simple db for items of equipment going out and coming back in showing who has been allocated what.
So one person could have many item but the item can only be issued once until it is booked back in. I would also like a history of transactions.
Only something simple, so we have a record who has what if we need to find something and when they had it etc.
Many Thanks
Scott
Hi, I am new to access and was if someone could assist me in designing a database exactly like the rentmaster software on this website(http://www.rentmaster.info/trial.html). I was told to design a database just like this one but, I am not all that familiar with ms access 2003. I've try searching google and microsoft's website for database templatesand I didn't see anything similiar to it. Any help with this is greatly appreciated and if I didn't go about posting this in the correctly, I am extremely sorry. Please don't hesistate to tell me and/or guide me to the right place.
Thanks, Val
I have a table that consist of equipments. In it is a equipment number field. I need a way to randomly pull up these equipment numbers-kind of like a lottery. Please help.
View 2 Replies View RelatedHello,
I am starting to get further into access development, originally i started from a sample database and have been teaching myself as i go along. This database has come pretty far and the farther it comes along the more my company demands of me from it!
either way, it is basically a database that holds all of our asset information, equipment parts, workorders and preventative maintenance. We've been plugging along just fine but I want to help their productivity and have access automatically create "Equipment ID"'s from information that is entered by the person adding an asset. I would like it to create an ID from Entry of the Department, Location, and then a 4 digit Autonumber after that.
Basically we have a few basic departments, IT, Facilities, etc. and a few locations... So we have been setting our equipment ID's like this:
AA - Two characters for the Location
BB - Two characters for the department
0000 - numbered field
So I really would like to be able to create these automatically instead of manually typing them in to a text field with an input mask.
AABB-0000 to automatically create entries from the departmental info, location info and then automatically create a 4 digit number in order to follow it.
What is the best way to do this? Keep in mind I am just barely able to do any code, I only have been going from what i see in the database and building upon it and learning a few bits and pieces of code from there. So if you start going into a code explaination go slow~!
Thanks,
Jim
I have a transaction table the last record is [EquipIn]. during the equipment checkOut process all the other headings in the table are filled in. The idea is to fill in the [EquipIn] record a couple of days later when the equip is returned. How the heck can I make a equipment check in form that will update that one record? I can't do this manually as we have 1000+ pieces of equipment.
View 13 Replies View RelatedMy desired output of this is to have a database to allow me to quickly check in and out equipment and personnel using a barcode scanner. I am using access 2013 and started with the asset tracking template downloaded from Microsoft. Where I am hung up right now is adding the personnel check in and out (each member of the team will have a barcode attached to their id) I want to be able to just scan their badge when they show up and again when they leave. At the end I will run a report that shows who was on scene (it is for a search and rescue team) during a certain day or time range.
I have added two new tables one check in and one check out the only fields are firedeptID and CheckIn or CheckOut a date/time field CheckIn and CheckOut Auto populatewith Now(). The first problem is that I think I need to turn off (if possible)the auto creation of a new record every time, when I scan in an ID right now that record gets the time stamp of the last time the new record was created IE.Last week when the last person scanned in and the new record was created. I assume I am going the same type of issue when I start working on checking out the equipment.
I've got three tables:
Code:
tblequipment
equipmentid
equipmentnumber (user defined ID)
tblrentals
rentalid
rentaldate
rentaltime
fromparty (c for customer, e for employee, o for other)
frompartyid (foriegn key to either customer, employee or other)
toparty (same as from)
topartyid (same as from)
tblrentaldetails
detailid
rentalid
equipmentid
How can I get a list of ALL equipment showing the most recent date and time, also showing the respective toparty and topartyid? I can get it fairly easily, except for including toparty and topartyid.
I am creating a Machinery database to match parts up with equipment. So they can see what the Equipment is and all the available parts. The sort needs to be like this
First Sort:
If the manufacturer of the machine is the same as the manufacturer of the part sort that at top then sort alphabetical
Is this possible? Each equipment would have a different manufacturer so I can not do some type of hard coding.
I'm new in access I working on DB for my company equipment
I used tables and queries and reached to the following query
Query name (02-By Project)
KSC_NO From_Project To_project Date_of_Trans
K-01-037 52500 12013 02/14/2014
K-01-037 12013 52500 03/31/2015
K-01-037 52500 12013 04/07/2015
K-01-129 52500 12013 03/03/2015
I want to make query to give me the following
KSC_NO IN_Date Out_date Duration (months)
K-01-037 02/14/2014 03/31/2015 13.6667
K-01-037 04/07/2015 Today 0.0333
K-01-037 03/03/2015 Today 1.2
Is that possible?