Search results

Hi, The attached sheet is a scaled down version and does what what I want. However it seems to be restricted to a certain formula size. When I try and use the formula originally posted it says it's too big. Basically I want the formula to add the values associated with specific teams.

I've just put the following forumla into the cell of an Excel sheet however I got the error 'Forumla too large'. Is there any way I can reduce the size of the syntax? I've been looking at nested forumlas but can't work out if this is what i need...

Thanks for the response. I missed what now seems a vital piece of information. I have other sheets in the file so if the workbook is deleted the other sheets will be lost. Is it possible to do without deleting the file?

The combo value is a number. I have tried without quotes but still get the error. :confused:

I have the following statement which exports data based on a query to a .xls: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryreportsbydate", "C:\Documents and Settings\pdainty\Desktop\RawQualityData_Weekly.xls " This works fine it exports the data and names the sheet...

I've written the following routine however it's not working for some reason. Basically I want to set the value of AG3 to match the value of H7 on sheet 2 when number 1 is selected in the combo box. Is there something wrong with my syntax? Private Sub ComboBox1_Change() If Me.ComboBox1.Value =...

I have the following statement which exports data based on a query to a .xls: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryreportsbydate", "C:\Documents and Settings\pdainty\Desktop\RawQualityData_Weekly.xls" This works fine it exports the data and names the sheet...

Excellent! works perfectly, thank you.

Can i use SQL in Excel though?

I want Excel to add up at set of values that correspond to someone’s name. The number of values can vary. The following is how my data looks in Excel: Dave 25 Dave 30 Dave 42 Paul 35 Dave 9 Paul 44 Paul 78 Dave 4 Dave 21 I want to use some kind of lookup...

Yes my fields wern't defined as numbers. I have now changed the field type in the table and this has corrected the problem. Many thanks !

I need to be able to add up and display the total of a number of values. My thinking was to use an expression behind a txtbox as follows: =([S1])+([s2]) The value of S1 is 100 and the value of S2 is 50 My expression doesn't seem to add the values it just displays them like this: 10050 I...

Works perfectly - thanks Bob I didn't realise you needed to reference the main form

No I hadn't, thanks Bob. Here it is, you'll find the problem code in the on click event of the Date text box on the subform of frmFeedback

Hi Bob Can i email to you? I've tried deleting tables and forms but the size of the mdb won't reduce and exceeds the max upload

Thanks Bob, unfortunatly it still won't work. I've checked and my check box is definatly called chkQ1. I've tried using me.chkQ1 and get the same error when the code hits chkQ1. The strange thing is i can run both bits of code independently. It's only when i combine the original code with the...

hi Bob, It's the first line of the IF statement - If chkQ1.Value = False Then

Hi, Yes the code shown is working. The problem i have is when i add a series of IF statements to the end of it. Ideally the code below is what I want to run. When i try to execute i receive the following error: "Run time error 424 - object required" Private Sub TicketRef_Click() Dim rst As...

I have the following code below which works perfectly. I am trying to add a series of IF statements to the end of it. However, when i execute the code I get an error. Does anyone know why? I know the IF statement works as I can execute it behind a command button Private Sub TicketRef_Click()...

I'm trying to get the following code working when a form loads: Private Sub Form_Load() txtQ1.Value = DLookup("[Q1]", "tblQ1") Basically the value of txtQ1 is populated with the value of Q1 in tblQ1. When opening the form the text box doesn't populate. It's strange becasue I can get the...