I've set up a watch account to use as a model for an investing strategy I'd
like to try. In doing so, I want to be able to track theoretical purchases
and sales of individual stocks. I want to track sales and realized gains on
my Account Summary window, so I've customized my view to do that. After
entering a purchase, the stock shows up just fine on my account summary, but
after I sell all shares, it no longer shows up so I'm not able to track
realized gains. How can I get Money to continue to display the stocks I no
longer "own" in my watch account?
a w...Problems with creating a newsletter
I chose the form "Newsletter - email".
I have created a 3 page newsletter. Now, I have NO IDEA how to send it out
as an email. I do not want to send it as an attachment. I cannot figure out
which "save as" format or what I need to do so that i can email this
newsletter. Is there a website that goes through how to do this?
Am I correct when I say that it has to be html in order for me to send it as
email? That is not one of the options.
Any help you give me would be greatly appreciated.
...CSV File Problem
Can any one explain why the following problem occurs please?
A colleague has a small list of data which is a csv file exported from SQL.
Column One is a serial number from 1 to 29.
Column 2 is a number of transactions which have occurred.(it should look
like example A below in Excel)
1 475 1,475
2 1732 21,732
3 1670 31,670
4 2176 42,176
5 608 5,608
6 1579 61,579
7 43101 743,101
8 54512 854,512
9 51258 951,258
10 61050 1,061,050
If I double click on the csv file, it opens in Excel but c...Customize Current View: Filter Problem
Using Outlook 2002, I have created a category called "Hidden" i
outlook. In my calendar, I put all the appointments I don't want t
appear in this calendar (i.e. daily reminders).
I then filter out all these "Hidden" items by selecting --
Customize Current View-->
Hidden (the category I created)-->
Edit these criteria directly-->
And then I change:
("DAV:isfolder" = false AND "DAV:ishidden" = false) AN
("urn:schemas-microsoft...Problems migrating BCM data into CRM SB edition
I am having a problem migrating data from Business Contacts Manager (BCM)
into CRM 3.0 Small Business edition.
I have downloaded the BCM data migration pack and have followed the data
migration documentation to the letter.
I even cleaned up the BCM database prior to copying the files, checking them
for errors using the Manage Database option in the Business Tools menu.
It gets so far through the migration process and then bombs out.
Here is the final few entries from the log file:
28/10/2006 12:18:53------>Transitioning to next screen. From:
ConfigurationSummary screen. To: ...Month problem
I have some code where I calculate this month minus 2 month. This goes fine
until I get to august. When I use DateSerial to deduct 2 month I get to July,
and this makes no sence. I made the following testcode.
Dim MyDate As Date
MyDate = #8/31/2010#
MsgBox DatePart("m", DateSerial(Year(MyDate), _
Month(MyDate) - 1, Day(MyDate))) ' MsgBox = 7
MsgBox DatePart("m", DateSerial(Year(MyDate), _
Month(MyDate) - 2, Day(MyDate))) ' MsgBox = 7
MsgBox DatePart(&qu...Send to certain person using specific email account
I send an email to a certain receipient but don't want to use the
default email account.
Is it possible that when I send to them (plain text) , that it will
choose the other account I want to use to send it? Please advise how I
set this up.
I do not believe that this can be achieved automatically through standard
use of Outlook as you need to manually specify the name of the account to
send from if different than the default.
However, it would be possible using the Outlook object model. An Addin would
need to be developed that monitored each mail item prior to sending. If the
I am using the following formula:
Where BH24 = 15:21, BG24 = 15:00 (times based on a 24 hour clock)
The answer returned is 0.3, but it should be 0.4. If you round out to 2
places the answer is 0.35. Unless I am missing something 0.35 should round
to 0.4. If I use Roundup, it rounds everything up. What am I missing?
this is due to Excel's representation of numbers (see:
In your case the formula
=(BH24-BG24)*24 does not return 0.35 but
(Just test it and format the resulting cell with enough decima...Access 2007 and Vista code problem
I am developing a database on a XP SP2 machine. On a form I have created
some buttons with event procedures that run 2 queries and open a form. I
sent the db to someone running Access 2007 on a Vista machine and nothing
happens when she clicks the buttons and there are no messages.
I know nothing about Vista so thanks in advance for any help.
Might be a reference problem, have them open the open a code window and
click tools references. See what says missing and tell them what should be
there, Add it and it should work. Duff
"Tim Reid" <TimReid@discussions.micr...Resolving Email Address to existing contact problem
Has anyone else come across this issue in MSCRM3.0? - when you attempt to
resolve an email address to an existing contact in CRM (that does not
currently have an email address stored in their details) the contact resolves
OK but does not update the email address in the contacts details.
Is this by design, or have I found a bug?
...Offline folder problems #2
Basically I installed Outlook 97 on my office PC which is
connect to microsoft exchange server.
For some reason all of my messages were copied into
offline folders, this causes a problem, whenever I open up
outlook I get this message.
Upload of offline changes could not be completed you do
not have sufficient permission to perform this operation
on this object. See the folder contact or see your system
I do not administrator access on my user profile, every
time I open outlook it resets everything I have changed
(view etc) and gives that error message. How ...Transferring control of CClientDC to CDC
I have a class MSWinDisplayManager which I want to take a CClientDC
context so that it's member functions can perform drawing routines on
I want the class to have it's own CClientDC member which all the
have access to draw on. My constructor looks like this:
This is called by the user like:
then I want to do things like:
The problem I have is that private_win isn't getting control of the
device ...Converting Opportunity to Account
How do I convert an Opportunity to a Account? Thanks
This is not possible, opportunities are opportunities for existing
accounts/contacts. This is why when you convert a Lead to an Opportunity you
must select the potential customer also.
> How do I convert an Opportunity to a Account? Thanks
how would I select a potential customer? does this mean I have to create an
account for them as well? it wouldnt make sense since they may not ending up
being an account. thoughts?
"Dan Quinton" wrote:
> This is not possible, opportunities...OLK 2k7
Outlook is behaving strangly with the "through the selected account"
Each time I restart Outlook the rule fails. When I go in to check on the
rules I get told that the rule is "invalid". and the "SELECTED" account
is no longer selected.
Each time the criteria the account needs to be selected by changes.
For example with the following data
Account Name Email Account
One time I go in and it's asking me to select the account ...Setting up a new e-mail account
I'm trying to set up my yahoo account so that I receive
my e-mail messages in my Outlook Inbox. I went to
Accounts, and servers, and put in mail.yahoo.com for
incoming mail (POP3) and smtp.yahoo.com for outgoing mail
(smtp). When I click on the send/receive button I get an
Dave <firstname.lastname@example.org> wrote:
> I'm trying to set up my yahoo account so that I receive
> my e-mail messages in my Outlook Inbox. I went to
> Accounts, and servers, and put in mail.yahoo.com for
> incoming mail (POP3) and smtp.yahoo.com for outgoing mail
&...outlook 2k2 problem
I am using Outlook 2002 with SP3, and i have not had any problems up
until a week ago. My password does not seem to save even though i have typed
it in correctly in the e-mail acct settings ,and have checked "save
password. It saves it as long as i have Outlook open, but as soon as i close
it, and then later open it again, my password is gone and Outlook asks me
for my e-mail password. So, i re-type and i check "save password". But if i
decide to close Outlook (say for the evening, and shut down my computer or
something), my password disappears the next time i open Outlo...Office 2003 Service Pack 3--subsequent problems opening Publisher
I run Publisher 2003 on Windows XP. On June 13, I updated my system with
Office 2003 Service Pack 3 so that I could open Word documents with the file
ext docx. Subsequent to the Service Pack 3 installation, whenever I open a
Publisher file (which I created), I get the following message: "Publisher has
detected a problem in the file you are trying to open. If you are certain
that this file came from a trusted source and does not contain harmful
information, click OK." What is causing this and is there a way to stop this
Error message when you...Archiving Projects in Project Accounting
Has anyone found a way to archive closed projects?
...Budget Wont Save
I have have Money 2002 for awhile and have never been
able to save a budget and start a new one. I decided to
start over with a new file, but once I get all my info
back in there, it still won't save. MS has no info in
the KB about this. Anyone else have this issue?
...Hyperlink problem #3
I've got two workbooks on a shared drive with hyperlinks
linking the two. When a user clicks on the hyperlink on
the first workbook, it takes him to the second workbook.
Fine. However, when the user clicks on the hyperlink in
the second workbook to go back to the first, the error
message says that that workbook is already open and it
cannot open two files with the same name. Help is
I just tried a small test in xl2002 and it worked ok for me. I use
Insert|Hyperlink to create the links.
Are you sure that the hyperlinks point at the file you want--same folder and
e...Associating Multiple Existing Contacts to an Account, Until CRM 2.x
I have racked my pea-sized brain for endless days for a way to associate
multiple existing contacts (or accounts) to an account.
My client has accounts that have many contacts (or accounts) involved at
different stages of acquiring a new account.
The logical method would be to add a custom attribute with lookup
functionality into the existing CRM contact or account objects but this is
not possible with CRM 1.x.
The resulting UI would allow an end user to associate different contacts (or
accounts) to an account. Example:
- AccountPhysician: (existing account or con...Mother of a sumproduct (ish) problem!
At least it is to me - now I humbly beseech your magic :)
A1 to A10 contain 10 unique letters, e.g. A,Q,E...
B1 to B10 contain 10 unique letters, e.g. Z,B,A...
C1 to C100 contain nonunique letters, e.g. E,E,F,E,Q,Q...
D1 to D100 contain nonunique letters, e.g. A,T,F,A,X,B...
E1 to E100 contain values, e.g. 9,1,3,5,7,2...
In pseudo logic, for x = 1 to 10 I want to find each Ax:Bx pairing in
Cy:Dy and sum E when matched. So I want to sum Ey for the rows where [Cy
is "A" and Dy is "Z"], plus each Ey where [Cy="Q" and Dy="B"], etc. for
the sample...Money 2000 Account Balance Changed Inexplicably
Opening Money 2000, which I've used without problem since late 1999, I
noticed that my checking account balance was overstated by almost $2000! I
went to the register to see if there was a false transaction entered and it
appears that this balance change goes back years with no obvious single entry
being the culprit. When I run the "balance this account" function, it shows
that the closing balance from my last statement, which was correct and
rectified, is now also wrong and reflects the higher balance. What do I do
now? The only thing that I can think of is to restore...Spam is a big big problem
Spam is a big big problem
...I want to add a mail account without setting a SMTP server. Is it possible?
I want to add a second mail account that is outside my company.
Since the company firewall does not allow us to connect to SMTP-servers I
to add this account without setting the SMTP propertiy.
I cannot specify the company server as it is an Exchange server and the
outside one an IMAP one.
Currently I have specified the outside SMTP server since outook does not
allow me to add an account wihtout setting this.
I keep getting annoying error messages as my computer can't connect to the
Any one know a way around this?
The company server has SMTP enabled, u...