Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Why is a tag source being truncated when importing with VBA.

Status
Not open for further replies.

steve728

Programmer
Mar 16, 2003
536
US
Below, the <my:Description> tag is truncated when importing into Access.??? All that comes in is the tail end: "Call me with questions." How can I over come this problem?

<my:Request my:ReqDate="2007-04-30">
<my:ReqBy>Lee Ann</my:ReqBy>
<my:Department>RO</my:Department>
<my:SupervisorName>Anthony</my:SupervisorName>
<my:ReqTypeError></my:ReqTypeError>
<my:ReqTypeCorrection></my:ReqTypeCorrection>
<my:ReqTypeAddition></my:ReqTypeAddition>
<my:ReqRptChange></my:ReqRptChange>
<my:ReqDataFix></my:ReqDataFix>
<my:AddnlDocAttached></my:AddnlDocAttached>
<my:SoftwareName>Candidate/Diplomate menu</my:SoftwareName>
<my:ScreenReportName>Withrawals and Obituaries</my:ScreenReportName>
<my:Description><div xmlns=" Juliet Seigle; Candidate needs to have late invitation fee refunded to her (TRD - $400.00).  I tried to process this in Obituary, Withdrawal and Ineligible Entries as normal, but the following error message appears:<br xmlns=" Object variable or With block variable not set.  You then click OK and this message appears: Error: Object invalid or no longer set.<br xmlns=" xmlns=" to say the fee record section does not show refunded.<br/></div>
<div xmlns=" me with questions.</div></my:Description>
<my:AssignedTo></my:AssignedTo>
<my:ClosedBy></my:ClosedBy>
<my:StaffTimeAllocation></my:StaffTimeAllocation>
<my:Email>LeeAnnB@theabr.org</my:Email>
<my:Reason></my:Reason>
<my:ReqNumber></my:ReqNumber>
<my:ReqQuery></my:ReqQuery>
<my:ReqOther>yes</my:ReqOther>
<my:priority my:priorityDate="">ASAP</my:priority>
</my:Request>

Thanks,

Steve728
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top