Search results

Hi John64, Do you want a Function to produce the result of that formula? Does the formula work in Excel normally? (meaning manually not with VBA?)

Some screen shots explaining what the code is doing would be good too. When you refer to a 'Node' what do you mean?

Hi, Can you advise what the code is trying to do? A copy of the database would also be helpful, Thanks

Thermos Flask. A reporter is given a boring task on a slow news day, to ask passers by what the best invention in the world is & why. He stops a man who says "The car, they're affordable to most people & bring people together". He speaks to a lady next who advises "It's definitely...

I have had this problem before & after trying many different options, I copied the database (in case I completely screwed it up) & then deleted the Switchboard form & table from the copied DB file. I then used the Wizard again to recreate the Switchboard with the objects already in the DB...

No problem :D

Hi Fidelachius, I created a file that has 2 columns, Column 'A' has various Percentages & Column 'B' has Currency amounts. If you create a similar file & paste the below code into a Macro enabled workbook, you should get what you're after. The code searches Column 'B' for the Max & Min...

Hi madEG, One option would be to record a Macro into your Personal workbook that does all the formatting you need & then add a button to run that code to your quick access toolbar. Then you can open any workbook, worksheet & click the button, run the Macro & there's the formatting done in no...

Hi LadyDi, I did this exercise a while ago, so I've uploaded an Excel & a PPoint file for you to try out. Save both of these files to your Desktop, you'll then need to go into the Excel 'copy_charts_to_ppt' Macro & change the Path to the Powerpoint presentation to your Desktop. This will...

OK, you could record a Macro to help you write your group code. :)

Hi Brian, I would have suggested VLOOKUP but there is > 1 condition in the formula. Such as here - =IF(AND(Dpam!C3="R",Dpam!D3="OR"),"RDO" ... I don't see how VLOOKUP can cope with that but then you've educated me before with your knowledge! :)

Hi MI Man, Are you looking for a count of the managers names per Manager? Is it possible to use a Pivot table like the one attached below? Not exactly sure what you need.

Hi smiler44, To remove the limitation of 7 nested functions in Excel formulas, you might consider VBA instead. Then you can have as many as you like. VBA is going to be a big step if you're learning VLOOKUPs but I suggest you look into some training & have a view to include VBA. To get...

Hi winshent, Yes, sorry you did say you were using 2003 & had that limitation. I tried to replicate what you're doing & had some success. Please note that I'm using Excel & Access 2010 for this so I hope you can maybe replicate what you need in your version. I think your problem is writing...

Hi winshent, I'm not registered on that forum so my answer is going here. I haven't heard or thought of keeping the Pivot Table source data in Access, so my only suggestion would be - Have you considered transferring the Pivot source data to a worksheet in the Excel worksheet & have this as...

I see that this post starts with SOLVED but just in case it isn't solved, you might want to check that the Cell you're pasting into isn't in Text format. Pasting a Formula in a Text cell will display the Formula rather than the result. Hth

Hi mahen, You probably need to show that you've tried to learn this or done a version of your request yourself before you just ask the forum to do it all for you. I'm Just trying to help you with your request as most forum users are actually learning the topic they're asking questions about...

Hi cds5819, As this post was a little while ago, do you still want a response or have you reposted? I'm working on the answer & am about 50% through. I need to know if the 'Record_Id' value will ever be repeated. If so, all info about any rows with the same 'Record_Id' are to be added to...

I have some more info, the below link shows you what to do & where you can find the MSCAL.ocx file. Thinking about it, as I had used this feature some time ago, I had to get the file & everyone who used the database had to also have it so it wasn't useful & I replaced it with the normal date...

Hi Darrell, I think you need to go & select the Calendar from the Excel Reference Library. Go to your Visual Basic code window & at the top select 'Tools' >> 'References' & you'll see the boxes that are checked are available to you. If you look for a Calendar Element & check that box, you...