Where's the Sort by New Message option?
Not sure when the layout of the newsgroups changed but I can't seem to find the ability to sort by new message in a thread instead of sorting by just the original thread date.
That was hugely helpful as I could follow along and see what threads were still active.
If you're gonna hang around in the newsgroups (any newsgroups), you may want to
start using a newsreader.
Microsoft Outlook Express can do it for you.
Saved from a previous post:
You may want to connect to the ms newsserver directly:
If you have Outlook Express installed, try clicking on these links (or copy and
paste i...How to sort account list?
I'm using MS Money 2004 Small Business. In the account list, my accounts
are catagorized by and in this order:
- bank accounts
- credit accounts
- investment accounts
- loans and liabilities
- asset accounts
In the above view, I cannot easily determine totals for assets and
liabilities. The following view does this.
- bank accounts
- investment accounts
- asset accounts
-loans and liabilities
How do I get the above view?
I don't use Small Business. But you can run a Net Worth report to get total
assets and ...Sorting
is it possible to use variable for sorting?
declare @sort varchar(10)
SET @sort='column1 DESC'
SELECT ROW_NUMBER() OVER (ORDER BY @sort)AS rowId, * FROM table
Is dynamic SQL only option?
On 15/04/2010 11:28, simon wrote:
> is it possible to use variable for sorting?
> Something like:
> declare @sort varchar(10)
> SET @sort='column1 DESC'
> SELECT ROW_NUMBER() OVER (ORDER BY @sort)AS rowId, * FROM table
> Is dynamic SQL only option?
You can use CASE to he...Add horizontal line to a chart
How can I add a horizontal line for my chart?
I did choose the XY value, paste to my chart but what I see is just a dash ?
I should have a line from x min to x max ?
Any ideas of this? Do I have to add trend line?
Are the X values of the added line consistent with those of the original
data? What is the original data like, and what is your added series' data
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Daniel" <Daniel@discussions.microsoft.com> wr...Row names will not move with sort
Each row in my summary table in Sheet1 is hyperlinked to a corresponding table in Sheet2 with additional details.
I need to move the rows in my summary table (Sheet1) and preserve the links to and from the details tables (Sheet2).
I found that I can move rows in Sheet1 with cut & insert and the hyperlinks are maintained. I can travel from a row in summary table (Sheet1) to details table (Sheet2) and back, even after the corresponding row (Sheet1) was moved.
But if I sort the rows in Sheet1 the links from Sheet2 back to corresponding rows in Sheet1 lead to presorted locations. Apparen...To Generate 500 almost identical VBA Lines?
I have to create 500 lines of almost identical VBA code. Code is
and so on untill
Range("y500").GoalSeek Goal:=ActiveSheet.Range("z500").Valu...Outlook 2000 (SP3) slow to start, close and display emails
I have a client that has Outlook 2000 with Office SP3 recently added.
Some time ago, after receiving a mountain of spam one day, her Outlook
slowed to a crawl. It is very slow starting up, up to a minute, slow
closing, up to about 30 seconds or so, slow opening emails about 30
seconds, and if you close an email, it often looks like it's closing,
but will just return to an active state where it can be closed for
"real" the next time.
I have tried removing the virus scanner, dumping cache, compacting
folders, fresh install. After I re-installed the video driver, Outlook
...sorts not sorting
OK- Thanks to everyones help I now i have a list i can work with... but
there are a few problems.... the zips are all 5 digit and now i have to
sort them... the problem is, THEY WONT SORT CORRECTLY!!!!!!! The
numbers are not in order... some are but a lot are not... is there
anyway to fix this???? i need to sort them by zip code but cant seem to
get them to do it correctly.. any ideas???
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
You are going to be far better of...The Microsoft Exchange Routing Engine Service failed to start
I have an issue here;
The Microsoft Exchange Routing Engine Service failed to start due to
the following error, "The executable program that this service is
configured to run in does not implement this service."
I am unable to start the Exchange Routing Engine Service and it fails.
I tried to add IMAP4Svc, RESvc & POP3Svc which were missing to
with NO GO.
Some background: IIS components SMTP & NNTP were removed some how and I
had to install that again and since then i am s...import- number- sort?
I imported this data into a spread sheet- I tried to format it to number,
but when I sort it- I get :
Whats up with this?
Install the TrimAll macro, select the column and invoke
the macro from Alt+F8
Directions to install and use a macro at
I expect that you have spaces or CHAR(128) "Required Blank"
characters in you data you can check is =LEN(A1)
David...admin console cannot start, mapi problems
admin console cannot start, mapi problems.
server 5.5sp4 working well, outlook session cannot run on
server, same mapi problems
Any error message in event log?
"daniv" <firstname.lastname@example.org> ���g��l��s�D
> admin console cannot start, mapi problems.
> server 5.5sp4 working well, outlook session cannot run on
> server, same mapi problems
As I understand you installed Outlook on your Exchange Server, which is not
a good idea.
O...Multiple Line Invoice Non-Inventory Item Descriptions
What is the recommended way to accomodate more than 3 lines of description
for a non-inventory invoice line item?
I've had people do it different ways. One way has been using the item
comment field. Another way has been to use Extender to provide a longer
"Scott Rutledge" <Scott Rutledge@discussions.microsoft.com> wrote in message
> What is the recommended way to accomodate more than 3 lines of description
> for a non-inventory invoice line item?
The lines would need to be differen...I am trying to project out a line graph based on data
I have made a line chart based on some data for a fiften year period. I
would like to plot out the future points for a thirty year period based on
this data. Does anyone know how to do this?
To perform a line projection, first click on the series the you would like to
forecast. Go to Chart -> Add Trendline. The "options" tab will allow you to
project the trend forward. You will probably want to use the "linear"
option. It can also provide an equation which would allow you to manually
calculate a future projection as opposed to using the trendline.
Jo...sorting macro #3
I need to sort on 8 cells in a row and on 1500+rows. I can do it one at a
time but I know there must be an easier way. Can ANYONE HELP?
C3:J3 I need these cells sorted and then down to C1532:J1532
I did create a macro to sort after I selected them but still one at a time.
Does it have to be a macro? I can edit a macro but don't really know how to
Yes, it has to be a macro. The following should do it. This macro loops
through all the entries in Column C, and in each row it sorts the values in
Columns C:J. HTH Otto
Dim rColC As Range
Dim i As...Bug in Grid Lines in CListCtrl Report View
This thing is again annoying me!
whenever I display the grid lines using LVS_EX_GRIDLINES , there are
problems when scrolling the CListCtrl at once , the grid lines seem to loose
their position and thus generating a blurred view or sometimes just disappear
Have anyone else faced the same thing ?
>whenever I display the grid lines using LVS_EX_GRIDLINES , there are
>problems when scrolling the CListCtrl at once , the grid lines seem to loose
>their position and thus generating a blurred view or sometimes just disappear
> temporarily...Charting Lines and Bars on Same Graph
I am having trouble charting a Quarterly Revenue Graph
with Lines and Bars on same graph.
I would like Revenue on Y Axis and Quarters on X Axis. I
would like 2 base series as bars and 6 other series as
Any idea how to do that? (i'm in Excel 2000)
I have gone to the chart wizard and chosen "Custom Types"
and then "Line-Column". This automtically selects the
first four in the series as bars and last 4 as lines. I
would like only the first two as bars.
Chart all eight series as lines. Select one to change to columns,
choose Char...New Line in Cell
Appol's in advance if this is really obvious.
I have been given a spreadsheet and its looks as though somehow the person
has been able to do carriage returns that create a new line in the same
cell. For me it simply jumps to the next cell.
Anyone know how to do the new line in cell please?
Hold down the Alt key and press Enter at the same time.
Hope this helps.
On Jan 30, 9:05=A0am, "Bill" <b...@bill.com> wrote:
> Appol's in advance if this is really obvious.
> I have been given a spreadsheet and its looks as though somehow the perso...starting Word from an Excel macro
I found this piece of code by Bob Phillips that opens a Word document from
within an Excel macro.
Dim oWord as Object
Dim oDoc as Object
Set oWord = CreateObject("Word.Application")
oWord.Visible = True
Set oDoc = oWord.Documents.Open("C:\personal\bob\personal\CV - RP
It works fine but it also closes the Excel file that contains the macro. Is
there a way to prevent the Excel file from closing?
There's nothing in that snippet that will close the Excel Application. I
think you need to post all yo...Draw continous vertical line in report detail section
My report has a report header approx 1.5" tall, a page header approx 0.5"
tall, followed by the detail section.
How can I print a fixed height detail section with verticle lines even if
there are only a few records? Essentially, trying to replicate a paper form.
The line starts at the bottom of the page header and continues to the top of
In a post a couple days ago, Allen Browne recommended the below for drawing
a line down the entire page.....this close, and I am trying to figure out a
similar approach for the detail section.
Private Sub Report_Page()
Me....line chart displays wrong values
Yesterday my chart wizard went crazy
A simple chart, I've done them thousands of times
Now when I select 2 series and try to plot a 2 line chart the first
series plots fine and the second plots as the sum of the two series.
I tried shutting down, restarting, typing the data manually into a new
sheet, sending the data to a colleague -- the result is the same
It sounds like you created a stacked line chart. To change it:
Select the chart
Choose Chart>Chart Type
Select the Line chart type
Select the Line chart sub-type (at the top left)
&...Can we sort a form and also be able to enter new records.
It is possible to sort the data on a form and also be able to enter
new and edit the existing records in it.
On Tue, 15 Jan 2008 15:41:16 -0800 (PST), Rex wrote:
> It is possible to sort the data on a form and also be able to enter
> new and edit the existing records in it.
I assume you mean "Is it".
The form sort order has nothing to do with editing or adding new
records, so the answer is yes.
If you cannot edit or add new records, make sure the form's record
source, if it is a query, is updateable. Some queries are not.
O...Sorting checking register
How do i sort my check register in Money 2004 Deluxe so
that uncleared transactions appear below cleared
transactions? In Quicken i could click on the column to
provide that sort.
In microsoft.public.money, Dean wrote:
>How do i sort my check register in Money 2004 Deluxe so
>that uncleared transactions appear below cleared
>transactions? In Quicken i could click on the column to
>provide that sort.
You don't. Available choices are chosen by clicking View at the top
of the register.
...using addrress books to sort incoming mail
I use address books to sort incoming mail.
An odd thing: depending on how the sender's name comes across, it doesn't
get caught by the filter (amd moved to the "Family Mail" Folder I have set
up. for example: my mom and dad's email (from email@example.com)
comes as from that address. However, in my contacts, they are listed by
their names: John and Mary Smith, with firstname.lastname@example.org as their
email address and John and Mary Smith as the display name.
What have I done wrong?
1. The big ONE - failed to post your version of Outlook. Rules operate at
...Assign a macro to Command Button Object
When I right click on my command Button to locate the option of assign to
macro its not their. How do I get the option to assign to macro to appear?
The other options are available to me on the command button but not the
assign to macro???
If the button is from the Control Toolbox, double-click the button which
will take you to the sheet module and provide you with a macro stub for the
CommandButton something like:
Private Sub CommandButton1_Click()
Insert insert the body of your macro between the two stub lines.
Alternatively, if the macro you ...Unmerge so I can sort
I coy/pasted data into Excell and when I try to sort it I get "This operation
requires merged sells to be identically sized". I understadn the work around
in KB but how do I find which sells are merged?
I wouldn't bother looking.
I'd just remove all the merged cells from the range to sort.
Select that range
uncheck the merge cells box
But if you wanted to search, you can do it via process of elimination. Select a
range, format|cells|alignment tab.
If that merge cells box is checked, then the whole selection is merged. If it's