HELP! Adding Account Features in Money
Any Money users here? I had been using Quicken for ten
years and it does not have a feature to add a VUL
(insurance) policy where I have "investments" to track in
the policy. Does Money have that feature? Please help. I
am considering in switching to Money if it does.
In microsoft.public.money, Adelfa wrote:
>Any Money users here? I had been using Quicken for ten
>years and it does not have a feature to add a VUL
>(insurance) policy where I have "investments" to track in
>the policy. Does Money have that feature? Please help. I
>am cons...Help with using data
I would really appreciate some help with extracting data from
Outlook. I have been building up a database of clients/prospectives,
these are in various categories. I would like to extract/search on
various fields as well as my own categories, all i can do with export
is extract the whole lot to a tab delimited file. Or export categories
to an rge file which I can't use.
Any ideas out there?
Outlook's Search doesn't suffice?
There are 3rd party search applications that might help.
What sprcifically stops you from exporting to a format other than TSV? There
are other...Help with simple arithmetic
i have the following declaration and piece of code
Dim netProfit As Long
netProfit = (7364 - 2298) * 20
Why does it fail with "runtime error 6" Overflow.
the result should be 101320, should be okay for Long right ?
Any help appreciated.
Message posted from http://www.ExcelForum.com/
The right hand side involves only integers, so it evaluates as an
integer expression (which overflows). The final result (if it hadn't
overflowed) would then be coerced to long.
To perform the multiplication as a long instead of an integer, at least
one of the numbers must be ...GDI Help Please
Windows ME, HP 970CXI Printer, Publisher 2000
Keep getting the following error message when I try to
print from Publisher:
Mspub has caused an error in GDI.EXE.
MSpub will now close.
If you continue to experience problems, try restarting
I just installed the latest driver that I received from
HP,and I keep getting this problem. It's getting very
fustrating. Can anyone help?
Update your video driver and your problems should be over.
Next time buy a quality brand of printer, not a lemon brand.
The US should free all those
illegally held prisoners they are
tortu...Macro Help Please excel 2003
I need a button so that when pressed it exports the data from the cell range
sheet 1: A21:S81, it also exports the info from the same range A21:S81 on
sheet 2 to an external excel workbook.
I need it to export all the data onto sheet 1 of the external workbook, and
each time the button is pressed it needs to find the first available row of
the external workbook and copy over, this is so that all data is always saved
on a massive long list.
Neil. let us stick on to the original post. I have posted a response for your
"Neil H...Option Buttons Help
I hope I can explain my problem if you need further details please advise:
I have 6 Option Buttons (Form Control) on a worksheet, when I click
(Checked) any of them the rest automatically unchecked themselves, how can I
modify them, since I want to create two groups of 3 Option Button on each
group so if I click (checked) any of the Option Button in a group of 3 it
does not unchecked any of the Option Buttons on the other group of 3?
Thanks in Advance
Put each group into its own groupbox (also on that Forms toolbar).
> I hope I can explain my problem if you n...How do I name categories of a pie chart
I am creating a pie chart of numeric values. I would like to add the names
of each category. I don't seem to be able to find out exactly how to do it.
Right click within the chart, select "Format Data Series..." Go to "Data
Labels" tab. Select "Series Name" or "Category Name"
> I am creating a pie chart of numeric values. I would like to add the names
> of each category. I don't seem to be able to find out exactly how to do it.
...Need Advise for Two Email Domains
We currently receive email to our domain "abc.com" and want to eventually
switch over to another domain we own, "xyz.net." For about three months, we
want to receive email to both domains until our members get used to the new
I added an MX and Host A record in our DNS server and we get email
internally to the new "xyz.net" address. I contacted our ISP that hosts our
website and had them create a new MX record with the new domain there, but we
still cannot get email sent to the "xyz.net" address that is sent from the
Ca...Run-time error 438
I'm trying to find out why this code is not working.
With Worksheets("Multi-period Code data").ListBox1
For FillCount = 1 To Worksheets("ClassCodes").Range("E1")
.ListIndex = Worksheets("Multi-period Code data").Range("O1").Value
Just to clarify, there is a sheet named "Multi-period Code data" and
ListBox1 exists on the sheet. The err...Outlook 2003 suddenly can't use Word as Editor any more ...
.... there was no other install etc. in the meantime but Outlook 2003 just
started refusing using Word as it's editor ...
Word is unavailable. An OLE registration error occured.
Does somebody know what's on and what helps ? I've de-installed Office 2003
and reinstalled it but had the same error again ... If I can't use it I'm
kind of busted bcause I have a lot of macros which only worked in Word while
used as e-mail editor but not when just tried to use in Word itself ...
don't know why that again didn't work but anyways ...
Who knows how to get Word run as...Real Programmers (TM) use MSFT C# not Linux languages (sez an expert)
Don't take my word for it, see what this nationally syndicated author
and computer programming guru says... and note the reader's comment at
the very end...about Linux...I think he's talking about Linux.
Anyway the takeaway executive summary of this article is simple: C#
How Microsoft is changing the programming world
Posted on Jun 23rd, 2010 in .NET, Programming Languages | 47 comments
Several years ago I knew a programmer, we=92ll call him Joe, who fancied
himsel...MSCRM API failing with User defined fields.Help !
Iam programming in ASP.NET for my company's MSCRM. I use MSAPI to retrieve
and update field values in MSCRM. Iam able to do it with ease by programming
in VB.NET with the MSCRM object library.
strUpdateXml = "<account><name>Steve
CRMAccount.Update(UserAuth, RECID, strUpdateXml)
It works fine for the normal MSCRM fields
LATER, I created USERDEFINED fields in MSCRM. ( with the Deployment Manager
and published). The new field created can been seen in...Need help editing budget
In many catagories of my budget, the budgeted amount
includes a billed amount rather than only what I
budgeted. When I go to edit budget, I highlight the area
I want to change and a copy of the reoccuring bill shows
up. What am I doing wrong?
...How do you point to a named range in linked workbooks?
Workbook #1 has a range named "Gross Sales" in Sheet1 Cells A2:K2. How can I
point to this range so that I can link it to Sheet1 Cells2:K2 in Workbook #2?
Is this what you're looking for...?
In workbook 2 enter "=[Book1]Sheet1!$A$2" in cell A2. Do the same for cells
B2 through K2 with the correct respective links.
Hope this helps.
> Workbook #1 has a range named "Gross Sales" in Sheet1 Cells A2:K2. How can I
> point to this range so that I can link it to Sheet1 Cells2:K2 in Workbook #2?
Or, if you don't like to ...DataSet Question-Please Help
I need to compare the count of an amount of matches in one column to a match
of a dataset in 2 columns- An example is best:
Column 1 Column 2 Result
2 1 1
2 1 1
2 1 1
2 1 1
3 4 blank
3 5 blank
So in looking at column 1 and 2 if the count of column 1 equals the count of
column 1 and 2 matching then the new column equals co...help with lookup formula (SHEET 1 attatched)
I need to make a formula using a lookup. The first spreadsheet is a
inventory (ALO INVENTORY JP). The second (P&G 103) is a chart tha
tells number of gallons of alcohol per foot/inch/fraction.
On ALO INVENTORY JP I insert the # of feet, inches, and the fraction i
cells R5 and T5. I want these numbers to lookup the number of gallon
off of the P&G 103 worksheet.
For example: P&G 103 (on inventory sheet) is 26ft 4 1/2 inches, i
should look-up to be 34572 gal. for the 26'4" and 55 gal. for the 1/2"
These two numbers should be added together and multiplied by the numbe
...need help managing volume size
I use an array for automated daily backup,
I have set up three folders on the array A,B, C.
The array stops accepting data after it reaches a certain level so
backups are not executed until I notice and take action.
I also wish to keep the size of each folder at a certain level.
Right now I am merging files across the array initially loading files
into the first folder (A) than moving to the next (B), then the last
(C), then purging from the last folder (C) using a program called
delinda which uses the files' creation date as the trigger for merging
and purging....API TO get User Name
What is an Win32 call to get the user name in the form of COMPUTER\\User ?
>What is an Win32 call to get the user name in the form of COMPUTER\\User ?
Have a look at GetUserNameEx NameSamCompatible
Yes, just as David provided, GetUserNameEx will help you to retrieve the
user or other security principal associated with the calling thread.
If you got a different token other than the current calling thread, you may
first call ImpersonateLoggedOnUser by passing the token to impersonate the
token in the current thread and then use GetUserNameEx to obtain the user ...Outlook 2003 error when trying to use WordMail
Outlook 2003 has recently started reporting the following error, when trying
to use Word 2003 as the MAil Editor. I have tried all the uslal things
including Uninstalling Office, clearing the main registry settings and re
installing, but nothing seems to work, does anyone have any idea what is
causing this and more importantly how to solve it:
"Word is unavailable, not installed, or is not the same version as outlook.
The outlook email word editor will be used instead. an OLE registration
error occured. The program is not correctly installed run Setup program
Gavin,...Query--using Access 2007
I have a tblAddress table with a lookup field called TypeofAddressID.
A company may have many addresses with different TypeofAddressID—such as 1 =
Business, 2 = Mailstop, 3 = PO Box, and so on.
I need to pull out TypeofAddressID # 1. Then if a 1 is not available, give
me the type that is (which may be the PO address or Mailstop).
I tried DLookup, Xor, and IIf([TypeofAddressID]=1, 1, IIf([TypeofAddressID]=2,
2, IIf([TypeofAddressID]=3, 3, 4))), but it is listing all addresses per
company instead of either or.
Message posted via http://www.accessmonster....please can you tell me how to use the "if" function (new user)
i am trying to teach myself Excel plaese can you tell me good tutorial and i
would like to know how to use the " if " function
> i am trying to teach myself Excel plaese can you tell me good tutorial and i
> would like to know how to use the " if " function
Just open Help in Excel and type in IF statement. Microsoft has
an Excel helper also. Good for the basics.
> i am trying to teach myself Excel plaese can you tell
> me good tutorial and i woul...An error occured and this feature is no longer functioning properly. help!
This is what I get when saving my workbook. also it offers install some
soft to repair the "feature". A runtime error happens when installing.
I don't understand what feature is it about.
Before that I made a copy of this book in csv format (when saving as
csv, I also got a message that some features will not be compatible
with csv format and I agreed because I guessed it was about a command
button in the worksheet). When I opened xls book next time and tried to
save it, it gave me the subj message, but saved after all in the end. I
wonder if it is likely to cause me problems i...Change Name of Command Button
How can I change the name of a command button to text entered in cell
comotoman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27292
View this thread: http://www.excelforum.com/showthread.php?threadid=477556
highlight the cell
right click commandbutton while in design mode
now edit -pastespecial
toggle design mode
"comotoman" <firstname.lastname@example.org&g...HELP WITH A MAIL MERGE
...Payee name field too small
When downloading transactions from my PNC Bank account, all check card
purchases appear as, "CHECK CARD PURCHASE XXXXXXXX1583". Obviously the
purchase amount appears as well however, unless I go to the banks website and
pull up my statement, there is no way for me to know who the actual Payee is.
Is there a way to make Money 2005 IGNORE these first 32 characters when
reading the downloaded transactions? That way I would be able to set up a
more efficient and accurate Payee list & Rules Manager without having to go
to the web and look up each individual transaction.