Search results

Hi, i searched through some of the threads on how to prevent double booking but my concept is too much complex to prevent from double booking..which i think it is..nehow. Right, my database is about client booking a driving lesson. One instructor can have many clients but one client can have...

Hi, i have several tables in my database, wanted to know if the tables between: Client -----> Theory Client -----> Practical are 1 to 1 relationship, right? Client can do one Theory, Practical.. but what if Client failed Theory, is that saying they can do more? I'm confused with the whole...

Hi, im currently under going a Driving school project database. I have the following tables, Client, Instructor, Lesson and Lesson Type. However i feel like i want to go into more depth, e.g. make tables like recording sections of theory and practical tests, etc. Currently my database with 4...

Hi, i'm trying to calculate the amount of employee for each company giving me a total in the queries.. how do i go about this? I'm not an person who uses Access to solve this. I have amount 20 Companies stored and over 800's employee.. Here are the field in the table: EmployeeID...

Hi, im struggling with my project. I'm not sure how to pursue this, but when i a customer to book a lesson, i want the booking to be not booked twice. So i have to prevent the date of when the customer wants his/her lesson to be booked on the same day as the other person. I'll be very very...

Hi, producing my reports i've got a list of cost. I used the method: =SUM([Cost]) in a text box using a Control Source, yet it brings up an error... y? one of the title is: Cost Which im collecting the total cost

Hi, i want to able to produce a report to allow me to preview previous month records. How many i approach this? I'm able to get simple criterias such as finding date, specific info. But to me, this seems like a different approach. Thanks

Hi, searching through the forms section, i see one person has a similar problem as me but mine is in a different way. On my form, i have a 7 radio button done by the wizard, labeled: Monday to Sunday and 4 check box labeled with times which club is opened. What im trying to find out is, if i...

Hi, i'm having troubles using the wizard to enable me to insert fields all in one form. I was wondering if anyone know a source code so when i start a new form from scratch, no wizard to help me. That I can use the event procedure to enable me to look up the source or the Control Source using...

Hi, im able to produce the following 3 combo boxes, Day, Month and Year. By selecting a date using the 3 combo boxes onto the Form. I want to able to insert the date into the textbox. Any ideas how i might able to get it working on the forms? Many Thanks