Recent content by TheBlade

Great I can work with that, excellent thanks alot Skip!!

Thanks Skip, unfortunately I am not a VB expert. Can you plse give me a quick example? Perhaps one that takes the results and puts them in adjacent cells? Thanks Vince

Hi I have a List Box control on my worksheet with 'Multi' selection type, and I would like VB code to return the values selected. Please note that the control is on the worksheet, not in a user form (I've searched for a solution but the only ones I've seen refer to list boxes on user...

Eureka! Figured it out. Using the example: =SUMPRODUCT(Mth*(Product=$A38)*(Hub=L1)*(Measure=L2)*(Type=L3)) To accomodate ALL Hubs when cell L1 is blank =SUMPRODUCT(Mth*(Product=$A38)*(Hub=if(L1="",Hub,L1))*(Measure=L2)*(Type=L3)) and so on and so forth for any other conditions that may...

Eureka! Figured it out. (SkipVought - the model currently uses sumproduct, just adding to its functionality, and not enough time to overhaul the structure unfortunately). Using the example: =SUMPRODUCT(Mth*(Product=$A38)*(Hub=L1)*(Measure=L2)*(Type=L3)) To accomodate ALL Hubs when cell L1 is...

SumProduct with a wildcard. I have some criteria that may be blank, in which case I don't want them included in the SumProduct at all. The forumlae are in a table, the structure of which needs to remain static (as opposed to pivottables) for charts. I am trying to stay away from Dsum, as each...

Basic/cutdown example of my problem: =SUMPRODUCT(Mth*(Product=$A38)*(Hub=L1)*(Measure=L2)*(Type=L3)) Sometimes L1 (Hub variable) will return blank in cases where users want to see the combined result for ALL hubs...same for Product, Type etc. If anyone has any ideas would be appreciated. Thanks!

Thanks, I tried to stay away from Dsum, as each row in my tables has different criteria (based on user input form, row and col headings etc.), which with Dsum would require lots of hidden criteria ranges, sounds similar to yours. Tried searching everywhere for a Sumproduct solution but to no...

Hi, I have this exact problem too, and prefer sumproduct as the table structure needs to remain static (as opposed to pivottables) for charts. Anyone have any ideas or solution? Thanks

Any ideas? Anyone?

Hi We automatically receive emails when we make sales from a NZ auction site (similar to Ebay). The emails notify us that we've made a sale and include the email of the buyer WITHIN THE TEXT of the email. We use MS Outlook 2002. Question - does anyone know of some sort of macro or rules...

Hi We automatically receive emails when we make sales from a NZ auction site (similar to Ebay). The emails notify us that we've made a sale and include the email of the buyer IN THE TEXT of the email. Question - does anyone know of some sort of macro or rules addon that could search those...

Hi I have 2 tables: 1. GL account (which shows GL account number, name and account type etc.), and 2. GL Entry (values posted to GL accounts). GL accounts in GL account table with an account type of 4 are totalling accounts. I created a query which shows the range of accounts they should...

Solved it (thanks to Larry De Laruelle)..simple too, dang! Future ref for anyone else: "I think we may be back to size. What is the height of the subform on the tab? If it is larger than the available screen space, Access will scroll down automatically on load (or so it seems to me)...

Hi fwatanabe The only difference between this form and the others, is that the subform on this particular page has 2 subforms within it (i.e. 2 subsubforms). And it only happens when this when the fields in the subform of this tab control page are populated (i.e. when i'm adding a new record...