Recent content by ICTkirsten

  1. I

    code for refreshing form?

    The code behind it was just to prevnt blank fields so just notnull statements. and yes thats exactly what i want :)
  2. I

    Validation Error

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

    code for refreshing form?

    the image help 2 is the query used for help form 1
  4. I

    code for refreshing form?

    ok so, The main is based of the query which generates the appointments today so thats how the main form was made.. On this form i have a subform which allows me to add new teeth details The other subform is just previous records of the customer to help with appointment ( no purpose really...
  5. I

    code for refreshing form?

    here you go :)
  6. I

    code for refreshing form?

    the remaining images
  7. I

    code for refreshing form?

    Thank you, Just thought i would add that that the sub forms do not run any queries apart from the history which is just a select top 10.. il attach the last image in another reply as it all wont fit :) Thanks so much for your time
  8. I

    code for refreshing form?

    Ive got an appointment form that displays a customers appointment details and with this are 2 subforms 1 of which is for data entry, the other is for reference. -- And this is for my school project which im not allowed to post up incase someone was to access it and use as their own ( just...
  9. I

    code for refreshing form?

    Just tried, they dont work:( or am i meant to replace some of the words in there with my own?
  10. I

    code for refreshing form?

    still doesnt work :(
  11. I

    code for refreshing form?

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

    Select Top issue

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

    Login form Security

    i have just created validation so if the field is blank the user will be prompted with error messages... And oh okay thats great do you mind giving me a bit more details? or if theres something i can find to help me please :)
  14. I

    Login form Security

    are there any simpler ideas out there? my teacher says its straight forward... ive been trying to work it out for months now
  15. I

    Login form Security

    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...
See more
Back
Top Bottom