Search results

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

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.

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?

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

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

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.

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

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?

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

here is my db

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

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

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

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.

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.

That was perfect, thanks :)

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

Thanks, that answer was so simple :)

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?

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