Recent content by paulcraigdainty

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