Search results

Yeah, i can see your point, if the regular guy leaves..(most likely not, under a duty of contract they've signed), in other circumstances of regular guy leaves, he'll be assigned with another, if ill, then lesson will be cancelled and rescheduled, like in rl. Rather having another instructor to...

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...

Most of the theory talk on the link you given was straight forward other than that, i found the answer i was looking for :D Thanks jdraw!

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...

Thanks gemma-the-husky, very helpful! :):)

Thanks for the info! Yup, especially the url on the How To. :)

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...

Ah :) Thank you

Im not calculating between quantity, im calculating the fields which contain the cost and i want the total cost on the report: =SUM([Cost]) but brings up error..

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...

#Error This the error i get

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...

Anyone know how to do this? Thanks

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...

:D I see where i have gone wrong with this problem. Your example works perfectly. Thank you very much, Much appreciated :):)

Hi Ethereal, thanks for your reply. I tried inserting the sample code you have given me and put it into a text box in the form design under: Control Source. I made some adjustment to match mine: [txtDate]=Me.ComboDay & "-" & Me.ComboMonth & "-" & Me.ComboYear but it doesn't seem to work...

I think you mean the: Tab Control Look at ur toolbar in Access and scroll down til it displays: Tab Control Hope that what you mean.