Search results

  1. I

    Schedule Report

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

    customer history

    oh dont worry i understand now thank you:)
  3. I

    Cancel appointment

    Heya, I'm trying to d that now.. What would the cstr represent? Is it a form name?
  4. I

    Cancel appointment

    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 :)
  5. I

    customer history

    Just a quick one.. What does SELECT top 10 customer ID mean? im not too sure about how i would do it?
  6. I

    customer history

    Heya, where would the code go? :)
  7. I

    customer history

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

    customer ID link

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

    Double booking preventation

    Hiya, I just want to be able to have a form that creates an appointment and when choosing the time it will only display times available for the dentist for a particular date. so in other word the times that are not available will be removed from the list of times ( displayed as combo box)...
  10. I

    New Apt

    heya how would i do the selection form? this sounds like a good idea ps. im not great with access
  11. I

    Double booking preventation

    final print shot which shows the time combo box record source
  12. I

    Double booking preventation

    Hello :) I am stressing out over trying to prevent doublebookings on my database which ive spent 2 days trying to figure out :( so what ive tried to do is : use queries that will take one away from the other so that when i go onto my form which creates appointments it will do this: Select...
  13. I

    relationship issue

    Hello :) this msg appears when i try to make a relationship
  14. I

    Error msg

    i dont understand it tho... im really inexperienced with access. how do i fix the error?
  15. I

    relationship issue

    Hello, Im trying to connect my TimeslotID in times table to timeslotID in appointments table.. but it wont work :( data type of timeslotID in times table : primary key and autonumber and in Apt table it is :number
  16. I

    Error msg

    can somebody please tell me what this means pleasee :)
  17. I

    input mask

    Oh your right, thank you :) Also could you tell me what this error means? please
  18. I

    input mask

    Hello, I have set input mask for appointment date as dd/mm/yyyy... but it doesnt seem to work as this error message is now appearing Anyhelp would be great:)
  19. I

    New Apt

    Hello :) Ive created a form that creates a booking for a dentist. My issue is where we type in the customers name. what if they have the same name? how do we know which one is theirs ( and what if they dont know their customer number?)... In this case i wanted to somehow have a part where on...
  20. I

    Error

    Hello guys, im really worried this message has appeared on my DB... i have backed up and im really scared my work wont work because when i click on certain buttons that had code it doesnt work... please see image :(
Back
Top Bottom