How do I get an item's rank?
Let's say I have 10 merchants selling the same product at different prices.
How do I get a vendor's ranking?
I'd be passing the stored procedure ProductID and VendorID. And the data
comes from a table with three columns ProductID, VendorID, Price where the
Price field is smallmoney.
With RankedVendors As
(Select ProductID, VendorID, Price,
Row_Number() Over (Order By Price) As Rank
Where ProductID = <product you are looking for>)
Select ProductID, VendorID, Price, Rank
...How do I delete a text box from an Excel spreadsheet?
Rightclick on it and select cut
If the textbox is from the control toolbox toolbar, you may have to click on the
designmode icon first.
Uncle Binky wrote:
...Why does workbook think deleted macro still exits?
I have deleted the macros in a workbook but each time I open it there is
still a messge stating there are macros. How do I stop the message from
...Public Folders have disappeared
Unfortunately I have created a problem for myself. I was modifying the
permissions for the public folders as follows:
1. Navigated to Administrative Groups > First Administrative Group > Folders;
2. Right-clicked on the Public Folder Tree and selected Properties;
3. Selected the Security tab;
4. Removed all groups from the security listing (excluding administrator),
thinking this would stop users seeing the folders in Outlook;
5. Restarted the server;
6. Encountered the following problem:
I now find that the public folders have disappeared from the Exchange system
manager. However, ...show header
this is such an obvious one but I can't find it -- how do
you get the headers to show while you're viewing the page
on the screen? Print preview works fine, but I need to
have the headers show up when looking at it as a
spreadsheet. Looked for "Print View" equivalent, but can't
You can't display the header or footer unless you use print
preview. Excel doesn't have a Print View mode like Word does.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"jchoy" <firstname.lastname@example.org...my case it online , it Show offline
When I open Messenger and put my case it online , it Show offline to
my friends .. not online .. What to do!
What I did was sign in on that website as well as the regular windows live (if you have the newest windows live you can sign on in two places). So everyone could see me as online again, and I could use windows live as I normally do with the web messenger running in the background. I hope we get a solution soon.
my case it online , it Show offline
When I open Messenger and put my case it online , i...SMTP and Sent Items
I am confused in the following matter and want to get some opinion...
Current our office have a Exchange 2003 SP2 server running and clients are
running a mix of Outlook 2000 and Outlook 2003 on SMTP (and some on X.400 as
well). When users from X.400 sends email from outlook client, the items do
appear on their Exchange Mail box sent items (this is obvious), but when SMTP
users sends their email, the email does not behave the same way.
Here are the questions I have?
1. Is this normal? By that I mean I believed that both should have a copy in
their exchange mail box, but doesn&...How do I alpha my mailing list in Microsoft excel and delete names
To alphabetize -- use sort
Sorting, Some notes on sorting in Excel
To delete rows
pick a range of rows by selecting one or more contiguous
row number(s) then Edit, Delete rows
You might also be interested in Filtering to expose only names in Ohio
You can use Filtering to permanently delete rows or just hide them.
you can read more about filtering at
If you want to print labels for your mailing list, you do the printing in MS Word
with Excel acting as your data bas...Net Worth Report: Investment Account cash compenent as a separate line item
Is there a way to get MS Money to combine the cash account associated with
an Investment account with the investment account. For investment accounts,
2 lines are unnecessarily reported in the Networth report such as below. I
want only one amount reported.
Account Name X $x
Account Name X (cash) $Y
Using Money 2004.
Probably not. Money really does think these are two accounts. You could
always copy the report to Excel where you could make it say anything you
"Bill Toupee" <email@example.com> wrote in message
news:hmnXf.210000$H%4.1...can't delete mailbox #2
I deleted a user account in AD but when I go to Exchange system manager I
can't delete the mailbox. What is the deal?
Wait until AD replicates then you'll be able to purge the mailboxes with the
"Brandon Baker" <firstname.lastname@example.org> wrote in message
>I deleted a user account in AD but when I go to Exchange system manager I
>can't delete the mailbox. What is the deal?
Right click on Mailboxes in ESM and select Run Cleanup Agent.
John Oliver, Jr
MCSE, MCT, CCNA
Exchange M...Storage Folder 04-05-10
How do I unhide / create the storage folders? I have this folder on
another computer that imported everything from Outlook Express it apparently
was created automatically. I thought by using alt v that I could unhide the
"storage folders" but could not find it.
...How to recursively clear all the filters applied to a folder
In Outlook 2002 I would like to recursively clear all applied filters. I
remember applying a filter to a folder but it seems Outlook applied the
filters to all folders. Now the only solution I found to clear all filters
is to clear them one by one by selecting View > Current View > Customize...
> Filter... > Clear All. Isn't there a clear all feature for all views ?
You could reset all views to their defaults and delete all custom views =
by starting Outlook with the /cleanviews switch. But there's no magic =
method for keeping all view settings except the f...Obtaining Path of the file/folder ?
I have an mfc dialog based demo application.
I wanted to add my application's entry in the Windows Explorer's
context menu, which i m able to successfully by making some additions
to the registry.
Now whenever the user right clicks on some folder/file,the context menu
displays my application's entry which gets executed when the user
clicks on it.
How can i obtain the path of the file/folder on which the user
right clicked ?
Waiting for suggestions
>I have an mfc dialog based demo application.
>I wanted to add my application's entry in the Windows Expl...Folder Context menu in Outlook
I have develop an Outlook COM Add-in with C#.
This add-in use the Outlook Object Model and add a new menu in the Folder
Context Menu command bar.
The problem is when the current folder is for example "Inbox", and I click
right on another folder, for example "MyFolder",
I'm not able to retrieve the MAPIFolder of "MyFolder".
Anybody have an idea?
...Purchasing Non Inventory Items
I need to know if anybody knows of a 3rd party provider that has built an
add-on for Great Plains where you actually issue a receipt for non inventory
items on a purchase order.
We cannot just rely on using auto-invoice and throwing the PO in a batch to
be posted. There has to be some acknowledgement that payables can see so
when they get the invoice they know we have received the item.
We are running GP 8.0 and very soon will be upgrading to 9.0
The Purchase Order module does allow you to create a receiving transaction
for a non-inventoried item. If you don't want payables to re...Unread search folder unavailable
Could anybody help tell me why in Outlook 2007 on a Windows 7 machine
I get the following error "The Operation Failed. An object could not
be found." when clicking on the Unread Mail search folder and also why
it is greyed out? This also happens for the Large Mail folder, but
NOT the Categorized mail and For Follow-up Folders.
Can you create a new search folder with the same functions?
See if this helps: http://www.officeforlawyers.com/outlook/sf.html
Ben M. Schorr, MVP
Roland Schorr & Tower
http://...Money 2007 add/delete Category
Is there a way to maintain my categories by viewing a list so easily
add/delete categories? The Category maintenance in 2007 sucks.. I need to
run through every single category just to delete one.
Deluxe or Essential? If Deluxe, use the Account List More pull out,
Categories & :Payees|Categories should show you all the categories at once
and allow you to Move, Modify or Delete them as required. The pulldown at
the top lets you see just Categories or Categories and Subcategories.
"Vital" <Vital@discussions.microsoft.com> wrote in message
news:4D4AAA91-6602-429E-915...Discussion folders view
I can access an outlook folder at another school which has
a "discussion" format. The current view for that folder
is "TF Messages by Conversation"; several other TF Message
views are also available for that folder.
These views are not available for folders that I set up
for my school. How do I make them available, or select
them for my folders?
Any help appreciated.
...Create Outlook Folders on external drive
How can I create an Outlook Folder (.pst) on another hard drive leter.
I want to free up hard drive space without removing emails. I can see
how to archive to an external drive, but I want an active, accessible
folder on an external drive and have it show up in the Personal Folders
list in Outlook. I want to be able to move email from the Inbox to
folders on the external drive and be able to view them "realtime" from
that folder or folders. At work the IT guys do it on a network drive.
We can read or move email to and from folders on the network drive. I
want to do that wi...Public Folder Replication of pdf Freedocs
We just upgraded on of our servers to Exchange 2003 and now pdf Freedocs
will no longer replicate from a Exchange 2000 server (through Public
Folders). Anyone run into this problem? All other freedocs we've tried
(doc,xls, etc) have worked just fine.
Windows 2000 SP4 plus all patches
Exchange 2003 SP1
When I try to delete any number of rows or columns from a worksheet,
by using the Edit/Delete command, the MS trouble dialogue/report box
comes up and Excel shuts down.
The funny thing is that it only happens to one particular worksheet
(out of 7) in the workbook and no other warnings come up.
Can someone explain this, please?
sounds like some kind of coruption to the sheet. what it
is, i can't say.
copy the problem sheet and paste it into a blank workbook.
try the delete again. if it works i would go back and
delete the sheet in the problem workbook and r...Folders #3
What is the Bulk mail folder for ... ?
Thanks in Adv ...
On Thu, 15 Jan 2004 18:55:51 -0800, "ATL"
>What is the Bulk mail folder for ... ?
Bulk mail (spam)
Chicago, Illinois, USA
Email Client: Microsoft Outlook 2002
News Client (Text): Fort� Agent 1.93 www.forteinc.com
News Client (Binaries): News Rover 9.1.2 www.newsrover.com
...outlook 2003 folders cannot be opened server not available
i haved had office 2003 for a 2 weeks and suddenly it
come up with a error " cannot start microsoft office
outlook. unable to open the outlook window. The set of
folders could not be opened. The server is not available.
Contant your administrator if thi condition persists"
Can anybody plese help. I have tried to repair it and
Under Control Panel->Mail Icon, what type of mail account(s) do you have
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my personal ac...How 2 sort an autosum total list after adding items 2 autosum item
Am using detail dollar amount list to insert new transactions in the middle
of a the detail list, and they in turn get included in the 'autosum' total
calc which is located in another item total summary list in the same workbook.
If we try to sort the autosum total summary list, the autosum totals seem to
loose their connection with the detail autosum calc list.
Is there anyway to keep this connection, ie be able to add items into the
detail autosum calc lists, and then sort the autosum summary totals ?
Thanks again for your help.
akm (XPpro,SP-2,IE-7,Office2003...How to keep the application even when show desktop is selected
I am developing an application which is a sort of reminder of your daily
tasks. I want this application to remain on the top right corner of desktop
even when "show desktop" is selected. However it gets minimised.........Any
Perhaps you want to consider "Active Channel Technology" and making your
display part of the "Active Desktop"?
In article <D580FA88-9C89-4D3F-AB9A-8374A9DE266B@microsoft.com>,
> I am developing an application which is a sort of reminder of your dail...