Showing wire transfers correctly
I have Money Plus Deluxe 2008 and I had wired some funds from my investment
account to my checking account. This shows up on my checking account as an
"uncategorized income" line. I tried to change it to a "Transfer" to
investment account, but that causes the the investment account to be adjusted
as well. Any thoughts on how to fix it?
Don't you want to change it to a Transfer **from** the Investment Account?
Wasn't your investment account out that money? Don't you want to reflect
that in the investment account as well? Why shouldn't it effect both
a...The ActiveX control could not be created
In the Project Center of PWA 2007 + SP2 and Aug CU, I did:
Actions > Export Grid to Excel.
But I got the error:
"The ActivX control on which this feature depends could not be created.
Because of this error, you can only copy the XML data to the clipboard. Do
you want to continue?"
How/where can I install this ActiveX control?
Thanks for your help.
Depending on your IE security settings, it should prompt you to install the
ActiveX control. Have you set the site as a trusted site within IE?
- Andrew Lavinsky
Blog: http://blogs.catapultsystems.co...How to create a table to qualify a qty discount in exel
Hi i'm creating a workbook to orginize stock, i'm not sure of how to create a
table to give varying degress of discount according to the quatity bought ie:
5 items or less = no discount, 6 to 11 items =2% discount and so on, i have
used an if statement so far but i'm not sure how it is meant to work in
relation to the products and customers sheets, how does it all work together.
Any help & guidence would be much appreciated.
You can create yourself a lookup table, and use the vlookup formula. See:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_exce...Create Exchange 2007 mailbox
We use a vbscript to create users. Here are the lines of code in the script
that creat the user account. The password is also set and some groups
Set objUser = objUserOU.create("user", "cn=" & strEmpid)
objUser.Put "SAMAccountName", strEmpid
objUser.Put "givenName", strFirstName
objUser.Put "sn", strLastName
objUser.Put "displayName", strLastname & " " & strFirstName
objUser.AccountExpirationDate = DateAdd("d", 1, CDate(strEndDate))
objUser.Put "userPrincipalName&q...Creating Groups
Using Outlook2002, is there a way to create groups so that I can select the
group name for a mailing rather than the individual members? I can't figure
it out and it seems that years ago you could do that.
Thanks for any help and God Bless,
Mark A. Sam
File > New > Distribution List
"Mark A. Sam" <msam@Plan-It-Earth.Net> wrote in message
> Using Outlook2002, is there a way to create groups so that I can select
> group name for a mailing ra...how do i create subset and union in XPath Query
I need a XPath query, whcih ll return me subset of data....
check below xml stream
<label id="MyExpenseDetails_lbl" xlink:role="terseLabel">Short Expense
<label id="MyExpenseDetails_lbl" xlink:role="displayLabel">Expense
<label id="InternalExpense_lbl" xlink:role="displayLabel">Internal
<label id="ExternalExpense_lbl" xlink:role="terseLabel">Short External
See above xml data having 4 label ...How do I create a Bell Curve Graph in Excel
I am trying to create a Bell Curve Graph in Excel but have ground to a halt,
I using Excel 9
This example at this site should help:
> I am trying to create a Bell Curve Graph in Excel but have ground to a halt,
> I using Excel 9
See Normal curve
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Off...Cannot create a key uder HKEY_USERS !
I want to make a new key under HKEY_USERS.
I use RegCreateKeyEx(HKEY_USERS, "Test\\SOFTWARE", 0, NULL,
KEY_ALL_ACCESS, NULL, &hKey, &dw);
However the function always returns - "The parameter is incorrect." . If I
change HKEY_USERS to HKEY_CURRENT_USER the key gets created. I can not add a
new key under HKEY_USERS even when I use Regedit.exe . I am testing on a
Windows XP professional PC . Can anyone tell me what is wrong?
HKEY_USERS is restricted to Admins and the OS. I'm betting you do not have
sufficient privileg...Creating drop down lists with multiple options?
I am trying in vain to create a drop down list where users can select more
than 1 choice. For example, if the choices in a list which i named are as
How does one have the option to select any of the colors by themselves or
any combination of all of them up? For example, if the question is what is
your favorite color? How can a user choose Blue OR Red and Blue OR Red, Blue
and Green and so on?
Any help would be appreciated.
That will require multiple cells. One cell will only hold 1 value. Any single
cell solutions are going ...Attempting to create a CRM Test Environment
I am attempting to create a CRM test environment using the database name
"Adventure Works Cycle". After the database is created and the users added I
have attempted to import the XML schema and form changes from our Production
Environment but everytime I do this I recieve the error "An Error has
occurred. For more information, contact your system administrator". This
error appears when I click on the "Services" tab. I know that it is
attempting to query the database at this time. I am able to click on the
"New Case" button and bring up the p...How to create a "really" transparence MFC control?
I wrote a D3D app based on the MFC dialog,the app's draw frequency is 30FPS.It has a main dialog,i create the D3D device on it,also i create some sub dialogs and controls on this main dialog.When i run this app, some errors appear.When i click or move the sub dialogs and controls it reflash on the background(I think the MFC's draw frequency unequal to the D3D app's draw frequency cause this problem), this bring on the bad effect.Is there any methods let this sub dialogs and controls didn't reflash or redraw themself to be "really" transparence:only receive or send...simple xsl for creating aspx page
I know nothing of XSL but was wondering if it was possible to do the
Given an XML template:
<register TagPrefix="whatever" TagName="Template"
<page language="c#" />
<usercontrol tag="whatever:Template" ID="header" Runat="server"
<form id="form1" method="post" runat="server">
<h1>some text here</h1>
<usercontrol tag="whatever...How to Page Break correctly in Report Writer?
I have a customer statement modified report in GP and I am trying to get the
report to Page Break when it goes to next customer record, because obviouslly
I cannot have 2 customers on same page.
So I created a additional footer in Section Options and set it to Page Break
on Customer Number.
That is working fine, it does page break when customer record changes. But
when I have a customer that has 2 pages worth of invoices listed, on the 2nd
page header it will list the Name of the following customer. Why is that?
For example, I have a customer called ABC and XYZ. It will print the 1st
...COM Proxy timeout error when creating new opportunity
I get an exception when creating a new opportunity in CRM 1.2:
[COMException (0x80040e31): Timeout abgelaufen]
Microsoft.Crm.Platform.ComProxy.CRMOpportunityClass.CreateAndRetrieve(CUserAuth& Caller, String InOpportunityXML) +0
Microsoft.Crm.Application.Platform.Opportunity.InternalCreateAndRetrieve(String xml, String columnSet)
Microsoft.Crm.Application.Forms.Customi...Create a new e-mailactivity
I wonder if there is a chance to create a new activitytype like salesmeeting
or if I only can use the existing ones...?
You cannot create new types of Activity, and so are restricted to the
However it quite common to reuse one of the original types - such as
renaming the 'Fax' activity to 'Sales Meeting' or something similar.
Typically I'd reccommend adding a Category or Meeting Type field to the
Appointment Entity Type and then customising the Views or ISV.Config to fit
your requirement, as whilst renaming the existing types can work it is a bi...How to create Office Sta 03 from a picture? #2
Just posting one help question, here's the second: Again regarding Creating
Stationary for Outlook?! Again, reminding those I'm no "geek" in any
respect, wishing one day I was, but it "ain't happened yet"! I depend & reply
on those with the knowledge - so someone - please help! ONE TIME I was
successful in taking an image, inserting into PAINT, fix'g the way I wanted
it to show itself, saving same as an image, with the apparent default being
Bitmap, wanting to save as another type - mainly that of Internet Explorer!
HOW do I do it? As shared, ...how to create a calculated field from another calculated field?
In a pivot table report I would like to add a calculated field that is like
= count( columnA ) / count ( columnB)
But when I create a calculated field like the above, all I get is a value of
1 in every row of the pivot table.
I realize after some experiments, its really performing
= count( sum ( columnA ) ) / count( sum ( columnB ) )
So , how do I get what I want?
...Remove Ability to Create Contacts
We have a third-party plugin tool (which links with our CRM) for
Outlook 2003 which has its own "Create New Contact" wizard we want
people to use instead of creating a new contact with Outlook.
The question is, how do we remove their ability to create a new contact
using Outlook's default contact creation screen?
It would be nice if we could remove the button(s) used for creating a
new contact, but the problem is the multi-function button on the
left-hand side of the toolbar - when you're on the contact screen it
become a Create New Contact button. But removing the entire ...create a cell that accumulates, numbers from another cell...
I need to know how to have a entery cell that can send number values to a
cell that accumilates there sum .the entries in the entery cell can be
changed and the recieving cell just keeps adding up. The entry cell can be
left blank and the sum remains in recieving cell.
"sombull" <email@example.com> wrote in message
> I need to know how to have a entery cell that can send number values to a
> cell ...Sorry to create a new post, but I have tried the other posts' suggestions... can't use install new Office 2004?
I'm hoping someone can please help me to help a friend who is in need.
I am in Germany to attend his wife's unexpected funeral and help him
out with his 4 young children and his small business. Well, one of the
things I did was convince him to switch from an old PC to a new iMac.
And then I got him to buy a full version of Office 2004 rather than use
Apple's Windows emulator and run his old PC version of Office. So the
new Mac Office 2004 arrives, and one of his 'know it all' friends puts
the disc in the iMac and starts the installation - without first
removin...How to create and delete recovery points for DPM via PowerShell
Knowing how to manipulate DPM by way of PowerShell can come in handy in many
situations. For example, I had a case to where I was troubleshooting the DPM
console that was crashing and there was a concern as to whether or not
recovery points where being made for specific protection groups. Using the
PowerShell command we could not only verify this, but we could create a
recovery point to any protection group we wished. Another example would be if
you wanted to delete some recovery points to reclaim some disk space.
Recovery points cannot be deleted by the GUI so you have to use P...how to create a memorandum
i need to know how to create a memorandum for my excel, but i need to do it
You can use Paste Special to link an Excel range into Word.
Microsoft Word MVP
"tamara" <firstname.lastname@example.org> wrote in message
>i need to know how to create a memorandum for my excel, but i need to do it
> in word.
...Access/Excel: Create multiple Lines/Column out of one mulit-line Column?
I spent a lot of time today searching for a response to my question but
I had unfortunately no success.
The problem is the following:
I have got an Access-table called Employee with an ID and one
corresponding Field/Column called comment. These comments are stupidly
multi-line (separated by a Return).
It's my aim to have access (he he, wordplay) to these two fields in
Excel whereas the field shouldn't be longer that 255 characters.
I considered three solutions:
The table could be changed after being exported to excel in the
following two ways:
- Multiple Comment Column...Programatically creating text box
Hi all..I need help regarding creating the edit box programatically..
I have drawn a movable rectangle in a view.Now how i want to make that
rectangle editable..can any body show me some pointer/sample code? I
was cocoa programmer. i know how to do this in mac os..but i dont know
how do i o it in MFC.. please help me
I took the source code for drawing from following link :
Thanks in advance
when you need it
and when you are done with it,
or if you want ...Creating array from matrix with blank values
I have a matrix in the following format
1 X X X X X X X X
X X X 3 X X X X X
4 X X X X X X X X
where 'X' is a blank cell.
I need to get the data in the form
Any suggestions? I tried a nested if statement but it doesn't work
since there are more than 7 ifs.
If there is only one value in each row, then simply using
where A1:L1 is your top row, then copied down for two more rows, will give you your desired result.
MS Excel MVP
<Andryll.Davis@gmail.com> wrote in message