ADVANCE FILTER SORT WINDOW

Hi! Could anyone please help me?  I have this continuous form called 
"frm_Status01" with a button that has this code "DoCmd.RunCommand 
acCmdAdvancedFilterSort" to open the advance filter sort window.  After I 
have completed selecting all the fields I wanted, key in all the cretirea, 
sort, etc then click the apply filter button shown at the advance filter sort 
window and my "frm_Status01" is already displayed and active.   The advance 
filter sort window didn't close after I applied the filter.  Is there any way 
to close it immediately after I applied the filter?  Appreciate very much for 
your help.
0
Utf
3/22/2008 1:01:01 PM
access 16762 articles. 3 followers. Follow

0 Replies
1145 Views

Similar Articles

[PageSpeed] 24

Reply:

Similar Artilces:

sort order for payroll checks
This is a suggestion for MBS - it would be nice to have a setting where the user can select the Default Sort Order for Payroll checks so we don't have to change it every time we print checks. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com...

for some reason when i deploy my C# application on windows 2003 occasionaly rdr[0].ToString() hangs where rdr is a System.Data.SqlClient.SqlDataReader. Is there a fix for this? is my visual studio.net
for some reason when i deploy my C# application on windows 2003 occasionaly rdr[0].ToString() hangs where rdr is a System.Data.SqlClient.SqlDataReader. Is there a fix for this? is my visual studio.net out dated? Hi, 1. Does this seem to you to be the right Newsgroup to ask this question ? I would have suggested "microsoft.public.dotnet.framework.adonet". 2. Is there supposed to be a difference between the Message Subject and the Message body ? Isn't the Message Subject supposed to be abbreviated ? 3. As for your question : I strongly doubt if your VS.NET can be called "o...

Outgoing message filtering
Is that possible? How? HaTeTeP I ment, is there a way to restrict one user from sending emails outside the organization. We have a situation with one man who is planing to start working for a company dooing same bussines we are. So i have to find a way to block his outgoing messages. HaTeTeP Well, you could try firing him. :-) On another approach, you could create an SMTP Connector and set the delivery restrictions so that he can't use it. See this KB if you do this, though: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q277872 -- Jim McBee - MostlyExchange Blog: ...

Filtering between two columns
I have to columns that I want to try and filter out at the same time. Not really sure if this is possible. example Column 1 Column 2 770/005 K01001 770/005 K01002 770/005 K01003 770/006 W01001 770/006 K01004 770/007 Z01001 770/007 W01002 What I want to do is pull all of the column 1's that have only K values, then pull column 1's that have mixed k,w values and finally column 1's with mixed w,z values. I have tried to think off an IIF statement but couldn't quite get my head around it. I ca...

Advanced Search in Outlook...
Hi, when we try to search for mail with the "From" field, we must put the exact expression to find something. For example, if we search for mathew@sfr.fr with only "sfr.fr" it doesn't return anything, therefore, if we search with mathew@sfr.fr, it works. Any idea ? a little more about that issue : it appears when the outlook mode isn't set to "Exchange cache mode" If we set to it, the search works... "Ludovic" <ludo@nopsam.fr> a �crit dans le message de news: 41e3d9d6$0$5731$626a14ce@news.free.fr... > Hi, when we try to search ...

Sort months in calendar order
From my Invoices table, I have a query that groups our charges together by month and then shows each month with its respective total revenue. I use this query as the record source for a report, but the months are listed in the Detail section in alphabetical order rather than calendar order i.e. December November October Whereas of course I want to see October November December (Interestingly, the chart that I have placed in the report does show the months in correct calendar order). Thanks for your advice! CW It would help if you provided use with something about your fields and...

Unable to Sort Multiple Columns
Good day all! I've seen this posted in a million other places, but I wasn't able to get my question fully answered. I'm creating a simple sheet to list common TCP/IP service names and their appropriate port numbers. The first column is a description of the service name (which is 4 cells wide) and then I have two sets of 2 merged cells which contain the UDP & TCP port ranges respectively. I want to sort the entire list by the TCP port numbers, but can't because Excel says that the "merged cells must be identically sized." Everyone's solution to this proble...

Filtering out information
Just wondering if there is any way of applying a filter to remove certain segments. E.g. filter out everyone called Jones in a list so that all other names are left on the sheet except Jones Thanx in advance, Cat You can do this with an AutoFilter Select a cell in the list Choose Data>Filter>AutoFilter From the dropdown in the Names column heading, choose 'Custom' In the Custom AutoFilter dialog box, from the first dropdown, choose 'does not contain' In the text box, type: Jones Click OK Cat wrote: > Just wondering if there is any way of applying a filter...

Exchange 2003 word filters
Is there a way to filter the content coming into exchange before it gets to the end user? We'd like to block all the email with viagra in it for example. ...

Sorting Cells with Conditional Formats 04-27-10
Is it possible to sort a spreadsheet containing conditional formats without destroying the formats? DOUG ECKERT 27 Apr 10 Yes, as long as the Sort doesn't change the value of the "condition". DOUG wrote: > Is it possible to sort a spreadsheet containing conditional formats without > destroying the formats? > > DOUG ECKERT > 27 Apr 10 Cell borders and CF conditions do not move with sorted cell values. Forcing the CF conditions and borders to move with the cell values can be done using VBA code. However, if the CF conditions depend on the ro...

How to change .Filter or .FilterOn
On a form is a number of command buttons and a subform. I would like to use the 'on click' event of a button to change the filter of the subform and to get different lists of people. All my filters work and are stored in respective queries. How do I write an event procedure on the click event to change the Filter and update the subform ? Thank you for the help. -- eric Try; Me.FilterOn = True Me.Requery Steve santus@penn.com "ericb" <eric@b.com> wrote in message news:949B1BDB-0228-44D6-9D30-BFAD22321B20@microsoft.com... > On a for...

sorting date " MMM-YY" (Jan-05)
Hi, I have a spreadsheets with ticket numbers and the date it was submitted. It is in medium date format (3/18/2005). I have used this formula: =text(A2,"MMM-YY") to conver it to Mar-05. now i have a column with MMMYYY date, however, it will not let me sort it. It is sorting alphabetically, and not in the order of the date. so I have Feb-04,Feb-05, Jan-04,Jan-05 and so on. How can I sort this by month then year? Thank you! It is sorting alphabetically because the data is in TEXT format. In order to sort by date, you'll need to have the data formatted in some kind o...

Windows address book
I use a Canon printer/fax. If I use a program to "print to fax" it opens a window that looks like this: http://i47.tinypic.com/w21xs1.jpg and when I select add to address book it opens this window: http://i49.tinypic.com/123mvlk.jpg This is not what is listed when I run wab.exe from my outlook folder but I can't find another file that has wab. The problem is that the Canon version will not let me do anything except add a number to the address book. I can not edit any of the entries. When I change to outlook express folder and run wab.exe the directory is differen...

exclamation mark
Hello I received an email with a red exclamation mark ! in the 1st column. I assume the sender put it there to draw attention to it ? Can I delete it ? I assume I can set a ! in my reply ? Thanks KK KRK wrote: > Hello > > I received an email with a red exclamation mark ! in the 1st column. I > assume the sender put it there to draw attention to it ? Yep. > Can I delete it ? You can delete the email but not the exclamation mark. > I assume I can set a ! in my reply ? Yep. > Thanks > > KK You're welcome. Al...

Outlook causing programs to not respond in Windows 7
Ever since I got Windows 7 I have been looking for a way to stop Outlook 2003 from interfering with the rest of my work. When I boot up, Outlook is started as a process by Sync Center so that it can synchronize my mobile device. Until now, the only problem that this had caused was the fact that this allowed Outlook to keep giving me Reminder dialogs. That was annoying, but at least I was able to close them when they popped up. But over the past couple days I started spending some more time using Visual Studio 2008 again, and it has said Not Responding in the title bar 2 or 3 time...

windows mail crashes when signature is inserted into emails
Whenever I write an email and try to insert my signature before sending, WindowsMail crashes and closes, and I get the following error message: "Windows Mail could not be started. The application was unable to open the Windows Mail message store..... Close the program or wait for it to complete its operation, then open Windows Mail again. (0x800C0155)" I tried creating a signature and asking it to "always insert" the signature, but whenever I tried to create a new signature, it crashed as well. We ran the wmutility program yesterday and still no success. ...

Using Intelligent Message Filtering
How can I set up some domains or emails that must not to block by IMF? SCL rating => 8. For example, I need receive all messages from newsletter@somedomain.com. I'll try to set Global Settings-Message Delivery-Connection Filtering-Exception add newsletter@news.somedomain.com (or *@*.somedomain.com ), but this has no effect: messages from newsletter@somedomain.com move to Archive folder anyway. Additionally, Connection Filtering used (masks 127.0.0.3, ...5, ...7, ...9). Plz, help me! I'm really need this feature. ...

Strange Characters in the Accounts List Window
Hello: A client of ours is on Great Plains 8.0 with service pack 1a. He likes to make use of the "Accounts" window from the Financial Lists section of the Navigation Pane. Intermittently--certainly not all of the time--he will click on this list and some of the account descriptions will be "fuzzy" or, at best, the characters are just plain strange looking. The only thing that is different about the client's GP app is that I used Modifier to increase the width of the Account number column in the chart of accounts lookup window. I had to do this because the clie...

Find/Filter multiple non unique list
I'm trying to figure out the quickest way to search a column for a lis of values and the answer may not always be exact. For example, within a column, I want to find if there are any of a lis companies (ABC, IBM, Sears, XYZ, etc.). Those companies may be liste there, but not exact. For example, there may be ABC Inc. or AB Corporation. This is a routine search that is needed to be done. When I use vlookup, I can only do exact matches. Any ideas on how t do this quickly? It would save a lot of people a lot of time. Thank you for any help -- Message posted from http://www.ExcelForum...

Launch new browser window from an excel web page
I am publishing an excel file to the web using the Excel Publishing feature - works great (I am not a programmer). However, I have links within the spreadsheet that I'd like to open a NEW browser window when the link is selected from the published Excel browser window... Make sense? In other words, when a link is selected from the published Excel browser window, I don't want it to replace the Excel browser window, but open a new window. Is there a command I can append to the URL in the Excel field (or some other approach) so that a new browser window will open when the link is ...

Windows Live Mail Problem Running In XP and No MVP Response
Hello - I have a Problem with WLM on XP Service Pack 3 Situation : Calendar - Custom Recurrence - Every Second Thursday Problem : Calendar shows succeeding months' recurrence occurring on the Wednesday instead of the Thursday. Tried the same situation on WLM running in Vista, and the calendar shows Thursday as it should. It has been suggested that this is a result of XP First Day of Week settings - but this does not appear to be valid. Is there a problem with Windows Live Mail and XP. I am a volunteer teacher (retired programmer) teaching older people in Rockhampton to ...

sorting multiple columns
I have multiple addresses on a work sheet. I need to have all the same zip code # together. How do I sort them by zip code so right name and address ends up with right zip code Highlight the range you want to sort before starting it. Regards, Fred "arbe" <arbe@discussions.microsoft.com> wrote in message news:56FFD696-D31F-4A99-AE8E-941C5C18D012@microsoft.com... >I have multiple addresses on a work sheet. I need to have all the same zip > code # together. How do I sort them by zip code so right name and address > ends up with right zip code Pre-se...

Novice trying to sort the values on a radar graph
Hi, I need the values on a radar grapgh to show as 0, 3, 6, and 9 as the outside of the 'web'. However the values in my data only go up to 5, how can I make the graph show up to 9 and only show the 3 radiating lines I want i.e. 3, 6, & 9? really new to this, so feel free to treat like an idiot! Good question. Here's what you do: * Slide the cursor over the rib of the radar graph until you see a little box open up saying "format axis". * Right-click on the axis. * A little dialog box opens up, and you should click the 'format axis' option. * A bigge...

Outlook 2007 crashes when BCM open in separate window #2
My client recently upgraded from Outlook/BCM 2003 to 2007. She likes to have her Outlook calendar, tasks and BCM running in separate windows. If she closes the calendar or tasks window while a window running BCM is open, Outlook crashes. All is well if the BCM window is closed first. Oddly, I discovered that the problem does not occur when the PC is not connected to the network. She does not have any third- party add ins installed. I ran Outlook repair and the Inbox Repair utility on her .pst file, but the problem persists. Has anyone else encountered this issue? If so, have you found a way to...

How do I use the autofilter to sort a list
How do I use the autofilter to sort a list You don't. Autofilter is used to filter a list. Data - Sort is used to sort a list. HTH Otto "cookie" <cookie@discussions.microsoft.com> wrote in message news:5A04C6E7-C110-4260-8EC2-05DDE94D0BEF@microsoft.com... > How do I use the autofilter to sort a list Depends on the version of excel you're using. If you apply the data|filter|autofilter to the list, do you see "Sort ascending" and "sort descending" at the top of the list when you use the arrow in the header? cookie wrote: > > How ...