Search results

yes i have combo box for dentist not customers because there are too many records... the customer ID and dentist ID saves in the appointments table because they are in the table as foreign keys.. its the other details like contact number that im confused about

thank you so much for your help but im still confused :( for the other details these are entered into the system from other forms ie new registration... so yup they will be in the other tables but i dont understand how when i explain that new appointments will be stored in the appointments...

Hello, I really need help and im so stressed out i cant understand. Ok so im doing a project and i made a requirement spec of which has this: must store appointment ID, customer ID, forename, surname, contact number, dentist ID, forename, surname, room, appointment date and time... what...

Heya could someone please explain this query to me in depth? i know its an update query that signs a user in when they have a booking but i dont really know how i would explain it in depth.. any help would be lovely:) thank you

Im really for my dumbness... i cant really find it :( i cant even find the bit where it says orderby anymore

im not quite sure what you mean...

HIYA :) does anybody know how i can print my report my groups? :) I have a report displaying dentists schedule and i have grouped by each dentist :) i want to be able to print out a page for each individual dentist :) Any advice would be great :) Thank you :D

Hiya, Thanks. i failed to google it corrctly when i originally tried. i wrote how to put time in order on access... which failed

what do you mean haha.. and thank you for helping. i wish i could :( but its my for my school project and ive been told strictly not to post it online

oh thank you very much ive done it now :) Also how would i do the same for a form? :)

ive sorted it by dentist name ... so im not sure how i would apply that :(

Hello, Ive got a report displayingg appointments, only issue is that it doesnt display these times or date in order of earliest first...

Hello, Basically I need this to happen : Enter customer number = customer ID, forename and surname BUT, what is happening is.... Enter dentist ID= customer ID ( which does not apply to anything ie i dont even have a customer with that iD) sorry i wasntclear :)

Hello :) Ive made a create appointments form and the issue is when i type in the contact number of a customer it should automatically fill in the forename,surname and their ID number based on this info... However this is not the case. Instead When i enter the dentist forename and surname it...

Hiya, Where can i find that? :)

Hi, Im trying to make a report which shows a timetable of a dentists.. ive made a query and created the report but i dont really know what i need to do to achieve the following: Group by Dentist name Times for each dentist should display the earliest first.. tHANKS:)

Hello, Ive made a very basic login form which allows the user to enter their login details and replies back with either error messages or to the main menu on successful login. My question is... i have receptionists and opticians who should not be able to access the same things on myDB... is...

Hello :) I Have a form displaying all appointments .. i was wondering if there was a way where the appointments that have passed would be removed from this form... im pretty sure its something to do with me.refresh but then again not too sure.. could someone help me please Thanks

Hi :) oh i do :) what would i put in it? the timeslot field name or some sort of code?

Hiya I have a form that views all apppointments today, i was wondering if anyone could tell me how i could make the all appointments be ordered where the timeslot is the earliest to the latest. Thank you:)