Search results

Are you saying to manually unlock the sheet? I wanted to have it locked, then be able to click a button to add or delete a row so I thought that you could have code that unlocked it, did what needed to be done then locked it again. I can't just look at the code and modify it as I don't...

That's what I have done but I am not sure of the code.

I have been asked by my boss to make a spreadsheet that is used for calculations. This spreadsheet has 3 lookup columns that change the calculations and 2 columns that measure units and number of workers required. These impact the price as well. I don't know how to code but I have managed to...

I have a tab that quotes are generated on. A list of providers are stored in another tab. I need a dynamic drop down list in the quote tab so that more providers can be added to the list. The list is rather long so it is sorted alphabetically to help find providers. How do I add a drop down...

Ok, I understand that concaternate is about combining the contents of cells but how does it work with vlookup?

But I don't understand what concaternate does.

Could someone help me understand how this formula for Excel works please? =IF(OR(ISBLANK(A4),ISBLANK(C4),ISBLANK(D4)),0,VLOOKUP(CONCATENATE(A4," ",C4," ",D4),Service_Price_List,2,FALSE))

I have an idea, how do I add a text box or something similar next to a drop down list that shows all the case managers, that has a count of CMChildCMID from the table tblCMChild?

I think it is because I have added in the query builder, a count of CMChildCMID, to get the case load but I think that is only showing entries that have those case managers that appear in that joining table. Can I still get a count of the case load, but also have all the case managers appear?

i also tried requery on the got focus event but that wouldn't work either. I thought something that simple would work but there must be some underlying issue that is stopping it working.

I tried that and it wouldn't work. What did I do wrong?

I am now trying assign Case managers to children and the extra case managers I entered are not appearing in my dropdown list in frmChild, what do I need to do to get them to appear?

This part is not in a subform. I have several phone number fields, phone, mobile etc. I want to make an alert for when there is no contact number entered. How would I do that?

Whoops, I just realised that the message box was commented out. I got rid of the comment and it worked fine thanks.

I tried putting this code in but it didn't work. Private Sub Form_Current() If IsNull(CarersFirstName) Then 'Msgbox "There is no first name for the carer" End If End Sub CarersFirstName is the field name, the table name is tblCarers and the form name is frmCarers.

Is there a way to make an alert go off if some data is missing for a record, when the record is opened in a form?

If I unselect a checkbox I want the combo box to clear. Can someone help me with that code please?

Sweet, thanks, I worked it out :)

How do I use conditional formatting to do that?

I have a form tblChild Subform2 that has a combo box for relationship at the end. Upon selecting the checkbox, I want the combo box for that record enabled but when I select it, it activates the checkboxes for every record.