Reply:

Outlook 2003 Arrange By Bug? #2
We have noticed on machines running Outlook 2003 that when you have a particular e-mail selected and you click on the column heading "From", that instead of sorting by "From" and starting the list on the first message from this sender, the list is sorted by "From" and the top of the list is shown. In other words, it does not position the display as it did in Outlook 2k to the first message from the selected sender. This behavior is not consistent however. It appears that it works the first time you try it, but subsequent attempts don't. If you switch out of...

How to filter a spread sheet ?
Hi, From my financial package periodically Excell sheets are generated with lot of financial information. Unfortanely I cant make a selection from that package, so it generates all the information available. So, my idea was just to filter the spread sheet in order to get the required information. Therefore, on a second file I put a list of required relevant items, I want to extract from my spreadsheet. My question is, is there a simple way to do that ? ---------------------------------------------------------- To make it more concrete, consider the following example: Imagine the spreads...

Junk E-Mail filter unavailable in online mode
We had Outlook 2003 clients on an Exch 2000 server, and, as expected, the Junk E-Mail filter was not available when working in online mode. In cached mode it was working fine. Now, after upgrading the organization and server to Exch 2003, the Junk E-Mail filter is still not available in online mode. According to all the MS documentation this should be working. Any ideas? Thanks kindly, FV All of the documentation that I have know of says that it works on in Cache Mode. Can you give us a link to the documentation that you saw that shows it will work with online profiles? Thanks, -- Matth...

Junkmail filtering outlook 2000
Is there a way to add "key words" to the junk mail filter to eliminate additional junk emails? Is there a download which updates the initial list of junkmail words. On the next junk mail you receive go to tools and Junk Mail filter and add the address. "Andy" <aberg@canarymarketing.com> wrote in message news:08d501c352af$d312b980$a601280a@phx.gbl... > Is there a way to add "key words" to the junk mail filter > to eliminate additional junk emails? Is there a download > which updates the initial list of junkmail words. This does not work because...

help for filtering email needed
Hello, please excuse my bad english first. Our Problem: since weeks we receive email from adresses all over the web - especially from accounts at yahoo, hotmail etc. from peaople who wanted to sell us viagra and other stuff not needed within ou office. Due to the fact, that they wrote viagar lie v*i*a*g*r*a a filter in the clients outlook cannot match. I tried to setup the filterlist within the exchange admin console and entered adresse like '*@yahoo.com' and so on, to reject mail from these adresses. Nevertheless this does not work. We still receive mail from these senders. What did ...

Workflow PostURL error/bug
Is there a way to set the timeout for a PostURL workflow step. We have noticed that if the PostURL takes more than 8-10 seconds to complete, then the workflow step becomes paused in the workflow monitor. We have created the following simple web service that can be used to reproduce the problem. Create a new web service or ASP page and paste the following function to reproduce the problem. your times may vary, but when we pause for 10 seconds then the workflow step becomes paused in the workflow monitor. <WebMethod()> Public Function SendEmail(ByVal accountid As String) As String Try...

ndislwf (NDIS 6.0 Sample Filter Driver) to monitor native wifi adapter
I have built sample Filter Driver (ndislwf) from WDK and trying to install it with INF settings HKR, Ndi,FilterClass,, Custom HKR, Ndi,FilterType,0x00010001,0x00000002 HKR, Ndi\Interfaces,UpperRange,,"noupper" HKR, Ndi\Interfaces,LowerRange,,"nolower" HKR, Ndi\Interfaces, FilterMediaTypes,,"wlan" HKR, Ndi,FilterRunType, 0x00010001, 1 ; In above INF settings FilterClass is specified as "custom", bcoz it'll have the lowest position in the stack. I've also modified FilterAttach to accept bindings with only native-WiFi adapters. With above set...

Refresh on Open
Can i get a worksheet to refresh after a set amount of time or as i opens. or both advice please Cheers Andy i have also posted this on 'also posted here (http://www.ozgrid.com/forum/viewthread.php?tid=7612 ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com Sorted used this link to complete http://www.ozgrid.com/forum/viewthread.php?tid=7612 thank ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and pos...

Advanced Filter Causes Crash
When I try to use an advanced filter on a fairly large list (500+ rows) I get the error message: "EXCEL.exe has genereated problems and will b closed by Windows." I've noticed that the list actually does ge filtered successfully, but excel always crashes immediately after. I have around 100 rows of criteria. ( I have a list of about 70 account numbers in one coloumn and their corresponding GL codes in th next column, and I'm trying to filter only the numbers that I'm payin in a given period (the 100 rows of criteria). I'm running excel 2000 on win 2000. This is ...

Where is the bug in my array?
I've created an array of grade values: {"A+","A","A-","B+","B","B-","C+","C","C-","D+","D","D-","F";4.3,4,3.7,3.3, 3,2.7,2.3,2,1.7,1.3,1,0.7,0.5} The problem is that when use LOOKUP to look for "C-", I get 2.7 (which is the value for B-) when I should get 1.7. (I.e., LOOKUP("C-", Array) returns 2.7, where Array is the array above.) Here is the same array, formatted in rows (all I did was copy and paste it into Notepad and add spaces): ...

Printing only filtered data in a form
Hi all- I'm of new to Access 2007. I have created a form and a report. Is it possible to have the user use the built in filter Access provides and click the report button and print only that data. Each time I open the form different data will need to be selected by the user. For a simple filter, you can just use the form's Filter string as the WhereCondition for OpenReport. This example assumes a command button named cmdPreview, that is to open Report1 filtered the same way as the form: Private Sub cmdPreview_Click() Dim strWhere As String If Me.Dirty The...

Bug part of rounding issues?
Paste any of the following into a cell and the last digit gets changed to a zero. This is screwing up our call detail records that contain international numbers dialed by customers. 9011390292608271 9011390292608272 9011390292608273 9011390292608274 9011390292608275 9011390292608276 9011390292608277 9011390292608278 9011390292608279 If I format the cell as text, Excel changes the contents to 9.01139E+15 no matter how wide the column is. Is ther any way to make Excel just display the numbers as entered? Thanks Not a bug - see "Specifications" in XL Help: XL only retains 15 ...

Filtering on multiple columns
I have similar data in multiple columns and I want to filter on all columsn togather to get unique values. Is there a good way to do so. -- wammer ------------------------------------------------------------------------ wammer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=12452 View this thread: http://www.excelforum.com/showthread.php?threadid=399224 I'd create a new worksheet and copy all the data into one column. Then I'd use data|filter|Advanced filter to extract just the unique records. Debra Dalgleish explains the data|filter|advanced filt...

Dynamic filters on a report
Hi, What I am trying to acieve is an on-screen report with user-selectable filters. The app is a detention-logging system for a school. What I want to be able to do is to see a summary of all of the detentions for the school, but allow the user to filter this down to either a particular year group or even a particular tutor group. I also want them to be able to alter the date-range for the report. What I'd ideally like to do is to have a form do this, but forms don't seem to support grouping of data and I can't have a sub-form on a continuous form. I have two (current) pro...

Filtering all incoming mail for a particular sender or senders.
I work in a bank, we have had several people with non-compete agreements leave recently and they appear to be violating their non-compete agreements, contacting existing employees to try and hire them. I would like to setup a filter in Exchange so that when an e-mail comes in from 'exemployee@mynewemail.com' comes in, it gets routed to a different internal e-mail box, and is never delivered to the intended recipient. Is this possible to setup somewhere in Exchange 2003? You can't selectively route inbound email from particular address(es) to a particular internal recipient ...

misc data filter
Item Activity Time ABC IN 100 DEF OUT 110 ABC OUT 120 DEF IN 130 IN & OUT are pairs, if one item is IN, it must be OUT. I am looking for a way to find items which are IN but no OUT. In this example data, "DEF" was OUT and IN again, then I need to locate that DEF. For a case of "ABC", it is already out, then I am not interested. I have tried this with pivot table but in vain. I would appreciate much if somebody can find a solution for this. thankyou. Soe, With your table in A:C starting in row 1, enter this array formula in...

Is it possible to change the blue colour of an activated Auto Filter button?
When Auto Filtering is on and one of the filters is active, the button's colour is changed to blue. Often, I find it difficult to distinct this blue colour with the black colour of an inactive filter. Can the colour of this blue Auto Filter button be changed? -- Message posted via http://www.officekb.com AFAIK, no one has found a way to change the autofilter arrow colour. If you can use programming, there's a sample file that uses a User Defined Function and conditional formatting to colour the heading cells: http://www.contextures.com/excelfiles.html under the heading '...

need query to filter combobox row source list by table records
Hi All, I hope my subject line made sense. I'd like to specify a list for the rowsource of a combobox, but I want the list to omit items that have already been used in a the underlying table. The values ID phone numbers, and are "Home", "Work 1", "Work 2", "Fax", "Mobile", and Pager". The underlying table has a record for each existing number with the person's ID code, the label, and the phone number. When new numbers are added, the user gets one of the listed labels from a combobox. I want it to display only o...

Outlopk do not refresh(2) ?
Hi All, My situation is Server 2003, Exchange 2003, Windows 2000 Pro, Office 2000. All patches are current. Most machines are identical. All machines with XP Pro will show that you have e-mail immeadiatly, BUT Windows 2000 Pro will not show new e-mail unless you click on another folder, or on "Jog" outlook. I know exchange is getting the messages and making them available because I see them come in via the web access. This is a client problem, as a user can go to a different machine, and not have a problem. It's like Outlook is sleeping, and we do not have it set in cach ...

Adding Filtering to a Rating Equation?
I am using the following formula to determine the individual rating of a group of players running a race. F3=CEILING((COUNT($A$3:$A$23)+1-RANK(E3,$E$3:$E$23,1))/(COUNT($A$3:$A$23)/5),1) A B C D E F G H 2 ID. No. Time #1 Time #2 Time #3 Average Time Rating Gender Level 3 6 01:01.1 02:59.6 01:59.9 02:00.2 5 Male U14 4 5 03:00.0 01:01.1 02:24.7 02:08.6 5 Male U14 5 16 03:02.8 02:47.7 01:01.1 02:17.2 5 Male U14 6 4 02:24.7 01:59.9 02:32.6 02:19.1 5 Male U14 7 17 02:25.2 02:11.3 02:47.4 02:28.0 4 Male U14 8 19 02:15.6 02:21.2 02:47.7 02:28.2 4 Male U14 9 11 01:59.9 02:25.8 03:01.9 ...

Data Refresh Speed
I have a spreadsheet that extracts data from Sharepoint and then performs multiple calculations on that data. When I refresh the data, it then also recalculates every formula and this is starting to take a long time due to the sheer number of calculations that are being performed. I'm wondering if there is anything I can do to speed up the processing, like multi-threading or something? Any settings or options I can change to make this faster? See my website http://www.decisionmodels.com/ and white paper http://msdn.microsoft.com/en-us/library/aa730921.aspx Charles _________...

F9 Calc refresh does not work...
I have a spreadsheet which has some formulas which do not refresh properly. They are simple "IF" formulas. If I press F9 or Options / Calculate Now, they do not refresh. They only way I can get them to work is F2 when I'm on the cell (revealing the formula in the Formula Line) and when it closes it refreshes. I have this formula in other sheets in the same spreadsheet but I don't have this problem. Any ideas? Thanks (and happy new year to all!) <They are simple "IF" formulas> Why not show the formulas? Sometimes it helps to rebu...

SPAM FILTER
Hello, Can anyone recommended a spam filtering product to use on Exhchange 5.5? We send and receive via a SMTP ISP. Thanks. We use Appriver.com. Excellent service. They block spam and virus's. Free 30 trial will sell itself. -- Randy - [You can observe a lot by just watching] "Pete C" <pcwfc@hotmail.com> wrote in message news:%23qGkXmt%23DHA.2800@tk2msftngp13.phx.gbl... > Hello, > > Can anyone recommended a spam filtering product to use on Exhchange 5.5? We > send and receive via a SMTP ISP. > > Thanks. > > We use Hexamail Guard from Hex...

Filter Problem after Upsizing DB to SQL 2000
We have an Access 2000 application which we recently upsized to use SQL Server ... Everything seems fine except when we try to use the "Apply Filter Using Selection" button on a DATE field ... Doing so results in no filter being applied on most computers (we do have one that works correctly and the only difference we can find is that the one that works is running WindowsXP Pro, while all the rest are running Windows2000 Pro) ... Anyone have any ideas or suggestions? Thanks ... ...

refresh static text overwriting old values -- Graphical problem
Please... I really need help with this problem. I have been stuck on this for a long time and my software deadline is almost here. I have a tiled bitmap as a background on my app. Problem is when I update static text over top of it, the text will just sit there and overwrite itself over and over again until it is unreadable. It will refresh if I use an Invalidate(TRUE) but I have to do it every second and the window will flicker badly. The text is transparent so I can see the bitmap from behind show through. I have tried everything I know to make it work correctly. Does anyone know...