When a customer makes a booking, all I need to do is check that there is less than 20 cats in the cattery for every day of the customer's intended visit range. This isn't the same as a car-hire system where if a car is out for one day during the intended hire, then the booking can't be made - it doesn't matter which pen a cat is put into, as long as there is a pen free for each day of their visit.
i.e. a customer wants to hire a ford escort from 1st-10th january but it is already booked for the 9th onwards - the booking can't be made.
a customer wants to put their cat in ANY pen from the 1st - 10th so it just depends on ONE pen being free for every day of this visit.
Any suggestions? My teachers are hopeless and I need to have implemented my system by 20th January!!! :eek: Thanks, Jayce
I have been tasked with creating a system for booking instructors with clients. Customers will book in for a lesson which can be anything from 30 mins to three hours long in half hour chunks. There are up to seven instructors available and I need to be able book up to six months in advance and hopefully display a daily screen with a grid showing who is booked out with who at various time of the day. Can anyone suggest some piece of freeware or example database to get me started?
I have been asked to research and then produce a simple seat booking system for a movie showing in a small lecture theatre using MS Access. I'm a relative Access newbie and have had little luck in finding information on how to go about producing this system.
If anyone could provide or link me to anything which could be of use that would be great.
I am going to do an online airline reservation system, and the database is going to be done using MS Access. The database contains 4 tables: Customers, Payments (Credit Card details), Booking, Flight.
Can someone help me do the relationships among the tables. My personal e-mail is russcami@yahoo.com.
Is there some kind of Time picker function , i can see the date picker however i am using a booking system and have a field named 'time of booking' and i need something that can dump the exact system/online time into the field.
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'm making the most simple DB where there are bookings consisting of a StartDate and EndDate. The Scenario is a car hire firm. Obviously i don't want to be able to double book a car and want to be able to list all cars available within the two dates (input).
I have set the defult input to 12/07/04(StartDate) and 12/17/04(EndDate) for the purpose of testing.
I have created a query to find all cars which are not available in relation to the input dates, but cannot get it to list the available cars!
SELECT CarDetails.CarReg FROM CarDetails INNER JOIN BookingDetails ON CarDetails.CarReg = BookingDetails.CarReg WHERE (((((([BookingDetails].[StartDate])<#12/7/2004#) And (([BookingDetails].[ReturnDate])<#12/7/2004#)) Or ((([BookingDetails].[StartDate])>#12/17/2004#) And (([BookingDetails].[ReturnDate])>#12/17/2004#)))=False));
I have our primary web based inventory system that I am exporting to Excel and using this as an import to Access for the main raw data for my database. This being inventory it changes daily so I am updating this table every day. When I try to append the table it ads all the records. I am wanting an easy way to add only the new records/take out the ones that are no longer there. Basically update the table with what is currently there.The only have I have found to do this is by running non-matching queries and update queries.
Full lenght high quality movies absolutely for free! No payments, registrations and other crap needed! It's absolutely free! Start downloading full lenght movies for free in 10 seconds! It's no a joke! Just check it out! (http://www.topvideogalerz.info/films)
I have started my own MS Access Hints and Tips Club (http://msaccesshintsandtips.ning.com/profiles/blog/show?id=948619%3ABlogPost%3A301) and in an effort to attract new members I am offering a free calendar form.
I haven't seen any other Calendar form (DEMO HERE) (http://www.viddler.com/TonyHine/videos/35/fullscreen)with the advanced features that my calendar form offers, so I hope it's unique. It also benefits from the fact that it is very simple to set up and use on your own form. All you have to do is add two controls a command button to call the calendar form, and a text box to receive date.
you use a simple naming convention: Command button named: "btnDOB" Text box named similarly: "txtDOB"
The "DOB" portion can be any text you like as long as both buttons have the same text, >>> "DOB" <<< Any way Have a look at the DEMO at least! (http://www.viddler.com/TonyHine/videos/35/fullscreen)
Im after some free images for buttons, for my stock control database system. Can anyone recommend me some ood site to look at? Ive searched but have been unable to find anything really suitable.
I am trying to sort data in a free from date filed without success. For example I have 1999-present, Jul 14, 2003-Jun 2004, then 2004-ongoing... Is it possible to sort them? Thank you very much. Debbie
Table ( ID, name, surname , etc etc) Form - I use this form to add new records to my table.
On this Form I should be able to see the ID number ( from next blank record)
So let say I have 1002 records on my table.So on my Form ( while I ma openineg to add new recrd) I sholud see ID=1003 ( so I should see next free ID number)
ID= autonumer
Any idea how to create this little button ( window)????
According to Clint Covington, Microsoft intends to release the runtime and developer extensions for free.
My opinion is that it should ALWAYS have been free instead of slapping us Access developers with an extra cost so our users don't need to pay hundreds of dollars more to use our applications. I can't think of ANY other development environment that has this drawback.
. Alexei White (http://www.linkedin.com/in/alexeiwhite) Has a very kindly posted some excellent sample data which you can use in your development. The sample data is downloadable from his blog here: (http://blogs.nitobi.com/alexei/?m=200706)
The data is available in the following formats:
CSV MS Access 2000 SQL Syntax file XML (http://blogs.nitobi.com/alexei/?m=200706)
Alexei White is also on LinkedIn--- Profile Here. (http://www.linkedin.com/in/alexeiwhite)
Thank you Alexei for making this resource available!
Cheers Tony...
MS Access Hints and Tips Club (http://www.ecademy.com/module.php?mod=club&op=join&c=3970)
I am trying to creat a booking system for cars which has a specification of being able to be hired by the 'week'. I am thinking of creating a table with every week date (every monday) from Feb 28 2005. Just wondering how I would create a table do to this with an append query?
I was thinking something like looping from Feb 28 2005 (monday) and dateadd + 7 a few hundred times then having an HireID field in the same table and once a car is booked for a one week period its start date hireID (or CarID) are entered into the database so nothing can be double booked.. I am just not so sure how I would reuse each date for all the different cars?
My problem: There isn't enough free memory to update the display.
I looked all over the internet about this error but without any success.
Facts are:
1. I keep getting this error anytime I try to Print or Print Preview or export to PDF an Access Report (same error for printing Forms and maybe other objects).
2. I received this error when using Office 2007 with the same mdb and also after upgrading to Office 2010.
3. The same mdb on any other computer works perfectly. I can do Print, Print Preview or whatever I want. This seems to be related to this laptop I am using.
4. Resources are not a problem on this laptop: 3Gb RAM, Paging: 1Gb on sys drive C and 2Gb on D. The other machines have less.
Hello !:) I need to make a SQL query in Microsoft Access. The database is in French but you will easily understand, if not please ask me to translate. You will find the MDB Access file inside the attached ZIP file.
The query I need to make is ::rolleyes:
We want for the next sent of books to the members of l’EST-SUD (WEST-SOUTH in English), to test the equivalences of the books.
We want to send for each book from the “genre” (theme in English) “Animaux” the most expensive equivalent book, we want to give a list with the original book, the recommended price (PrixCons in the database) and the most expensive equivalent book with his price.
-“NoLiv” is the book number in the database. -“TitreLiv” is the book name (title) in the database. -“NoGen” is the theme (genre) number in the database. -“NomGen” is the theme (genre) name in the database. -“PrixCons” is the recommended price for the book.
This is the query I tried, but it isn’t working ::confused:
SELECT DISTINCT * FROM LIVRE AS L, EQUIVALENCE AS E WHERE L.NoGen IN (SELECT G.NoGen FROM GENRE AS G WHERE G.NomGen IN ("ANIMAUX")) AND E.NoLivEq IN (SELECT LI.NoLiv FROM LIVRE AS LI WHERE LI.NoLiv IN (SELECT MAX(LIV.PrixCons) AS [Prix Max Livre Equivalent] FROM LIVRE AS LIV WHERE LIV.NoLiv=LI.NoLiv)) ORDER BY 2, 3;
SECTEUR (N°Sec, NomSec) ADHERENT (NoAdh, NomAdh, PrenomAdh, Sexe, DateNaissance, #N°AdhResp, #N°Sec) MEMBRE (NoMemb, PrenomMemb, Sexe, Age, #N°Adh) GENRE (NoGen, NomGen, Exemples) LIVRE (NoLiv, TitreLiv, ThemeLiv, PrixCons, #NoGenre) ENVOI (#NoMem, #NoLiv, DateEnvoi) ETUDE (#NoMem, #NoLiv, DateEtude, EvalEt, Commentaire) EQUIVALENCE (#NoLiv, # NoLivEq) Primary keys are underlined and foreign keys have a # before them
I have a list of 500 PDA users, spread over 7 offices. I want to keep an eye on what happens with the devices and their SIM-cards. As they are often swapped between offices and SIM-cards get lost. I am pretty sure that I don't have to re-invent the wheel. Do you have any idea of a free/shareware tracking tool for PDA's and cell phones ?
The correct way is the following: Inc# 2546 ^ capital I, no space between "c" and "#" but a space AFTER the "#"
Then the 4 digit long number.I was thinking along the lines of trying to identify the number, removing everything else and then placing "Inc# " before it... currently we allow notes, which should be made like such: Inc# 2546 - Notes.however, people have their own method for this too (however most of them are at least after then incident number so that makes things much easier)another issue is on the same database, some manual requests also appear which have different entry format: RQ# GK034LW2052 but that contains a mixture of letters and numbers... so when identifying the request number... as long as I make sure that it is a number and not a string of numbers and letters, I should be ok..
I have a table which lists all documents that refer to a certain entity. the table contains the file names and paths. I would like the user to be able to search for text inside these documents.Can I use Windows Search for that by using code? Is there any other way?
I have a simple data entry form with drop down facilities on 2 fields. One of these fields incorporates a drop down list from a table but there are occasions when I wish to make a free text entry for the single record, but do not wish to add it to the drop down list.
I have tried to achieve this with a Combo Box but without success, although I am sure that I have read that it is possible.