Account Format change
I need to add a new segment to my account framework and also increase a
segment length for my existing accounts.
For example: from 10-999, I need my account to read as 30-10-00999 where the
first segment is the new segment and the last segment of 999 becomes 00999.
Will Reformatter or the product from Microsoft do both of these things?
Anyone has experience with this.
I believe you need Reformatter from CRG.
Charles Allen, MVP
> I need to add a new segment to my account framework and also increase a
> segment length for my existing accounts.
> ...changing a line to a bar in "line-bar graph"
I have 4 qtrs of data and a benchmark set up in a line-bar
graph. when the graph comes up, 3 of the quarters are
reflected as bars; the 4th qtr appears as a line, along
with the benchmark. I want to be able to change the 4th
qtr to a bar.
I need this for a board report - ASAP please
Right click on the series, choose Chart Type from the pop up menu, and
select the chart type you want for that series.
Jon Peltier, Microsoft Excel MVP
Laurie M wrote:
> I have 4 qtrs of data and a benchmark set up in a...Workflow values and fields
Hello ladies and gents,
I am creating a workflow rule to send an email to a customer. The email
dynamic values can include everything from the information section of the
quote (eg Quote ID, Total Amount and shipping address) but i cant select
things like what i have chose in existing products and write in products...
anyone know how to do this?
You can write your own webservice that creates custom emails through
logic. You can then have your workflow rule call the webservice.
Webservices can be registered as CRM callouts without any further
them. ...Splitting Values
I have a long column with town state and zip code appearing like this
Farmington, CT 06032
can a macro be made, or is there a command that will take the last five
characters from each of these cells and put them somewhere else?
If you have Farmington, CT 06032 in cell A1
Put this formula in B1 to get the rightmost 5 characters
Vaya con Dios,
"Zip Codes" wrote:
> I have a long column with town state and zip code appearing like this
> Farmington, CT 06032
> can a macro be made, or is there a command that will take the last five ...listview control display as a group
I have a requirement to display the list items as group. I have been trying
to use the CListCtrl::insertGroup() method. The method works fine but the
grouping doesnt show it does show the items just as regular items.
Here is the code:
<font SIZE="2" COLOR="#0000ff">
<p>void</font><font SIZE="2"> Ctt1View::OnInitialUpdate()</p>
<p></..."Today's Total Change" doesn't calculate in Portfolio Manager
I've had a problem with Money 2005 and 2006 Deluxe where the Portfolio
Manager does not show "Today's Total Change" for stocks & mutual funds. It
shows it for some, but not others...this is not only an annoyance, but
prevents me from seeing how my investments are doing on a daily basis.
What's interesting is that it shows today's change in the price of the stock
or the NAV of the mutual fund, but Money seems to have issues with
multiplying that by my number of shares to get "today's total change".
I saw a patch for this in Money 2001, but it w...version changes
i created a business card on Publisher (xp) but when i try to load it onto a
computer w/ a color printer that has publisher ('97) it says i can't load
stuff from another version.
is there any way i can "downgrade" the project to make it compatible with
the older version?
didn't mean to post that twice. see above. ^^^
No there isn't. Copy the file to a disk and hie thee to a print shop.
MVP Microsoft [Publisher]
"Pringles." <Pringles.@discussions.microsoft.com> wrote in message
news:285A2C89-D032-4123-87C0-0ABFF5B652A5@mic...change cell change picture
I'm using cell to display picture, for that, i saw a topic here with this
but the problem is that i'm not getting the pictures displayed, it appears
like example only without picture.
I'm making the connection between picture and cells with INSERT -> NAME ->
someone can tell me how can i do to work it out?
...Prompt for user to change passowrd...
Is there anywhere in setup where we can prompt a user to change their password?
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/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=38427276-d6c5-4b43-8f63-1f1b6e6f836c&dg=m...Change insidewidth property
i need to change the insidewidth property in plot area what size i want. for
ex. if i am giving chatarea.plotare.insidewidth = 200 then it shows error
because insidewidth is read only double. so how to change that value
You can not change the value directly because as the error says it is a
Read-Only property. You would need to change the 2 things that effect
the value, plotarea width and axis labels. But it would be a case of
trial and error.
M Selvaraj wrote:
> i need to change the insidewidth property in plot area what size i want. for
> ex. if i a...changing page layout
I did a document in publisher in portrait layout, with a picture and would
like to make it a side fold document/
Setup a new publication as a booklet, copy/paste your objects from the older
Mary Sauer MSFT MVP
"chinadoll" <firstname.lastname@example.org> wrote in message
>I did a document in publisher in portrait layout, with a picture and would
> like to make it a side fold document/
...tab control #2
im developing ui framework in mfc.
could you please tell me how to create non rectangular tab control?
...Determining address of value type variables
How to get the address of(memory location) value type variables?
GetHashCode() returns only value and not its address
> How to get the address of(memory location) value type variables?
> GetHashCode() returns only value and not its address
> Thank you
An address in memory and a hashcode have nothing to do with each other.
You should rarely, if ever, need to get an address of any .net object.
To get an address in memory, you need to use unsafe code and the "&a...Server Log on changes
When I try to send outgoing email my login iformation changes and I get the
Your message did not reach some or all of the intended recipients.
Sent: 5/22/2006 11:52 PM
The following recipient(s) could not be reached:
email@example.com on 5/22/2006 11:54 PM
You do not have permission to send to this recipient. For
assistance, contact your system administrator.
<mycompany.domain.local #5.7.1 smtp;550 5.7.1 Authentication is
required to send mail as <firstname.lastname@example.org>>
Any Ideas...how to change the icon text
What event to I do to handle when my app get iconified? I Need to set the
window text for my icon differently than my app title bar text.
When I run my app, the window text for the app title bar is "foo", when the
user iconifies the app, I want the icon text to be "bar".
How do I do that?
Thanks for the help,
Take a look at CWnd::OnSysCommand. SC_RESTORE and SC_MINIMIZE is what you
want to look for in this method.
Ajay Kalra [MVP - VC++]
"reza razavipour" <email@example.com> wrote in message
news:uK18XkXH...How customise Controls in Dialog
I am building a Dialog with Controls (Static Text, Edit, Progress Bar,
CombBox and so on). How can I assign different font and font size for each
Control? How can I know what properties I can control for different types of
You can use SetFont to change the font of any control. This font should
live as long as the control. Typically you will make it a member of the
For control properties, look at CWnd class and the specific control
class(CStatic, CEdit etc). All controls are derived from CWnd. You can
use methods/properties exposed by this clas...textbox value from a combobox in a continuous form
I have a combobox cboOperationID and textbox txtOperationDesc in a continuous
form. User chooses an operationID in the combobox and textbox automatically
displays the description of that operationID using
Me.txtOperationDesc.Value = Me.cboOperationID.Column(1)
in the afterupdate event of cboOperationID
My problem is whenever i move to the next entry in my continuous form and
chooses another operationID from the combobox, the description in the
txtOperationDesc from the first entry also changes to that of the 2nd entry.
Message posted via http://www.accessmonster.com
There's a ...How to change Pivot when SQL data source fieled name changed
Q: How to change Pivot when SQL data source field name changed
I have a Pivot table that accesses a SQL data source.
When one of the Fields Names in SQL is changed there is an error when trying
to refresh Pivot Table.
I cant find a way to edit the Pivot Table MS Query for the new SQL Columns
Name like I can when just using MS Query to import data into excel vs into
Is this possible?
Resolution: Call up the "Pivot Table Wizard" and hit Back Button to retrace
steps and change data source
> Q: How to change Pivot when SQL data source field...change chart title with auto filter
I would like the title of my chart to change automatically every time I use
the autofilter function to make a new selection of data to be displayed in
the chart. Can anyone inform me of how to make the chart title change
automatically with each new selection?
See this 'link'
Krishnakumar's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20138
View this thr...Controls and focus
I have a sheet with several buttons on it. If I type in a cell, I need to
click outside the cell before I can choose the button. Is there a way to go
directly from typing in a cell to clicking the button?
This enters the value just typed.
You may prefer to press the Enter key instead.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
...Workflow for Activities
Why is it not possible to assign an activity to a specific queue, or at least change its attribute (owner) to the queue. This seems to be very inconsistent with the behaviour for cases, in which you can control who owns it....
Any alternative way? Any comments?
...Change location of PST with IMAP accounts
I am currently using Outlook 2007 and have a question about IMAP. When
using regular POP accounts, you can change the location of the PST by
moving it to another place in Windows Explorer and the next time you
start Outlook it will say the PST is missing and will ask where it is.
Now, when using IMAP accounts this approach doesn't work. When you
delete/move the PST that is associated with an IMAP account, Outlook
will just redownload the mailbox from the server and create a new PST in
the same location (%USERPROFILE%\Local Settings\Application
I didn't f...change default layout view
How can I get my emails to open up with the Print Layout
View as default. Every time I compose a new message or
open one from my inbox, the format defaults to normal view.
...Won't tie me to active internet connection
Something strange happened recently such that I can't sign on to the internet
to get data into MS Money 2007. I also don't seem to be able to get to the
internet with Media Player or the General Microsoft Help page either. This
is true even as I'm using the internet for other stuff via IE, so I know I'm
connected. Any ideas why my Live ID won't work or how this might be related
to my other MS issues? Thanks.
...Crosstab Row Heading Issues
I have Access 2003 and when I do a cross tab I cannot bring in more than 3
field values for row headings - my coworker (who has Access 97) can bring in
>3 row headings. Is this a paremter setting in Access 2003?
I believe that the Wizard can't handle more than 3; however, you can do more
with SQL. Try creating a crosstab with the three headings, them modifying it
at SQL level to add more.
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> I have Access 2003 and...