Search results

  1. I

    Boolean

    Hello, I have created a table with some fields one of which includes Gender.. i have made it into a combo box with the values of either male or female.. is there some sort of way of making it boolean if that makes sense? Or is it already data typed to boolean? Thanks:)
  2. I

    Parameter Query

    thank you:)
  3. I

    Parameter Query

    Hello, I am reading some code for a query.. SELECT Rooms.RoomNum FROM Rooms LEFT JOIN [Rooms Reserved] ON Rooms.RoomNum=[Rooms Reserved].Room WHERE ((([Rooms Reserved].Room) Is Null)); can someone tell me what it means.. thank you
  4. I

    Updating Forms

    i had done that previously and for some reason it created a query although it did update..
  5. I

    Delete inactive members

    its for my coursework..
  6. I

    Delete inactive members

    Hello, I have created a database containing customer records and i wanted to somehow add a part where an individuals records will automatically be deleted if they are not active for 3 years+ Please may i be advised of a direction to take Thanks.:)
  7. I

    Updating Forms

    Hello, I have made some changes to validation in my table fields however it has not been updated in the form. can someone help me please:)
  8. I

    Search Qry

    Hello, Im trying to make a query on one of my forms.. and i had this code from class but i think i may have copied it wrong.. "e "*"" & [Enter Surname] & "*" i know there was the word Like in the code somewhere but i cant remember:confused: Please may i be advised thanks:)
  9. I

    Sign In Sign Out

    Thank you :)
  10. I

    Sign In Sign Out

    I do not wish to show what has been down, and thought my explanation was clear enough as this work is part of my coursework project and i am not allowed to post it to the public. In plain english : What should i expect to be doing with a 'multiple item form' in regards to clients signing in and...
  11. I

    Sign In Sign Out

    Hello, My teacher instructs me to make a 'multiple item form' in regards to signing in and signing out of a dentist ( my scenario) .. The fields i have are : Appointment ID, dentistID, Appointment time, Appointment Date and customerID.. I dont really know if coding needs to be done or what...
  12. I

    multiple item form

    hello, im creating an appointment form which contains customer details and appointment details e.g. date, time, etc.. He told me i had to create a multiple item form...but im not too sure why or what i need to do with it.. could someone let me know? Thanks
  13. I

    Linking Forms

    Actually dont worry i think i will just do what you suggested first as it is simpler and i dont think my exam board expect me to go that complex as with the second suggestion. Thanks very much for your response youve been great help:)
  14. I

    Linking Forms

    thank you very much :) as i am quite new to access the link is rather confusing (sorry) would this be the code i use? and if so where do i insert it?? Dim dbs As Database, prp As Property Const conPropNotFoundError = 3270 Set dbs = CurrentDb On Error GoTo Change_Err...
  15. I

    Sign in and out

    Hello, Im creating a database for my dentist (coursework)and i need some sort of sign in and sign out aspect.. I dont really know how i should go about this.. Should i set soemthing up where the client enters and tells receptionists their details who will then sign them in and then out? If i...
  16. I

    Searching on a form

    Hello, I have a table containing customer details and a form which allows you to view them like records. I wanted to know how i could make something that enables me to search their fullname that would take me straight to that record. :) please may i be adviced thank you :)
  17. I

    Linking Forms

    hello thank you very much for your response.. as i am rather inexperienced with access could you explain your third option a bit more please as this is the direction i feel is best :)
  18. I

    Registration Form error message shouldnt appear

    hello, before my registration form is submitted i have created a message box saying "would you like to submit?" but it pops up as if it were to be an error message.. i will attach my coding and the pop up .. Thank you :):):):):):):):
  19. I

    Booking/Appointment System

    hello, i am currently trying to make a booking system for a dentist. i am quite lost with it, could someone please give me a direction/ideas on how to go about it.. To date i have created tables of: -Customer details : customerID, name, address, medical conditions etc.. -Employee details...
  20. I

    Linking Forms

    Hi guys, Thank you for my time i will just get straight in :) Current State: Main Menu Form containing buttons to Customer Details, Registration, and Bookings. Problem: The Main Menu should only be accessed when login is successful. At the moment I have created the login form and coded it so...
Back
Top Bottom