Search results

Hello, ive got a subform and in it ive put validation IsNull(Front) validation text : please enter front and another : IsNull(Back) Validation text: please enter back wierd thing is when i enter front i get the error msg please enter front... and when i press the save button when i dont...

Hello, I have 2 subforms on my form and i wanted to be able to view the next record ( on the normal form not the 2 subs) once the save button has been clicked. Ive used me.refresh but it just refreshes that subform and not the entire form to allow me to view the next record... ive also used...

Hello ive used this sql for my query to allow me to view the medication history of my customers but for the last 10 records only.. the only issue is it only shows about 5 records and some are blank i have 5 other records in2014 but only 2015 appear SELECT TOP 10 Medication.CustomerID...

Hello, I have a login form which works perfectly fine. Trouble is, i store the login details i.e. username and password in the employees table so technically other users who see this table will be able to login with that users login details.. Is there a way i can tacke this? Also how do i...

hi, my ive made a query to base my report off the only issue is the ' timeslot' wont appear on the report:// the timeslot needs to be displayed on the time the customer booked their appointment... can someone help me out please? ive attached my query :(

hello As part of my query to prevent double booking i used the attachment (ignore the format and how wierd it looks ive blanked out some stuff to change the names haha) My understanding of the query is this : it will only show results based on the user, from the new form and it will also only...

Hello, I Have a field called appointment date and i have set the input mask as short date 00:00;0;_ the data type for the field is date/time but for some annoying reason this error message appear when i enter a date to the table... which for example is written like this 01/03/2003 so im not...

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

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

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

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

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

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:)

Hello :) Im trying to create a report for 4 dentists appointment schedule showing : Appointment time , customer ID, forname, surname and dentist room... I want it to be on one report that has these details for each dentist on 4 seperate pages ( so one page for each dentist ) but im not sure...

Hi :) I wanted to know how i could create a form that cancels an appointment i guess through a query.. can someone give me some advice please Thank you :)

Hiya, Im currently trying to create a way of displaying a history of the last 10 records of a customer ONLY. so to try and make myself clearer; basically im a dentist and to perform operation i need to be able to view a customers teeth history for the last 10visits. So what i have ATM is a...

hello :) ive created a form that views appointments for today and alongside it has a subform that enables a dentist to enter details about a customer... so the main form (apt today) displays customer ID However in the subform it doesnt... can someone tell me how i can make the form have both...