Populating objects from XML file
Hello, I have an XML file that contains parent / child relations
There is a Manager who can have one to many employees and these
employees can have one to many phone numbers.
I would like to know the best way to retrieve this information from
the XML file and store into business objects.
I have the following idea which would work
1) Load the XML file into a DataSet (After validating against a
schema) and then use the relationships defined in the schema to match
objects between datatables
Is there a better / way to do this?
Adam w...Graph with text
I have a status field "Open, Working, On-Hold, or Done" and a second column
for project name. I want to create a chart that shows the project name on
the x-axis and the status on the Y axis. THIS IS A SECOND REQUEST, please
You need to convert the status to a numerical scale (1,2,3,4), plot
X=project vs Y=numerical status, and finally fix up the vertical axis:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
DDBe...Select All Pictures and Change Wrapping Style to Behind Text
I am trying to get a macro that can change the wrapping style to behind text
for all the pictures in the document. It would also be great if I could get
this macro to change a lot of other properties too. For example, I want all
the photos behind text, center horizontal alignment, height = 4", width =
proportional. It would also be great if this macro could add a text box
under each picture which was grouped with its respective picture. Any advice
on any of this would be greatly appreciated.
Funny you should ask this now. I was just fighting with the same problem
yeste...How do I arch a line of text within a banner?
I am trying to design a banner that will have two lines of text. Rather than
both lines being straight, I would like to arch the top line over the second
line so that I can insert artwork between the two lines of text. Can this be
accomplished with this program? If not, is there a program available the I
could use instead.
> I am trying to design a banner that will have two lines of text.
> Rather than both lines being straight, I would like to arch the top
> line over the second line so that I can insert artwork between the
> two...Why doesn't the text fit its self around my graphics?
I'm using Publisher 2003. I've inserted a clipart but the text goes under
the graphic. I want the text to flow around the graphic.
PLEASE help me get the text to flow around my graphic.
I've used Pub 2000 and haven't run into this problem....can't find anything
to fix this!
Thanks in advance!!!
Using Pub 2000 here also Kelvin,
Give this a try.
Put the clipart on top layer. Use the icons in the tool bar that look like
three little squares. One sends the active text or image box to the back and
the other brings them to the front.
Vancou...How to Delete or Edit System Views
i have several sytem (i.e.public) views in our CRM 3.0c installation that I
need to either delete or modify. I (as admin) cannot do either. These are
not the Default system-defined views, but views that were created after the
initial installtion. We upgraded from CRM 2 to 3 and these may have
initially been created in CRM 2.
Does anyone know how I can make them editable again?
...Text to Columns
500+ sentences, I need to seperate (text to columns) after the first "-"
only. There are subsequent "-" but I only want it seperated at the first.
And when I seperate it in the second column I do not want a space preceeding
the text. Can you give advice on this, any help would be much appreciated!
AIR TAXI - An aircraft operator who conducts operations for hire or
compensation in accordance with FAR Part 135 in an aircraft with 30 or fewer
passenger seats and a payload capacity of 7,500# or less. An air taxi
operates on an on-dem...I can not copy text into a brochure without another textbox opening
Every time I try to copy and past into a textbox already created by a
publisher template, another textbox is created by defalut to add the text
into it. I want to just add the text into the textbox already within the
template like you could with Publisher 2000.
Is your cursor inside the textbox when you paste? If you just paste Publisher will
create a new text box. If this isn't the answer create a new textbox, paste and
delete the original text box.
Mary Sauer MSFT MVP
&q...DataSet row to a Object Array Casting issue. Boolean
I have a class name OrderAckType and it has 3 variables
public boolen orderSubmit;
public string orderid;
public string orderNumber;
and i have to get the data from the database and basically this is my Query
select Convert(bit,1) as orderSubmit, orderid,orderNumber from order_master
The data is returned in the DataSet.
Now i want to move that data to this object.
so i am doing this.
OrderAckType oack2 = new OrderAckType;
it cannot convert this bcos of the casting, in the Dataset the ordersubmit
is "true" and datatype String.
...Delete Right 5 if
I need a macro to do the following in B3:B500
Hope this is clear
You not necessarily need a macro, the following formula in a helper column
does the job:
„Esrei” ezt írta:
> I need a macro to do the following in B3:B500
> Delete Right(........,6)
> Hope this is clear
You don't need a mcro, just insert a new column next to column B
In row 3 of the new column, use this formula, and copy it ...selecting text and spikes
Operating System: Mac OS X 10.6 (Snow Leopard)
I want to do the usual: insert the cursor, click/drag to highlight, press F3 to copy, then paste. <br><br>But when I click, Word selects multiple words or lines, when I attempt to copy (F3), the text deletes. When I look under the Edit menu, it says "Undo spike." <br><br>Yikes, spikes? what am i doing? or what is word doing? <br><br>BTW, when i tried to enter text in Word help, i couldn't until i restarted and reset the pram.
F3 is the Spike key, not ...Writing Text File with code UTF-8
Does somebody know how to write a Text File with code UTF-8 from
I know that are 3 functions to write text files:
But there is not therein a parameter to achieve text file be written
with code UTF-8.
I=92ll appreciate your guide.
Dexterity does not support double byte or unicode. You might need to use COM or win32 dll calls to get the OS to write the file for you.
The difference between WriteLine and WriteDOS i...Can I permanently delete/hide data within Pivot Tables?
Microsoft Excel 2002
I have 155 clients which I need to run Pivot Tables for! All with the same
pivot table layout.
Is it possible to run the Pivot table with the 155 clients as a Template
basically, then somehow delete or permanently hide the data leaving only one
client, so that I can save multiple copies for each of the individual clients?
Or can I set up a pivot table where I can automatically feed in parameters?
Client details are stored on an Oracle database!
Right-click on a Page Field and select Field Settings from the context menu,
then click the Advanced button. Yo...New History Item, Mail Message sends all messages as Rich Text Format
We are using Business Contact Manager 2007 with Outlook 2007. We are
not using Exchange server as a backend, just plain old pop3/smtp mail
servers. Problem we are having is when we open up an account, Click
on New History Item, Mail Message, and if we send an attachment with
that, the person that receives the message gets it in Rich Text
If we right click on the Email address itself and click on Send
Mail. The message will be sent out fine.
Right click on the message and looking at the properties of the email
address has the internet format listed as "Let Outlook decide the ...Text box set to memo vs. Lines Coded on a report
I have a report which looks like a legal pad with lines. 24 actual spaces.
The number of lines can not change. I have duplicated a form from Excel to
eliminate using it altogether. So it looks just like the Excel Report. I
coded the lines into the report. I am using a text box with data type set to
memo. I have several issues.
1. If the data entered into the textbox from my form fits in to the text box
on one line, then there is no problem. I can just move the page footer to
more or less the right position to allow it to fit inside the coded lines.
(It is not exact, but close...Delete blank Last page
In a word document where the last page is blank due to editing or whatnot,
how do you get rid of the frigg' thing.
This is a Visio newsgroup - your question was about Word.
However, I have had this problem as you have.
Narrowing the margins and line spacing on the page previous
to the last may get rid of this annoying "blank" page for you.
- Jeff Chapman
"silkies" <email@example.com> wrote in message
> In a word document where the last page is blank due to editing or
> whatnot...ITEM DELETION
I have multiple locations running rms and we change items
frequently making item deletion necessary. is there a
SQL command to delete random item numbers for product
that we will no longer carry from the database?
NEVER, EVER DELETE ITEMS!!! You are doing yourself a GREAT disservice by
deleting them. You are deleting your history of what you have done. Same
goes for sales, purchase orders, customers, etc. How can you create a
informed decision without past information? Computers are fast & cheap and
getting faster & cheaper by the day. Hard driv...Can't send if text entered in message body
I'm having a strange send error.
If I just put the recipient address and a subject, the
email will send. If I add ANY text to the message, when I
click "Send & Receive" it starts to send, I get the
progress bar, then it just sits there until it errors out.
I'm totally stumped by this one...any help out there?
...Permanently Deleting Items
Hello. I am using exchange 2003 and I want to be able to
have mail in the users' deleted mailbox automatically
delete after a certain time (say 2 days). Under the
mailbox store, I have it set to keep deleted items for 1
day, but it's not deleting the mail (Im have a feeling
now that this setting has to do with recovering mail that
a user has permanently deleted). In any event, is there
a way for me to do this, or even to periodically clean
mail from the users junk folder. Thanks.
You should be able to use Mailbox Manager for this (don't have a KB article
Re your...Text wrap spec
I thought I understood that the text wrap limit for any given cell was
1024 and indeed when I look at the specification for Excel, it states
that only 1024 text characters will display in a cell. However, I have
the following condition (Excel 2003 running under Windows XP Pro).
I have a column that is 35 wide. I entered repeating text in four
paragraphs. The total length of my string is 1093 characters (verified
using the Len function). The last word wrap occurs at character 1032,
definitely beyond the 1024 limit. The total number of characters that
shows in the cell is 1074 an...Import/Export Text Specification
Is it possible to copy a single "Import/Export Text Specification" from one
mdb to another?
From the file that does not have the specification, File | Get External Data
.... | Import, then choose .mdb file type and choose the file that has the
specification in it, then click Options button in the wizard window and
select the checkbox for importing import/export specifications.
<MS ACCESS MVP>
<MS ACCESS MVP>
"JimP" <firstname.lastname@example.org> wrote in message
news:email@example.com...how do I delete an email address in my address book?
I would like to delete an email address that comes up when I start typing in
this particular email address.
When the drop-down address list appears, use your down arrow key on the
keyboard to select it and press the Delete key.
> I would like to delete an email address that comes up when I start typing in
> this particular email address.
...Exchange server 2003 deleted, HELP!!!
I started with an Exchange 2003 (Windows 2003 server in an Windows 2003 AD)
server in our organisation. Later we added a Exchange 2003 cluster.
Everything went just fine until... I first moved all mailboxes from the old
server to the cluster and deleted the old server with the Enterprise
Manager. I know a very bold and stupid action, expecially if you haven't
checked things properly before the action. I forgot to replicate the Public
Folders to the new Exchange cluster.
Anyway, is there a way to get the old Exchange server back in the Active
...Richedit GDI Object Leak
I finished a Richedit that can insert bitmap or other ole object(impl
from IRichEditOleCallback), it can work well, but if you drag one ole
object to a new position( or just move it but don't change its
position), a GDI object will be create and nerver be deleted, how to
deleted this GDI object??
...re: VBA Problem
Thanks in advance for any help...
I'm creating a frontend form for a spreadsheet which uses a lot of
textboxes. I want to be able to pass any of these textbox objects to a
function which will alter the object's properties.
A simplified version of the code is shown below:
Private Sub TextBox1_Change()
Call makeRed(TextBox1) ' error 13
Private Sub TextBox2_Change()
Call makeRed(TextBox2) 'error 13
Private Sub makeRed(ByRef tb As TextBox)
tb.BackColor = vbRed
I can get this to work using Visual Basic 5. But using VBA for Excel 97,