Search results for query: *

Fantastic it now works! Thank you very much PHV and Skip

Hi thank you for this but now I get a Run-time error! Run-time error '1004': Application-defined or object-defined error The VBA code indicates that the cell is empty? Am i approaching this in the right way.....using a cell value to drive the pivot dropdown criteria??

Hi WHAT i am trying to do (but failing miserable) is to use a value from a cell to replace fixed text in my code. In my 1st posting example I have fixed text of "TRENTSIDE", i would like to refer to a cell value to replace the text "TRENTSIDE" So if the Cell (I8) value = SOUTHSIDE then my...

Thanks for your assistance Skip I have replaced TRENTSIDE with the cell reference and get a compile error: Expected: list seperator or) It does not appear to like the sheet name "Pack" ActiveSheet.PivotTables("PivotTable1").PivotFields( _...

Hi I was hoping that someone can point me in the right direction in showing me how to refer to a cell value inside VBA code. I am working with pivot tables where i select from a list to give me the values i require. So far i have managed to create and run a macro that selects the values for...

Good idea Skip, i will give it a go....thanks

Hi I am struggling with that as the information comes from a huge data set accessed by many different areas. I want to access just 21 of possibly 200 areas. Is there a way I can loop but only pick out the ones I require? I am not an expert in this area so any assistance would be gratefully...

Hi Hope this makes sense! guidance would be much appreciated.... I send out a monthly report that is sent to 21 different organisations. All of the 21 organisations info is held in one excel spreadsheet and i use a pivot table and dropdown box to filter the information. The next procedure is...

No problem....just very thankful for you assistance. Thanks again

Thanks SkipVought Brill, works a treat.....after I realised Dsiplay was slightly misspelt lol! Other points took on board!

Hi From a command button in an Excel spreadsheet I am filtering data and copying into a new workbook a number of times. I am working with Excel 2010 and saving the new workbooks in 2003-2007. Everything works really well other that I constantly get the the Compatibilty checker message box come...

Hi MajP Thank you again for the extra information. You have explained it extremely well and it is much appreciated.

Brilliant....thank you very much it works fine now! I had tried the contact_id in the code but could not get it to do anything......looks like the bound column was where i was going wrong! Thanks again

Hi dhookom Thank you for getting back. I have a primary key field but the users wish to search by surname as the unique contact_id number would not mean anything to them. My combo row source reads: SELECT tblContacts.Surname, tblContacts.[First Name], tblContacts.Contact_ID FROM tblContacts...

Hi I have a combo box that filters a contacts form depending on what is selected from the list. The list works on surname. Everything works fine until there are more than one surname the same. For example: Bloggs J Bloggs B When I select Bloggs J or Bloggs B it only ever filters to Bloggs B...

Brilliant! Thank you MajP for pointing me in the right direction. Worked a treat!

Hi It has been a while since I used Access and can't get round a concatenate query problem I have. I am trying to concatenate a field (service) for all records that have the same identifier. The query I have wrote is: ServiceArea: Concatenate("SELECT [Service] FROM tblStudies WHERE...

Thanks fneily The code is very good at giving me all the combinations but I still need to pick the best permutations so that we all play a game with each other. Still having to go through the list long hand. Could really do with a counter that counts how many times two of the number come up...

Hi Here is a poser!! Is there an easy way using an automated spreadsheet to determine how many times a group of numbers appear with each other? I am organising a golf trip for 12 people and we are playing 5 rounds of golf. We will be playing in groups of 4. I am trying to get the ideal...

Brilliant! thank you very much everyone. pwise - well spotted, I could have stared at that all day (nearly did!) and still have missed it. PHV and TheAceMan1 - great examples of different styles. The simplified method suits me as my typing is so slow!! but for readibility and future...