Recent Update that causes Stack Overflow from too many xml levels
I read recently that that one of the updates (feb 2005?) caused stack
overflows if you had too many xml levels. Since I use .net/xml/xslt I was
mildly interested, however, since I had not experienced the problem, I did
I now have the problem where code that has been running is giving stack
overflows that was previously working with the same xml levels. The article
said that MS had a patch.
I can now not find the article, a reference to a patch, etc.
Any help would be appreciated,
...Simple problem from a simple man
Hi,I have a table which records several different scores for eachrecord / entry. Is there a way that the report based on the query , inturn based on the table, will show the scores below a certain level ina different coloured font?Cheers,TC...Simple CComboBox question
I have a combobox with some info the user can choose.
But how can i make sure the user is only able to chose my predefined
information, and is not able to edit the chosen value in the combobox.
My problem now is that the user can erase the selected value, i want
to make sure he can't edit the edit field of the combobox.
Make the style "drop list" and the control is no longer editable.
On 3 Sep 2004 08:20:05 -0700, firstname.lastname@example.org (Tim) wrote:
>I have a combobox with some info the user can choose.
>But how can i make sure the user is only able to chos...Simple Hyperlink Macro
Hi. I am using MS Excel 2003, and I am very new to the program. I don't know
how to use visual basic or programming of any kind. I need help with a
macro, and I'm hoping this is the best place to ask for help.
I have a worksheet entitled "NT." In column "A" I have a very long list of
vocabulary words (not alphabetized). For reasons I won't bother you with, I
want to establish hyperlinks for each of these words (column A) in another
worksheet entitled "LINKS" (also in column A). Thus, when I click on the
hyperlink for a word in LINKS, I will...How to insert a separater between the Menu and the Propertysheet
I make the dialog-based program that has property sheet.
The program has a menu too.
I want to insert a separater between the menu and the property sheet like
Tell me how can I implement that.
Thanks in advance.
Try adding the DS_3DLOOK style to the Dialog.
Check Abdoul [VC++ MVP]
"Brian Lee" <email@example.com> wrote in message
> I make the dialog-based program that has property sheet.
> The program has a menu too.
> I want to insert a sep...Inserting text closing or begining salutations in Office 2007
I am starting to get to grips with Office 2007.
I like the program and it's changes, but I am struggling to find some of the
items I used to use in the previous version.
For instance, how do I add closing and opening salutations such as "yours
sincerily" or "dear sir" etc that we used to be able to do in the version
I have looked, but can't sem to find it anywhere.
I appreciate any help or pointers with this.
...insert text to different pages and update
Is there a way to insert a text cell from one page put into another page
and when the first page cell is updated the second page cell will also
be updated. Using the = sign just displays the formula, not the text.
fwburkey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30314
View this thread: http://www.excelforum.com/showthread.php?threadid=505331
Not clear what you are doing wrong. the formula should look lik
=Sheet1!A1 Make sure there is noth...Simple Calculation
I would love some help with adding a simple calculation to a custom field.
We would like to display Work Variance as a percentage. I have made a custom
field (tried with a task and project entities) with the formula [work] /
[baseline work] and the field comes up with "#ERROR". If I hit F9 to
calculate, each row says "42134". Thank you so much for your help! This
discussion board has been very helpful!
You are using the wrong formula. Assuming you are using a Number field, the
simplest version of this formula is:
[Work Va...For graphs how do i put a line of best fit?
I have an assignment that saYS I CAN PUT A LINE OF BEST FIT FOR MY GRAPH
AUTOMATICALLY BUT I HAVE NO CLUE HOW TO
Plot a line graph. Right-click anywhere on the line > Choose "Add TrendLine"
then make the options in the dialog ..
> I have an assignment that saYS I CAN PUT A LINE OF BEST FIT FOR MY GRAPH
> AUTOMATICALLY BUT I HAVE NO CLUE HOW TO
Fri, 20 Apr 2007 20:16:02 -0700 from watevva
> I have an assignment that saYS I CAN PUT...Simple Macro is not so simple
I am trying to record a macro which will automatically perform the insert >
comment function to a selected cell. Should be easy right? Alas no
There's sample code on my web site, for inserting comments:
> Hi all,
> I am trying to record a macro which will automatically perform the insert >
> comment function to a selected cell. Should be easy right? Alas no
Excel FAQ, Tips & Book List
Wow! Nice one :-)
Thank you M...Problem adding a vertical line to a graph with months on x-axis
I'm trying to add a vertical line that would indicate the current
month, i.e. May 2007, to a graph with a Line and a Stacked Area, and
months (e.g. January 2004 through December 2007) instead of days on
the x-axis. I've tried different variations of
success. Any suggestions?
What isn't working?
Is your X axis a time-scale axis? You need to use the corresponding date as
the X values of the XY series that controls the vertical line. In the
time-scale axis, is your Base Unit days? Then you can use the date you wa...Purchase Order
Prior to GP 7.5, there was an option to delete a line in the PO after it has
been printed and when there hasn't been any transactions that had been
executed. However, after GP 7.5 and 8.0, this option is no longer available.
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 mes...(Error 1004) Object Defined Error ...simple code
I have the following simple simple code:
Dim s as String
s = WeekdayName(1) ' Causes Error 1004
Why would the above call to "WeekdayName(1)" suddenly
cause an Object Defined Error?? My program has been working
nicely for awhile, but now all of a sudden it halts at the above line???
What the heck is going on???
It works fine for me. However, checking out Help, the first day of week
parameter is supposed to default to Sunday (or 1) as the first day of the
week but it appears to default to zero.
Tested in xl2002 and x...Validating XML with XSD's
I have written a small app that uses the XmlValidationReader and a customer
ValidationEventHandler function. When I validate the XML I get detail
structured information like child is not defined or structure is invalid but
now I am getting into facets. I am working with data lengths and I have
found that I get the following message when a value is the incorrect length:
"The 'elementname' element has an invalid value according to its data type.
The real error is that the data value is longer than allowed. In XML Spy I
receive the follwing error for this scenario: "Value Doe...Error when making any insert or update to crm data
When a client of ours attempts to create a new (activity, account or
contact) an error is recieved. "An error has occured please contact your
This same error is also recieved when modifing existing (activity, account
or contact) records.
Only problem is that is inconsistent. They can go without having the issue
at all one day (able to modify and create records) but the next they get it a
few times, another day they can get it every second time.
Weird, but hoping there are others out there that have run into this type of
thing and are able to ...HELP with an INSERT INTO statement
I received the response below for a previous question. I understand the
logic behind the reply, and I am sure it will work. I can't, however, figure
out what I should be substituting for '2345' in the "SELECT '2345' AS" part
of the solution below?
I'm getting very close to running out of time and would greatly appreciate
> Use an append query. Probably you'll need to write VBA code to
> assemble and execute the necessary SQL statement, which could look
> something like this:
...Get the range of XML Mapping?
I am programmatically import XML data into an Excel file. Is there a
way to know the range of the XML mapping in the excel? I want to
format that range, such as adding the border lines. Or is there a way
to format the range automatically? The problem is that the XML data
may change and the range of the XML mapping varies accordingly.
I have a chart with zip codes and a population rate.
I want to make a chart that has the rate on the x axis and the number
of times that rate occurs on the y axis.
I will assume the ZIP and RATE stuff is in A1:B200 (labels in row 1)
Label in G1 to read RATE (but leave it empty for now), label in H2 to read
Make a list of rates in G2:G20 (say)
In H2 =COUNTIF($B$2:$B$200,G2)
Copy down the row
Select H1:G20 and make a...Mapping a CSV file to an Xml Schema
I am getting a CSV file like this from our client:
I need to validate **each filed value** against a set of rules ,for instance
for "05/07/1976" ,I need to make sure that it's in the right format ,It's
not later than today and lots of other rules ,Is there somebody who can help
me how to that?Can I map it to some sort of xml schema or something?
Thanks for your help.
"Ali-R" <AliR@microsft.com> wrote in messa...simple drag & drop not working
If I start dragging, I always get the "DropEffect - None" icon, means
that drop is not possible.
In my CFormView::OnCreate I already did a dropTarget.Register(this).
void Simulation::OnLButtonDown(UINT nFlags, CPoint point)
COleDataSource* ds=new COleDataSource();
CArchive ar(&file, CArchive::store);
file.Detach());...Hopefully Simple VBA questions
Using VBA, I want to go row-by-row and get the values from certain cell
in each row so I can run some tests on them, then put the result of th
tests back in certain cells.
This is how I am set up so far, can you help me with my questions i
Dim i As Long, c1 As Long, c2 As Long
c1 = 0
c2 = 0
For i = 1 To 120 (HOW DO I MAKE THIS DYNAMIC TO INCLUDE NEW ROW
AS THEY ARE ADDED?)
If Cells(i, 2).Value Then 'start flag is true (HOW DO I MAK
VBA GO TO A DIFFERENT WORKSHEET WITH THE Cells(I,2).Value STATEMENT?
If Cells(i, 1).Value = "E" Then
c1 = c1 + 1
E...Simple Simple Simple
Just started Excel (again) and need to make an easy speadsheet fo
calculating square inches.
Column A: Height
Column B: Legnth
Column C: Total Tags per 16 x 24
Column D: Cost per tag
Figures I know: each sheet cost me $9.98. each sheet is 16 x 24 inches
What I want to do is enter the Height, enter the Length and have th
total (sum) be entered into columns C and D.
I can't believe I forgot how to enter formulas. Any help will b
Message posted from http://www.ExcelForum.com
One Way, might be better ways but this'll work:
List the colou...print Grid Lines
when i try to print grid lines they dont print, i have
tried to look at "format cell" then boarders and selected
inside with a solid black line. i have also checked
the "page setup" and the "sheet tab" and chedked "grid
lines" but i still cannot print grid lines. will some one
please help me.
>when i try to print grid lines they dont print, i have
>tried to look at "format cell" then boarders and
>inside with a solid black line. i have also checked
>the "page setup" and th...How do I get the data/xml/export option
My export option is disabled under data/xml tab. What is the exact feature I
need to install to get this export xml option. I didn't install all the
option during excel installation. Which specific install tab are required
during excel installation?
One way would be to do a web query, first preformat the cells as text, then
do the query (data>import external data>new web query), put in the web site
address, select the part you want to import, under properties select
preserve cell formatting and do the import
(No private emails pleas...Blue and pink guide line query
In Publisher 2002/XP I know that the pink dotted lines on a page are the
margins but please can somebody explain what the blue dotted lines just
inside are? Thanks
> In Publisher 2002/XP I know that the pink dotted lines on a page are the
> margins but please can somebody explain what the blue dotted lines just
> inside are? Thanks
The purple lines are margin guides - they bear no relation to your
printer's margins, unless you tell them to.
The blue lines inside are a second set of guides. If you set your margin
guides to your printer's printable margins, ...