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 ...How to Merge Date from 3 columns to 1
I have a spreadsheet where the date is spread over 3 columns I,J & K and I
wish to merge them to Column B in the format dd-mmm-yyyy as shown below.
B I J K
02-Feb-2003 02 Feb 2003
27-Mar-1999 27 Mar 1999
01-Apr-1978 Apr 1978
14-Jun-2002 14 Jun 2002
Where there is a blank for the day in 'Column I' I need it to copy as 01 and
where there is a blank for the month in 'Column J' I need it to copy as Jan.
Where all 3 column...Error when sending/receiving
I have just set up Exchange 2003 on a test network at work. Everything
seems to work ok, except when you do a "Send/Recieve" in either
Outlook Client (2003) or with OWA.
I get a "Permissions Denied" error. Mail is still sent, and received
Checking the log files shows this message:
14:15:53 Synchronizer Version 11.0.5604
14:15:53 Synchronizing Mailbox 'Martin Paton'
14:15:53 Microsoft Exchange offline address book
Doing a search on this error reveals little about how to correct the
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..."An unexpected error has occurred" when sending from distribution lists
I have set up a new computer, installed Outlook 2002 on it
and migrated my files to it from the previous computer.
Now whenever I attempt to send an email addressed via one
of my distribution lists, I get an error message (An
unexpected error has occurred). I also see two Contacts
folders in the Add Address List in the Tools/options in
the address book.
I did change the location of the Outlook pst files, did I
confuse something or ?
Any ideas? Nothing in the Knowledge base helped
...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...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...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...Exchange System Manager Error #3
I just installed a new certificate on my Enterprise exchange server. I had
been using a Small business server as a front end server and recently ran
the transition pack to convert to a full Windows 2003 server. I am no
longer using the exchange that was on the small business server and have
disabled all of the services until I get a chance to remove it. When I try
to access public folders from Exchange System Manager, I get the following
the SSL certificate server name is incorrect
ID no: c103b404
Exchange System Manager
I am not sure what is causing this. All of the public ...Error converting 2003 to 2007
I have been trying everything to convert a MS-ACCESS 2003 file to 2007.
Everytime I try I get the error
Could not use 'C:\DB.mdb'; file already in use.
I have tried re-booting.
I found this article that I thought would help:
This says it is caused by user rights on the folder. This can't be the
problem. I have full access.
I would appreciate any help.
It may be a misleading message telling you that you are trying to use the
same filename as the original file.
Arvin Meyer, MCP, MVP
h...Error: Method 'OpenTextFile' of object 'IFileSystem' failed.
I am epxeriencing the same issue now. Only diffeence is mine is 'Method
OpenTextFile of Object Ifilesystem failed'. I am sitting late nights to
trouble shoot this.
Any help is appreciated.
I have a VBA macro on MS Excel that should open and read from a Text
file. This is the code
Dim fs, Tempfile
Set fs = CreateObject("Scripting.FileSystemObject")
Set TempFile = fs.OpenTextFile(strInputFile, 1, False)
Do While TempFile.AtEndOfLine <> True
I found that it throws error in the OpenTextFile mothod above..
It works for all of ...Determine cells that drive conditional formatting?
Cells A1:A4 have conditional formatting set up that states if they are equal
to cell A10 they will be highlighted yellow.
Is there a way to quickly see what cells drive conditional formatting? In
other words, we can use Edit -> Go To Special to see which cells have
conditional formatting applied; however, this doesn't show us that A10 is
involved. Since there isn't a formula directly involved, we can't trace
precedents/dependents. Can we only know that A10 is involved in the
formatting of A1:A4 by selecting those cells and going into the conditional
format...GP upgrade to sp4 error
When upgrading to sp4, the working companies upgraded fine. The only problem
is with the TWO company. It gives an invalid column name 'ACTNUMBR_4' erro
while running stores procedures. It appears the script SE_Get_Acc_Detail_Hist
is creating an error when it tries to load. We use the sample company for
testing so it can be removed if needed, but would like to keep. Can't find
anything anywhere on this error. Any help would be appreciated.
As alternative to troubleshooting, you can always re-initialise TWO by
running GP Utilitiies and select to 'Re-a...MobileSync error
When syncing my iPhone within iTunes, I get an error that says "MobileSync
has stopped working" and I am required to close out of the program. Songs
seem to sync fine, but my contacts from MSFT Outlook do not come across.
I've un- and re-installed Outlook, as well as iTunes to no avail. Any ideas?
...fix cell references
I often have to fix and then unfix cell references using the $ sign to fix
and then find and replace to unfix.
Is there a menu option to fix column / fix row / fix reference (and unfix).
If there is I cant find it.
not AFAIK, however F4 is the shortcut key for this and takes you through a
A1 - column & row relative
$A$1 - column & row absolute
A$1 - column relative & row absolute
$A1 - column absolute & row relative
would using a mixed absolute / relative reference solve your problem?
"AK" <AK@discussions.microsoft.com> w...How do I print onto a non-standard size notecard?
I am trying to print onto a notecard (about 5.2" X 7.2"). I've put the
dimension in the page set up and specified 'Main tray' for papersource, but
when I try to print the error message says that either the wrong type of size
paper has been selected.
Some printers don't handle custom styles well. In such cases your best bet
is to select the next-larger built-in paper size and make up the difference
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"bessylou" <bessyl...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...Compact and Repair Error
I am tyring to compact and repair a database. After a start the process a
new db shows up in the source folder, usually db1. No problem there. When
the db is done, the size of the 'compacted' db is the same. db1 still exists
and it is actually the compacted db. So when it is all said and done, I have
two db's, db1 and the original. db1 is the compacted version of the original.
Any thoughts on how to fix the process so the db1 replaces the original db?
On Mar 4, 3:12=A0pm, PJFry <PJ...@discussions.microsoft.com> wrote:
> I am tyring to compact and re...XP error
I have using OUTLOOK XP with good success on my WIN ME
system for many weeks.
All of a sudden it refuses to send and receive mail and
disconnects with error 0x80040154.
I can have access via webmail and I am using explorer 5.5.
But this a pain ! My ISP was no real help.
My ME system has 'forgotten' or misplaced things before
but I had no luck so far in reregistering a .dll file if
that is required.
Any suggestions how I can get OUTLOOK XP back ?
...text in cell shows up as ####
Operating System: Mac OS X 10.5 (Leopard)
Text in cells in a coumn shows up as ####, apparently because there is a large amount of text. When I mouse over, the text shows. It also shows up in the formula bar. How can I copy and or print the text in these cell? <br><br>When I try to save these cells as text and transfer to Word, they continue to print as ###.
text in cell shows up as #### <br>
I am totally new to this whole environment! A new iMAC and this software. <br>
However, in trying to learn how to use EXCEL, I found that...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...Cell.Find
Can anyone suggest an alterantive to Cell.Find or help me with the correct
Error message is:
Active method of Range class failed
The Cell.Find is run in spreadheet X
Cells.Find(What:=SCN, After:=ActiveCell, LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext,
SCN is a value in spreadsheet Y
I have tried being specific with Workbooks("Y").Cell.find etc etc but get
Object doesn't support this property or method
Need to lookup a value in spreadsheet Y and retieve a value in the cell next
to the ...Reports Access Demied Error
I get an Acces denied when trying to access to reports or some CRM Setup
even when I log as the administrator
However when I go tho the reports site directly through WEB interface, I can
what am I missing?
For the momment I have not configured SSL for authentication to the SQL
and both servers are in the same domain
the SQl server Services are handled by the user network
Thanks for any support
> I get an Acces denied when ...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...To Do Bar Error Messages
When I open Outlook I get two "error messages". One says "There was a
problem reading one or more of your reminders. Some reminders may not
appear." The second appears in the To Do bar where my tasks should be. The
field is blank except for "The operation failed. An object could not be
found." I have run diagnostics and tried doing a repair from the install
disk. Any other ideas?
First start Outlook with the cleanreminders switch;
Start-> Run; outlook.exe /cleanreminders
(note the space in the command)
This should take care of the remind...