Search results for query: *

What are you using this connection for? Pivottable, Table? If you refresh that object, what result do you get?

Hello: Here is my problem: I have a pivot table that I want to be able to search for a specific value. The problem is my code takes a long time. Is there any way this can be coded so that it run faster. Here is the code that I have: Sub UniqueItem() 'This routine, uniqueItem, selects the name...

Thanks all of you. I used Skip's solution. Yes, I can use the autosum but I wanted to see the sum as I change my autofilter "entries." Once again, thanks a lot. Moses

I need a formular that sums up the autofilter results. Can this be done using a formula or I need a macro or both?' I any ideas? I am running Office XP. Thanks... Moses

Thanks Zathras. I tried it but I couldn't get it to work. I will try it again. In any case, thanks a lot. You deserve a start, so I gave you one. :) Moses

I have a solution to this one but I want to know if there is a better solution: I have a spreadsheet with this format: Codes Amount 1004 10 1005 20 1005 30 1006 10 1006 15 1008 15 1009 20 As you can see the are duplicates. In onther sheet, I have a series of codes like...

Neenas19: Thanks I just figure out how. To calculate the months, I just need to subtract 12*the number of years from =datedif(a2,b2,"m"). Thanks for your input though. moses

I have user who wants to calculate the number of years and months someone has been employed. This is what I had in mind. we would have a col with Hire Date, Today's and two more columns, one for years and one for months. TO find years, I used this formular: datedif(a2,b2,"Y") and it...

Thanks a lot. That seemed to have worked for my customer. You deserve a star so I gave you one. God bless. Moses

Hello: I have a user who has a form and he wants to be able to search is databse by last name. Let's say he wants to find mmsenda. What he wants is, when he types in mmsenda, the record will come up and not changing the value of this field. Any ideas? Thanks Moses

Never mind... This is a bug that't not going to be fixed for r5. It is addressed in r6 though. The reason is because r5 uses frameset which is hard coded. Thanks anyway. Moses

Hello: I have a use who wants to set defaults in R5. He wants to set the way his preview window looks and the width of the section that has his folders. Any ideas? Thanks in advance for your assistance. Moses

Hello: I have a user who is being asked to save Book1.xls when he tries to copy and paste an Excel object in Word. He opens up an file, by going to File --> Open --> select the file that he wants. In this file, he selects a number of cells and copy them. Opens Word, then go to Edit -->...

Hello: I have a database that has two tables, one tblCurrent and the other tblPrevious. Each of these tables has 10 identical fields. What I need to do is to check if there is anything that has changed from the previous table. So, I need a query that will display a datasheet of those fields...

Nevermind... I figure it out. Just in case you are wondering how, here is how. Create a template and name it book.xlt and save it inthe XLStart Folder. That should take care it. Thanks anyway. Moses

Hello: My question is, is there a way of changing or editing the default workbook in Excel 2002. This would be the same thing like editing normal.dot in Word. Any ideas? Moses

ladyCK3: If the total in F7 is 20 and F8 is 20, then in G7 for example, type in this formula: =IF(ISNUMBER(G6),G6,0)+F7 and then copy the formula down. The result will look like this: Row F G 7 20 20 8 20 40 9 30 70 I hope this helps. Moses.

I have a query that the following fields: Name Call Date ---- --------- mmsenda 2/28/02 mmsenda 5/3/02 mmsenda 6/05/02 john 6/05/02 john 7/05/02 mmsenda 8/05/03 When I create a report and group by name, it prints like this: mmsenda 2/28/02 5/3/02 6/05/02 8/05/03 John 6/05/02 7/05/02 Is...

When you deleted the rule, did you delete if from the client side or server side? Here is what you can try: 1. Try to disable all the rules from the client side. 2. If this fails, delete the user's account, reboot and recreate it. This, however, will delete all the custom settings that the...

Are you using mail merge to create these lables or you are using the Envelopes and Lables . And what size lables are you trying to create? mosmas