Search results

That is what I was finding too, but I followed the instructions exactly and it still wouldn't work. Just thought someone else might see something that I am looking straight over.

I can't get the modification search tool working posted by John Big Booty here https://access-programmers.co.uk/forums/showthread.php?t=188663. It doesn't make sense as I have used it before, have looked at my previous dbs and my db looks exactly the same as the previous ones that work. What...

I tried making a query and putting some criteria in the field childCarersCarerID of if [qryallowedsum].[CountOfChildCarersCarerID]=[tblCarers].[CarersAuthorisedCareFor] then [frmCarers].[CarersAvailable].value=0 but it didn't work. Not sure how to write criteria. Was this even going...

Could I get a little guidance on how to compare the sum value to the allowed value please?

I have just thought of a problem when I was reviewing my db. I have a field called CarersAvailable within the table tblCarers. It is a yes/no field and at the moment it requires user input to change it. There is a field in the same table called CarersAuthorised#CareFor, which says how many...

Thanks for that. Now it works perfectly. I just needed to add in a joining table.

I have a form called frmChild and when I try and enter something in the notes section at the bottom I get an error, you cannot add or change a record because a related record is required in table tblchild. I keep getting error messages like this. Can someone tell me what I am doing wrong and...

I worked that bit out, thanks anyway

Thanks, I didn't think it would be that simple ;)

How do i separate a label from a combo box so I can put the label in the header and the combo box in the main part of a form?

What do I need to do to get my subforms on my child form to look like yours: I can only get my form to look like this: I understand you need to set it to a continuous form but how do you seperate the label from the text box for each field to put in the header?

So you basically write a query to display in the combo box?

I had a couple more questions. What are the square brackets used for and could you explain to me what "AS carer" does please?

SELECT tblCarers.CarersID, [CarersLastName] & " ," & [CarersFirstName] AS Carer FROM tblCarers ORDER BY tblCarers.CarersLastName; I understand that you are selecting the carerID row from tblCarers to identify that record. I just had some questions: 1. Do the brackets specify field data that...

The row source for the combo box, cboCarer in the form, frmChildCarerssubform is SELECT tblCarers.CarersID, [CarersLastName] & " ," & [CarersFirstName] AS Carer FROM tblCarers ORDER BY tblCarers.CarersLastName; Could you explain this to me please?

Could you help me with another problem I have now please? I need a way to assign a case manager and a carer to a child, or for that matter, could you please tell me how to do this as I keep encountering this problem with other areas of this and other dbs. This will need to have an option to...

That was great, thanks Bob. I tried to do that but when I dragged the notes form onto the carer form, I deleted the ID field instead of hiding it. You helped me work that out so thanks :)

I originally had a notes table in which I was going to store notes regarding everyone in the various tables, such as carers, notes, children, etc. I couldn’t get that working so I decided to create a table for each entity that I wanted to record notes for but that won’t work either. I don’t...

The problem with that is I can't enter any notes on the form for a previous record as it won't show any previous records. It will only show new records and I don't know why.

I have some more specific questions. 1. Regarding frmCarers, a. I already have some data in the form when I open it and when I tried to add a comment, I got the error You cannot add or change a record because a related record is required in table ‘tblChild’. I am not an...