Search results

  1. D

    Auto update of a field depending on the number of entries

    Whenever I open frmCarers I get the error message I have attached . I have also attached my db
  2. D

    Auto update of a field depending on the number of entries

    Can someone help me please as I don't understand this code so it is really hard for me to troubleshoot why it is not working.
  3. D

    Hi Mike, I need some help. The guy who was helping me has bailed and decided not to help me...

    Hi Mike, I need some help. The guy who was helping me has bailed and decided not to help me anymore and I don't understand coding at all. Do you have an email I could email my db to?
  4. D

    Auto update of a field depending on the number of entries

    The error was in this bit of code you put in my db but I can't debug it as I don't understand it. Public Function fncUpdateCarersAvailability() ' make carers available when the CarersDateAvailable has lapsed DoCmd.SetWarnings 0 DoCmd.RunSQL _ "Update tblCarers Set...
  5. D

    Auto update of a field depending on the number of entries

    Here it is, I have pretty much finished it. That would be awesome if you could make those little adjustments that you made with the last file. Thanks
  6. D

    Auto update of a field depending on the number of entries

    Thanks for that. Only problem is I tried to open the file and there was some error in the code. I will get back to you with an updated file as I have been working on it and will be working all day today on it.
  7. D

    Auto update of a field depending on the number of entries

    Thanks for that Mike, only problem is that I can change the carer on my first record that is at the maximum allowed to the bottom entry that is not at their maximum allowed and the text doesn't go away for the first one. How would I make it so they are not at their maximum allowed anymore and...
  8. D

    Publishing database

    I have pretty much finished my database and I am going to split it but I was also wondering about if you could publish it to a network drive so when users open it, they are directed to the entry form without needing to pick from all the available objects?
  9. D

    subform relationship

    Thank you, that is perfect!! YAY! Now my db is complete :D
  10. D

    Opinions

    here is my db
  11. D

    Opinions

    Sorry, I just thought it should be in a new post.
  12. D

    subform relationship

    I can't remember how to do this. I know it is simple but I just can't remember. I have a form, frmCarers and I want something at the bottom that shows a list of the children currently in their care. I know how to get all the children on there but I just can't remember how to make it so only the...
  13. D

    Auto update of a field depending on the number of entries

    I just found out that my manager wants to be able to manually specify if a carer is unavailable for other reasons, such as they may have just been admitted into hospital. However, he would like it to automatically change to unavailable once they have been assigned the maximum number of children...
  14. D

    Opinions

    Thanks for that! I guess I didn't make it very specific as I didn't know exactly what I wanted. But I love that drop down box you added to open up various tables regarding the search criteria. I would love to learn how you did that.
  15. D

    Opinions

    Sorry if I don't respond to all messages, I haven't got a good memory so once someone tells me the answer, I go and try it and if it works I completely forget to come back and let them know if worked. I also don't know how to mark it as solved, I only know how to thank someone for a post.
  16. D

    Format I want data to appear in in a listbox

    That was perfect, thanks :)
  17. D

    Opinions

    I have a list box in a search form called FRM_SearchMulti and it searches through everything in my database. I want some opinions on whether I should have just the one list box to return everything (this way there will be multiple entries of the same data) or if I should have several list...
  18. D

    Opening position of a form

    Thanks, that answer was so simple :)
  19. D

    Opening position of a form

    Whenever I open the form called FRM_SearchMulti, it is already scrolled down the page so you can’t see the headings. What do I need to do to get it so I can see the headings above the list box when I open it?
  20. D

    Format I want data to appear in in a listbox

    I have a listbox on a form and I want it to return names and numbers. I want the numbers to be in a certain format instead of just one string. The format I want is: Phone: (xx) xxxx xxxx Mobile: xxxx xxx xxx The form I want that for is frmRespiteNAvailable Thanks, Dave
Back
Top Bottom