after a little more research I see that the OLE object cannot be imported into XML.....it needs to be encoded to a base64 bit encoded binary file....then included.
So now the question is....can the Base 64 bit coding be performed in VBA in Access 2007?
I'm an XML virgin and a scripting neophyte. I'm trying to include an OLE Object in an XML file. I've tried several methods and the closest I've come is scripting the output. However, when I get to xmloutput.write(sSQL), I get an invalid procedure error. If I comment out the Ole Object everything...
Duh...[sound of head banging against wall]...user error. Don't ever get altzheimers! The sub rpt was greatly reduced to fit on the page and I was pulling the value from the detail line instead of the totals line under the "Line of Business" footer. If I had only scrolled down the list I would...
Thanks, I'll give a little more info.
I have a subreport "subrptMORCurrent" which has a field showing we paid $2M in inpatient services for the month of Dec. When I divide by the "txtMembership" (2000) from subrpt "subrptMORCurrentMembers" I get the correct answer of 1000...
I have a main Access 2003 report containing 6 subreports. On the Main report I have txt boxes that calculate using 1 box from 2 different sub reports.
Example: txtInpatientPMPM divides the amount of inpatient claims(sumOfcInpatientClaims)on subrpt1 by the number of members (iNumOfMembers) on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.