Search results

Can anyone help me develop the following code so that I can capture data from specific sheets(if they exist) within a source workbook? The code below scrolls through and opens files from within 3 folders on my network drive and copies a specific range from sheet1 to a NEW workbook(Sheet1)...

Can anyone tell me if the SUMIFS function can work in this way? I used something similar with the SUMIF from and earlier post which worked great, but now need to use multiple criteria. This code is producing the #Value...

Hi, Can anyone tell me if its possible to use the LEFT() function or an equivalent function within this formula, =SUMPRODUCT(SUMIF(INDIRECT("'"&$E8&"'!$F$6:$F$20"),$F8,INDIRECT("'"&$E8&"'!A$6:A$20"))) The INDIRECT(ref_text) is working perfectly when it finds a complete match, but I want it...

Can anyone help me please? I have a report that contains a subreport that I sum for each section and it works perfectly using a text box. However, I am now wanting to sum those text box values to a Report Total and show it in the Report Footer! I have been trying to sum the text boxes which...

Can anyone help me here please. I am using a Subform (summary List) to allow users to scroll and select a record ID. The record ID has a OnClick event that moves the Main Form to the selected record. All working fine appart from the Subform refreshing once the Main form displays the record...

Can anyone help with this Form issue please. I have a combo box on my form where the user selects a Currency(cCur) from a query. Each currency record in the query has related exchange rate fields, GBP and USD. The user also inputs a value(pVal1) that I then want to use in calculating...

Runtime Error message 94 Can anyone help with the following? I am trying to use the MONTH function within the following procedure but I get an 'Invalid use of Null' error when [StartDate] is blank! Private Sub StartDate_AfterUpdate() Dim aMonth As Integer aMonth = Month([StartDate]) If...

Can anyone tell me if its possible to run a function on sheet1 if any cell values change, while i am working on sheet2.

Can anyone tell me if its possible to password protect a Checkbox?:confused:

Can someone tell me how to use a combo box from a form as the criteria for a report? My report is using a select query and this is the code from the criteria box in the query Like [Forms]![Estimate Details]![Estimate] My report come up blank!:mad:

:confused: Can anyone tell me how I can phase a value (Linear) between 2 dates?

Hi, Can anyone tell me how to resolve the following in Access2007? I want to calculate [TotalCost] and it should be calculated on [Quantity](If >0) or [Days](If>0) which ever one is input! * [UnitPrice]. Then I want this number factored up using any or all of 3 Factor fields but only if...