I am "trying" to build a spreadsheet at work illustrating a gain/share
model that is triggered off of revenue & volume in work. Given that
information, here is one part of the spreadsheet I am having
For a plug number I have my current revenue set at 13,000,000. If i
was to receieve an additional 200,000 in work next year the following
year (13,200,000), that would make a revenue increase of 1.5% (VALUE #)
from the previous year. Based off of the the percentage of increase, I
would like to offer the customer a "discount" capped at a certain
perce...Problem using GetMenuItemInfo()
Using the following code I am unable to retrieve a menu item string:
info.cbSize = sizeof (MENUITEMINFO);
info.fMask = MIIM_STRING;
info.dwTypeData = NULL;
info.dwTypeData = new char[info.cch];
info.dwTypeData has an empty string at this point. Strangely, if
I leave out the NULL and the memory allocation it gives me the
string but, of course, crashes the program. Am I missing a step?
Why not use CMenu::GetMenuString?
"Ajay Kalra&quo...crop problem
A friend has publisher 2003 installed on two computers. On one of both,
there is no problem. On the other computer, there is a problem with the crop
tool: by using the crop tool, an image becomes disproportional. There are no
problems by using the crop tool in other programs (Microsoft Word, the
picture program that is installed together with publisher 2003,...).
I have re-installed publisher 2000 and with this version, there is no
problem on the same computer.
I have tested the crop tool in publisher 2003 on several other computers,
without any problem.
Conclusion: only publisher 200...Passport Sign-In Problem
All of a sudden, I'm not able to log into MS Money '03,
Passport says incorrect password! Nothing has changed, as
I'm able to log in through MSN's homepage without problems.
MS Money Support suggests to re-install application if all
else fails. Did so, and now backup file I'm trying to use
to restore files asks for password - Says incorrect
How do I rectify this problem and/or remove password
protection from the backup file?
Didn't see this problem previously raised, thanks for any
In microsoft.public.money, James wrote:
>...ON_NOTIFY message problem
Microsoft online document about ON_NOTIFY message does not help me so
I am hoping someone else can.
I have a dialog with 3 buttons control, instead of using OnClick()
function for each button, I want to map the WM_ONNOTIFY message to a
function in the parent dialog and use the wParam to determine which
button got the click so that I only use 1 function to handle 3
However, I never got any WM_ONNOTIFY message when click on any of the
buttons, even though that I select the "notify" property for each
I know that I am missing something, can someone help?
I m preparing invoice for my company which have multiple sheets like Customer
List and Pipe Size detail with rate of specific pipe.
I want to locate rate of specific pipe in Invoice. For this purpose I m
using vlookup function but when in that position second row is blank or same
then it returns #N/A.
I just want only want that it should be returned blank when row of Pipe
detail remain blank.
My worksheet have this type of data.
A B C D E F G
Description No. of Pipes (Qty in Mtr) Total Meter Rate Amount
1 063mm x 4Kg TKT 25 6 150 17.42 2613.00
2 075mm x 4Kg TRN 25 6 150 21.76 3264.00
Here i have two problems.
a) How can i load an xml schema in a treeview using C# 2005?
b) I am having the following problem when i try to read an xml schema using
"DataSet doesn't support 'union' or 'list' as simpleType."
If anyone have idea regarding these problems please let me know
Any code examples or reference materials will be helpful.
Thanks in Advance,
I made accde from my accdb database. But nothing is working in accde file (
no command button is responding).
Please help to resolve this problem.
Has the folder where your accde is located been defined to Access as a
If you're trying to run it using the "full" version of Access, click on the
Office button (upper left-hand corner), choose Access Options at the bottom
of the dialog, select Trust Center on the left hand side, Click on the Trust
Center Settings button, choose Trusted Locations on the left and click on
the Add n...Drop down box problem
Please can someone help me!!! I am trying to inset a drop down box int
an excel spreadsheet but haven't got a clue whether I use a list box o
a combo box. I want it to display first, second, third, fourth in th
drop down menu so that the user can sleect one of these. The thing is
don't know how to put the values in the box! Your help would be muc
Message posted from http://www.ExcelForum.com
use the Data / Validation - List option ...
click in the cell where you want the drop down, choose Data / Validation
from the menu, choose List, and in the source line ty...Summing the results of the VLOOKUP command
I am using the vlookup command several times to return values found in another worksheet. I would like to SUM the results of the vlookup command but since the values are not constants the SUM funtion is returning an error. How can I sum the results of the VLOOKUP command?
You should be able to sum (numeric) results of formulas, no matter what
What are the results of your lookups? What does your SUM formula look like?
What result did you expect? What did you get?
Microsoft MVP - Excel
"James" <email@example.com> wrote in message
ne...problem with Class wizard
I've just upgraded to Visual studio 2003 from VC6
Everything seems fine except for dialog boxes and Class Wizard
If I make a new dialog box, then double click on it - up comes the wizard
I give a name to the CPP and H files as normal and press Finish
But the code is NOT made, so I cannot do anything with the dialog
It worked fine with VC6.0
Does anyone know what may be happening here
Any help will be much appreciated
"phil" <firstname.lastname@example.org> wrote in message
> Does anyone know what may be happ...Re: Outlook Problems migrating to Office XP from Office 2000.-- Repost
I just upgraded to Office XP. Outlook, which I use only for tasks,
contacts and calendaring, not email, is not working properly or is working
differently in several respects from how Outlook 2000 worked. I use
Outlook Express as my default email client.
1. Outlook XP has somehow linked to my Groupwise email account. Whenever I
start Outlook XP, it immediately accesses the Groupwise server and imports
my GW email messages. If I delete the GW messages from Outlooks mail
client, they're deleted from the GW server.
Question: a. How do I unlink Outlook XP from my GW mail account?...Import problems
I am trying to import an Excel spreadsheet. The headers in the spreadsheet
match the same thing that is in my Access table, name and order. Everytime I
try to import, it gives me an error message. Is there something I am doing
there are a number of things that could be wrong.
What was the text on the error message?
Without knowing any more about the error, I suggest you try importing into a
new table and observe if you still get the error, or if the import is
successful. This can give a clue as to what the problem with the excel sheet
I hope you can help with the following:
I have to lookup a number in worksheet A within a range, "Range", i
the number is not available in the range, I want a "" in my cell. I
the number is available it should lookup the 18th cell. In the 18t
cell, I could have a date in there OR a words such as confirmed, route
e.t.c. If it is a date, it should provide me the date in my cell, i
it is anything other than confirmed, it should put a blank, if it i
confirmed, it should take cell m2+3 workdays. I have the followin
formula but I all blanks, something is not righ...Tasks problem
I dont know what its called in the english version, but
the function in "outlook shortcuts" on the left just
above "Noter" and below "kontaktpersoner" in the danish
version gives the opportunity to remind ones self of a
job that needs doing at some point and can be recurring.
I cant seem to find out why this function is repeating
its self and generating new reminders repeatedly every
week under the section "outlook today" together with all
Any help much appreciated
...Exchange update problem
I have tried to upgrade exch2k3 sp1 to sp2, but the update fails with "the
file pcproxy.dll is in use, and setup cannot identify the app or srvc. setup
Any clues/ideas/suggestions? Please.
This message has been checked for all known viruses.
The information contained in this e-mail and any attachments is confidential
and may be the subject of legal, professional or other privilege. It is
intended for the named addressee only and may not ...Union Query Problem
I'm using this UNION Query that worked fine untill I added the WHERE clause.
Any help is appreciated.
..RowSource = "SELECT tblPayName.PayNameID, tblPayName.PayName,
tblPayName.PayAppliedCOA, tblPayName.PayNameTypeID " & _
"FROM tblPayName " & _
"WHERE tblPayName.PayNameTypeID = 2 UNION " & _
"SELECT tblPayTypes.PayTypeID, tblPayTypes.PayTypeName,
tblPayTypes.PayTypeCOA " & _
"FROM tblPayTypes " & _
"ORDER By tblPayName.PayName;"
..ColumnCount = 4
..ColumnWidths = "0 in;2 ...vlookup in a chart
I am trying to create a chart which looks up a value and then depending on
this value uses a certain set of data to draw the chart. I know it can be
done, as I have seen it, but I am not sure what I need to do
Can you bee a little more specific?
Microsoft Excel MVP
"Lottie" <Lottie@discussions.microsoft.com> wrote in message
>I am trying to create a chart which looks up a value and then depending on
> this value uses a certain set of ...New User KBA problem
We have a new user in our CRM system who has rights to view and approve
Knowledge Base Articles, however, it seems he cannot view KBAs that were
CREATED before he was a member of the system. In the KB Manager, no "older"
KBAs are viewable in any section, but all KBAs created since his addition are
viewable. The User CAN see all KBAs in the Knowledge Base in the "Workplace"
area, but when he attempts to open an OLD one, he receives an error saying he
does not have privledges. However, the newer KBAs open just fine. Is this a
CRM quirk we are stuck with? Or is there a ...vlookup range
vlookup table array - QOH!R1C1:R844C5, is there a way to specify range as
QOH! xlright,xldown as the number of columns and rows can vary?
ActiveCell.FormulaR1C1 = _
Dim ws As Worksheet
Set ws = Worksheets("QOH")
LastRow = ws.Range("A1").End(xlDown).Row
LastCol = ws.Range("A1").End(xlToRight).Column
ActiveCell.FormulaR1C1 = _
"=IF(ISNA(VLOOKUP(C2,QOH!R1C1:R" & LastRow & ...Difficult Sorting problem
Have a spreadsheet with items.
A = Multiple Locations
B = item id (in each location)
C = Description
D = Qty on Hand (some have zero)
E thru J = has misc data
I am trying to sort by D - Highest qty on hand and bring all locations with
it - no matter what qty is showing.
A=location B=part number C=part description D=qty on hand
spread sheet has 11,000 lines
A B C D
100002 PC12345 tool for PC 2500
100003 PC12345 tool for PC 0
100004 PC12345 tool for PC 400
100005 PC12345 tool for PC 10
100002 PC54321 tool for pc2 ...if then statement with a vlookup?
I am trying to come up some code to search a workbook for numbers and
then put them in a column on the last page but if the number already exists,
do nothing. I need it to do this everytime I run the macro. Any ideas?
here is an example:
look for "day" if true then i want the number in column j on that page to go
to the last page in column k, but if the number is already there then do
nothing. if it is not there then the next cell down.
Does this make any sense? I think I confused myself.
Any help is appreciated
A little clarification ple...Delegate Access Problems
Recently one of our Exchange 5.5 servers failed and all mailboxes have had
to be restored from backups.
Since then I have had some problems with certain mailboxes. Now when I
click on the delegate access tab it says "The Delegates page is not
available. Unable to access Outlook folder". I do not understand this as
the mailbox is open and functional.
Can anyone offer any advice on how to resolve this issue?
...Password Problem in Pocket Money 2005
If I set the password in Pocket Money 2005, it doesn't ask me for it when I
open Money. This is because of the Pocket PC tendency to keep most apps
running once they are started, even if the user closes them. Any way to deal
with this issue?
The 'x' is equivalent to minimize on the desktop. To actually close it you
have to go into Settings->System->Memory->Running Programs. Since that is a
pain I suggest Wisbar which is a free Today screen that will allow you to
easily "close" running programs like Pocket Money.
"Mel" wrot...% fraction problem
I've looked and searched and cannot find the formula to the following
I have a value to which a % has been deducted
I need the formula to put that value back
i.e. the fraction formula
If 17.5% has been removed from a value and the remained is � 2.00
whats the formula to find the deducted amount from the gross figure
Obviously to add 17.5% back on would not work
I need this formula for various %'s
New Value = Original Value - Original Value x Percent
New Value = Original Value x (1 - Percent)
solve for original value,