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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. techneophyte

    Trying to output an OLE Object from Access into XML

    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?
  2. techneophyte

    Trying to output an OLE Object from Access into XML

    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...
  3. techneophyte

    Miscalculation in Access Subreports

    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...
  4. techneophyte

    Miscalculation in Access Subreports

    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...
  5. techneophyte

    Miscalculation in Access Subreports

    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...

Part and Inventory Search

Back
Top