Search results

i would but the issue is its my coursework so im not allowed. im trying to follow this link http://www.advanced-ict.info/databases/clash.html under the heading discrete appointments ive also tried this http://www.datawright.com.au/access_resources/bookings_without_clashes.htm

My solution, therefore, uses two queries - one that finds the appointments that have been made for a particular doctor on a given day its mainly this bit that i dont get

Hiya sorry i do not understand any of that haha please could you bare with me and make it clearer for me hehe

Hello, Im trying to follow this guide but i dont understand how to do some stuff which i will underline... also how do i subtract one from the other? Although the idea of the query - to find available slots on a given day - sounds quite simple, it's not as easy as it first appears. This is...

its just based on the street or road.. not too sure about US but here in London lets say i live in BW74 0SF then that will just bring up the road containing that postcode... in lonon as far as im aware the postcode only ever brings up houses/flats on that postcode for my case if makes any sense...

Hi :) Im making a DB and basically i have a registration form where they fill in their details.. I was wondering if anybody knew how to do the bit where the user types in their postcode and a list of possible addresses come up any advice would be great :))))))))))))))))))

Hello, Im dragging one of my forms onto another form but it messes up the layout each time and makes my textboxes all the same size as the subform :/ can somebody help me please thanks:)

Just a quick question.. The patientID and patientidfk... i dont really understand this.. arent the two the same? or should be the same? as they both identify the patient. what do they do? i dont understand what you mean by : " i then set the link field form to the subform" sorry for my...

This is absolutely terrific! :D:D:D:D:D:D:D:D You have been great help :) Thank you so much :)

That is could a Customer have different dentists for different appointments? Yes :) And could more than 1 dentist be involved on any given appointment? No :) What exactly is in your Time table? its just the times starting from 9:00- 5pm ( excluding 12-1 which is lunch) each appointment is 20...

Yes i have multiple dentists No the appointment doesnt its not needed in my case.. sorry i miswrote that it was meant to say dentist. The process goes: somebody calls in and books an appointment i make their appointment via my create appointment form. when their day comes the dentist has a...

Thanks for the swift reply.. I have attached my relationships and tables. Ps. sorry its really messy i had to rename things for confidential reasons

Hello, This is really confusing but.. I am creating a dentist booking system and i need some way to display appointments today for a certain dentist and then from their to click the customer and view their teeth details that the dentist will use to update... i know it involves a query but im...

Hello, I have a booking system for a dentist and it works fine. I Just somehow need to implement a way for the user to know when to contact customers for their next yearly check-up. So lets say bob has an appointment 01-01-2015 then his next appointment would be 01-01-2016 and i need maybe a...

Hello, Im currently trying to think of a way i can input details about a dental appointment . I was thinking to have a form containing the fields : TeethID, CustomerID, ,front teeth, back teeth... so the front teeth and back teeth are going to be figures that i input .. I need these figures...

i dont really have any code i just created a report based off a query.. sorry i didnt actually add attachment.. i have added how the report appears and the query :)

thank you very much

Hi guy, im quite new with making reports infact ive never really made on before... but at the moment i have something like this.. it doesnt display ALL the appointments that i have set in a seperate table for TODAY... Does anybody know why? do i need to add something to make it do so? and is...

Worked perfectly! thank you very much :)

i tried to do that but i dont know where to do it.. could you have a look at my design view and give me some advice please?