Debt Planner scheduled payments not in cash flow forecastCan someone having scheduled bills from the debt reduction planner
look in their cash flow forecast for the account from which those are
paid, to see if the debt payments appear in the list of transactions?
I have 2 accounts for which the DRP is managing payments. Both are
paid from checking. That checking account includes payments to my
primary credit card, to which almost all categories are attributed in
the budget.
The cash flow forecast includes budget items and scheduled bills,
including the payment to the credit card. When I include the credit
card, the average balance of the ca...
Bordered Text within a Text Frame?I am doing the back cover of a paperback, and I want to have
the whole background of the frame in green. I want to have
the text inside margined. How is this done?
--
--
Robert Pearson
ParaMind Brainstorming Software http://www.paramind.net
Creative Virtue Press/Telical Books/Regenerative Music
http://www.rspearson.com
Format, background, when the task pane opens, more colors. Create your text box.
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
"telicalbook" <telicalbook@aol.com> wrote in message
news:1133988014...
IIF returning text valueI have a query with fields Q1, Q2, Q3, Q4. I want to collapse the answers
for questions 1-4 into either 1 or 0. So, I am using Iif....
Q1KR: IIf([Q1]<4,"0","1")
Q2KR: IIf([Q2]<4,"0","1")
Q3KR: IIf([Q3]<4,"0","1")
Q4KR: IIf([Q4]<4,"0","1")
Then I want to create a new field that totals those...
Total: [Q1KR]+[Q2KR]+[Q3KR]+[Q4KR]
Instead of 3, I'm getting 1 0 1 1
What is going on?
Incidently if I change the total to: [Q1]+[Q2KR]+[Q3KR]+[Q4KR], it sums
just fine.
Probably ...
I don't want my text to wrapI've got a text box filled with text, and then I want to put a circle over it
(filled white, so that the circle blocks out the text behind it, but the text
continues uninterrupted behind the circle). For some reason I can't get this
to work, even though I've turned off text wrapping on the text box, whenever
I put the circle over the text box it still wraps around the contours of the
circle.
Your statement is a bit fuzzy. Do you want the text to be blocked out so you
can't see it?
--
Don
Vancouver, USA
"Craig" <Craig@discussions.microsoft.com> wrote...
How to change menu text font for MDI app? I have a MDI app written in MFC. I need to change font for main frame, menu
text, status text, and child frame. What is the best way to enumerate through
all those controls/frame windows to change font?
Thanks.
Michael
I would have them each change their own fonts in response to a broadcasted
message.
http://www.codeproject.com/docview/Broadcaster.asp
I am assuming that this happens after all the objects have already been
created (or else you would have been doing this in the initialization code
of each class), so if is because of a user setting, I would save the
setting, then broadc...
Forced text wrapping I've got some text cells in Excel 2003 in which I don't want the text
to wrap. I formatted the cells leaving the "Wrap text" box unchecked. But
when I paste text into a cell and do some editing, it automatically wraps
the text in the cell, and if I then bring up cell properties, the wrap box
is filled with a green square.
How do I get Excel to use the format I told it to use for these cells
and leave the text in them unwrapped? I've searched through help files &
FAQs and can't find a solution. I thought there might be some auto setting
that might nee...
integrate flow
I receive in my spreadsheet a information of a flow in Liters per minute
(real online data )
can I ,in one cell, integrate this flow ?
Thank you very Much
CC
...
Some messages stuck in SMTP connector queueWe send/receive external mail via a smart host. We have a SMTP connector
configured to send all outbound mail to the smart host IP. The Exchange
2003 server is behind Proxy.
Mail comes in fine.
Most messages from workstations (XP, Outlook 2003) go out of the connector
queue very fast. Sometimes, messages from the same workstations stay in the
queue so long that it generates the Delivery Status Notification (Delay)
message.
Any ideas about what will cause this and how to fix it?
Thanks
On Mon, 3 Jan 2005 22:02:29 -0500, "TLW" <tlw@oceanlighthouse.com>
wrote:
>W...
Comparing text in ExcelHi,
I am comparing 2 workbooks in Excel. I have names in the 2 columns I am
trying to compare. The problem is the names can be slightly different
e.g. 1 Mysteria Lane could appear as 1 Mysteria Ln. in the other.
Therefore I cannot use exact matching.
I was going to use Vlookup and set the final setting to True to use an
approximate match but wanted to ensure there was no better way.
Please let me know if there is a better way of doing this or if anyone
can explain how the matching work when you use True in Vlookup I would
appreciate it,
Thanks,
P
Hi Paul,
Try a search for soundex on...
Insert a Text Filed in Word 2003This may be answered elsewhere, but I couldn't find it. I think it is
simple, but one never know. I want to have various pieces of text in my
document to act like a field. i.e. I want "Aerial Survey" to appear in
multiple places but have only one source. So that if I change the wording
for "Aerial Survey", to "Aerial Topographic Survey", it will change
everywhere in the document. I do not want to protect the document. I can't
seem to figure out how to do this. Word 2003 please.
Dave
Dave,
For a start - and possibly an end - see
h...
converting general cells format to textI'm having a hard time converting already existing general cells into text
format. I'm trying to change it into text format so SAS will be able to
recognize it. Without the "green indicator", SAS, for some reason, will treat
it as a "general" cell even though I've saved it and changed the cells into
text. Any suggestions?
Sometimes when you type a number into a cell and then change the format to
text, it does not "set in" imediately. Hit F2 and then enter on each cell
and it should change it for you. Hope this helps.
"junkgrrl" wrot...
Text Color Changes By ItselfI have been working on a workbook where I'm entering (by hand) a couple
hundred rows of data in three columns. When I reach a line of data that I do
not need to review further, I enter it, highlight the three cells in which
I've entered data, and change the text color to gray. I'll then hit enter and
begin typing the data for the next row.
The problem is that sometimes after I've changed the text color on the
previous row, some or all of the cells in the subsequent row will also get
changed from black (auto) to gray. As I enter the data, the text is black,
but ...
Money 2006 SBI'm using the Small Business edition, and am toying with the idea of
entering invoices to track receivables.
My question is on the Cash Flow Forecast graph - it currently shows the
income as of the invoice date. Most customers are net 15 or net 30, and I
would prefer to see the income in the graph based on the expected receipt
date.
Any way to change this?
Bob M..
"Bob Murdoch" <ram_re_move_5@erols.com> wrote in message
news:%23E1K5XHuFHA.2540@TK2MSFTNGP09.phx.gbl...
> I'm using the Small Business edition, and am toying with the idea of
> entering in...
automatic text highlightingHi folks,
I use a spreadsheet that automatically changes the font color of the row
to red if the text in a particular cell = fail.
My problem is it's not working consistently (because of my editing the
spreadsheet I expect) and I CANNOT find out how it's done.
There's no macro and no hidden cells that I can find that perform this
text coloring task.
Has anyone an ideas of how it's been done?
Thanks
Glenn
Glenn,
Mark the area where you want this applied, and then go Format > Conditional
Formatting. The rest is self-explanatory.
HTH,
Nikos
"Glennh" <g...
remove returns from pasted textVersion: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Anyone know a way to remove returns from the ends of lines in a paragraph of text that has been pasted into Word from a text editor? "Paste Special" does not seem to offer this function (or at least not that I can find). I used to have a nifty little program (on an older Mac) that allowed you to do this simply by highlighting the text and clicking a button. Can't remember what it was called.
Other programs not req'd. In Word:
Menu: Edit/Replace
Enlarge dialog box with the little arrow ...
Cash flow no flowI've got several of my accounts set up with ms money since
I bought it a few years back, however, whenever I try to
use the 'Cash flow review' I get a dialog saying:
'Please create atleast one checking, savings, or cash
account before you go to the cash flow forecast'. What's
up with that? What can I do besides having the checking
account, savings account, etc I have already? Ideas?
Try reading this message:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=%23UnR1z%233DHA.488%40TK2MSFTNGP12.phx.gbl.
"Daniel" <nefar@hotmail.com> ...
CRM Connector for GP Install errorI have installed the CRM and Dynamics GP adapters and am trying to install
the Integration Server adapter and receive:
"setup was unable to connect to Microsoft Great Plains Adapter. Please make
sure that you have installed MS GP Adapter before installing MS CRM Connector
for MS GP"
I have GP 9 running on W2K3 with SQL2005. CRM 3.0 Server on W2k3.
Integration Server is also W2K3.
I can connect to CRM from all 3 servers
Thank you
--
Ryan
Hi Ryan,
It's been couple months that I have used the microsoft GP and CRM
connector, unless Microsoft change it to support SQL server...
Extra text added by system when converting to PDF?I've been using PDFMaker to convert my MS-Word styles to bookmarks for the
past couple of years, but now that my office has upgraded us to Acrobat 8,
I'm running into a problem. Each time a bookmark is created from a Word doc,
there is a very small bit of text added to the front of it.
The system seems to be numbering the bookmarks sequentially, starting with
"0B" for the first bookmark, and continuing for the rest. They're very small
characters, and unless you zoom in very closely, they look like periods at
the front of each line.
Example:
.Bookma...
Centering text on a pageIs there a way to center text automatically in a row across the top of the
page without having to pick a column that is close to center, then using the
space bar to find the exact midpoint?
Thnxs
Hi Justin!
Select the cells across your page
Format > Cells > Alignment
Place check in "Merge cells"
Horizontal and Vertical drop downs should be set at Center
OK
There is a standard toolbar button for this. Use:
View > Toolbars > Customize
Look under Format for the Merge and Center button
Click and drag it to your toolbar.
--
Regards
Norman Harker MVP (Excel)
Sydney, A...
Importing text files into ExcelDoes anyone know of a quick and easy way to bring large text files into
Excel. The data in the text files is separated by spaces. The spaces that
separate the data vary in number. I have tried to replace the spaces with
tabs while in Notepad but it takes too long. Any help would be appreciated!
Thanks
Chris
Open Excel and create a blank workbook.
Then:
Data | Get External Data | Import Data (this command might be something
like Import Text File, if you are using an older version of Excel).
Browse to find your file and click to Import it. Should open up the Text
Import Wizard.
Make...
text field with input maskHi all,I have a text field with field size of 6, input mask of &99.99. So it is ok for me to data entry data like E55.66, or 777.88. Now I need enter E123.45. If I change it to field size 7 and input mask of C999.99, I can enter E123.45, but all of my old data will be wrong. What should I do to keep all the old data right and also be able to enter my now data?Thanks,Blinda "Blinda" wrote:> Hi all,> > I have a text field with field size of 6, input mask of &99.99. So it is ok > for me to data entry data like E55.66, or 777.88. > > Now I need enter E123.45. If...
Drop down boxes AND free text?All,
Is it possible to create drop-down boxes within Excel AND allow user
to input free text when the choice is not available?
I know this seems to violate the idea of "validating".
What I'm trying to do is provide my users with a fairly complete lis
of manufacturers from which we can buy. However, I cannot completel
predict 100% of the manufacturers we'll ever use.
HELP
--
Message posted from http://www.ExcelForum.com
why don't you let them add to the list of manufacturers?
check out http://www.mvps.org/access/forms/frm0015.htm - Add item to combo
box using OnNot...
Why is "image and text" option grayed out for some buttons in the customization?It so happens that the most frequently used buttons on the tool bar
are the up-arrow and down-arrow (the ones that move to the
next/previous item).
As I tried to assign short-cut key to them, however, i found that the
"image and text" option is grayed out - for that matter, all other
display options are grayed out - when you go into customization mode.
Why is "image and text" option unavailable for some buttons?
...
Active Directory ConnectorLast summer, I upgraded our Exchange 5.5 box and used W2K
server instead of NT4 server. This summer, I am going to
the PDC's and BDC's to W2K server, but we will remain in
mixed mode for a while. I have a test network set up and
I have the old Exchange 5.5 server on it. I have already
upgraded the PDC to W2K, but will not be able to upgrade
the Exchange server. I followed the instructions in MS KB
article 301036 about installing the Active Directory
Connector for use in managing the Exchange 5.5 server
through the Active Directory Users and Computers MMC,
however it does not...
import only the first part of a text fileHello --
An external application generates a text file which looks like the text
between the lines:
-----------------------------
ARRAY 1 6
#X-values
30.201515
30.260118
30.330780
33.360526
33.430092
34.737403
< --- blank
line
#Y-values
1.860447
0.058603
0.070662
3.029746
0.069566
0.870192
-----------------------------
Our charting process imports the text file, but needs only the data above
the blank line.
It is possible that the top part of the data could contain as many as
65,500, so I can's simply import the whole file i...