Search results

I need a little direction in starting my project I have spreadsheets called allocation sheets. These are yearly documents and each row is a service instance. The row headings are: Date Purchase order # Req # Child Name Service Requesting Organisation Caseworker Name Price ex. GST GST Price...

I am trying to create a complex formula for my work. It has different rates for mon-fri, weekends and public holidays. I am trying to work out how to mathematically calculate when holidays that change each year, are to fall, such as Easter. This way, it won't need constant updating as I will be...

I have a table added to my spreadsheet and I have two buttons. One to add a row to the table and one to delete a row from the table. When I put them in, they both will work but then I go and do some other formatting on the spreadsheet and I come back to the buttons and I click them and only the...

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

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

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?

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.

I have a combo box to select the town on the form frmCarers. I want a 2 text boxes below, txtstate and txtpostcode to be automatically updated when I select a town. I also need them to not disappear if I am to close and open the form.

On my form, frmCarers, if you scroll down to the Carer Notes at the bottom, why is the background of the first date white, where everywhere else is as it should be?

I have a combo box for selecting a town in the address and if the town isn't in the list, there is a button that opens a form to add a town. Once I add the town, I have a OK button that I want to requery the original combo box so that the new town appears in the list but I am not sure of the...

I have a database made that has a form which shows the type of care that carers can provide. At the moment I have some checkboxes but I had it recommended to me that I should make it combo boxes so it allowed the addition of extra types of care but how would I do this? I thought I could have a...

I want to requery combo boxes on sub forms to a main form. I have the code in the on current event of my main form Private Sub Form_Current() Me.Form.Requery Me.frmCarerAvailabilitysubform.Requery Me.tblCarerNotesSubform.Requery Me.tblChildSubform2.Requery End Sub However, will this requery...

My listbox is blank and I don't know why, must be something I am looking right over. The form is called frmLTCareNAvailable. Could someone take a look and let me know what I am looking straight over please? Thanks

I want to enable a combo box upon selection of a checkbox. It is stored in the form called tblChild subform2. The name of the combo box is cboRelationship and the check box is chkRelated. I am a novice at coding so I looked on the net for an answer and here is what I found and tried to adapt...

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?

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

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?