William Hindman
wdhindman at dejpolsystems.com
Mon Feb 15 14:03:31 CST 2010
...yes (at least for now), I think so, for me to know and you to long for :) William -------------------------------------------------- From: "Max Wanadoo" <max.wanadoo at gmail.com> Sent: Monday, February 15, 2010 2:36 PM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET - > You have a client? > > Does he pay well? > > What's the address...? > > Max > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman > Sent: 15 February 2010 19:03 > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET - > > Shamil > > ...I've dl'd the small zip ...I'm at a client's right now so it will be > tonight before I get a look at it ...let you know then how it went. > > ...whatever the results, many thanks for the time and skills you (and > others > > here) have put into this already ...this is why I call AccessD home. > > William > > -------------------------------------------------- > From: "Shamil Salakhetdinov" <shamil at smsconsulting.spb.ru> > Sent: Monday, February 15, 2010 11:00 AM > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET - > >> Hi Max, William et al, >> >> Here it's - "Access PowerTools Add-in v.0.0.1" setup: >> >> http://sms-web.biz/add-in-express/Access.PowerTools.Setup.20100215.zip >> (~30MB) >> > http://sms-web.biz/add-in-express/Access.PowerTools.Setup.20100215_Small.zip >> (~2MB) >> >> The first one has dotNetFx inside, the second one doesn't. >> For a system with .NET Framework 3.5 SP1 installed second one (small) >> setup >> should work fine. >> Test databases are included in both archives in \TestDatabases subfolder. >> >> When installed add-in adds small "PowerTools" CommandBar with three text >> buttons for Access 2000 - 2003, and a small "PowerTools" ribbon tab for >> Access 2007 (2010). >> For Access 2000 - 2003 commandbar is visible only if a db is opened. >> For MS Access 2007 Ribbon is visible even without any databases opened... >> >> As I noted in my earlier postings here this version is just a proof of >> concept - and it seems to be a good enough proof. >> >> Please read short readme in the archive before running setup. >> >> I'm "all ears" now listening for your, Max, William's and all AccessD >> community feedback - all and every comments are very welcome... >> >> Thank you. >> >> -- >> Shamil >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo >> Sent: Monday, February 15, 2010 1:53 PM >> To: 'Access Developers discussion and problem solving' >> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET - >> >> Hi Shamil, >> >> If I export with this...(showing variables as example) >> >> app.ExportXML ObjectType:=acExportTable, _ >> DataSource:=strObj, _ >> DataTarget:=strTarget & strObj & ".xml", _ >> SchemaTarget:=strObj & "Schema.xml" >> >> I can retrieve with this...(showing actual names as example) >> >> app.ImportXML "C:\_MCM\ExportedAsText\Tables\Accounts.xml", >> acStructureAndData >> app.ImportXML "C:\_MCM\ExportedAsText\Tables\AccountTypes.xml", >> acStructureAndData >> >> BUT if there is any errors then it does not write to the app. This >> means >> when I was testing the above and getting errors as I tested it, no tables >> were pulled in. Once there were no errors then all tables came in. >> >> HTH >> >> >> Max >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil >> Salakhetdinov >> Sent: 15 February 2010 09:32 >> To: 'Access Developers discussion and problem solving' >> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET - >> >> Hi Max, William, whoever else who follows this thread et al, >> >> I'm wrapping Add-In setup and I'm testing it here - so far so good - >> almost >> all works fine - I have just found one issue: >> >> - .ImportXml does create tables structure OK but doesn't import data nor >> when used in C# Automation mode, nor when running within COM-Add-In. I >> have >> tried both .ImportXMl options - structure and data or append data... >> >> Is it a known bug/feature? (when running .ImportXml of the same file from >> within VBA it works OK). >> >> I'm currently using MS Access 2007. >> >> Thank you. >> >> -- >> Shamil >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo >> Sent: Sunday, February 14, 2010 1:32 PM >> To: 'Access Developers discussion and problem solving' >> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET - >> Create > >> a >> NEW DB and populate with objects. >> >> Thanks Shamil, >> >> I look forward to your development. >> >> In your code, you missed the TARGET folder from this code: >> >> app.ExportXML acTable, _ >> rst![ObjectName].Value, _ >> strTargetFileName + ".xml", _ >> strTargetFileName + "Schema.xml" >> >> should it be: >> >> app.ExportXML acTable, _ >> rst![ObjectName].Value, _ >> strTarget + strTargetFileName + ".xml", _ >> strTarget + strTargetFileName + "Schema.xml" >> >> Max >> >> <<< snip >>> >> >> >> __________ Information from ESET NOD32 Antivirus, version of virus >> signature >> database 4866 (20100214) __________ >> >> The message was checked by ESET NOD32 Antivirus. >> >> http://www.esetnod32.ru >> >> >> >> >> >> __________ Information from ESET NOD32 Antivirus, version of virus >> signature >> database 4868 (20100215) __________ >> >> The message was checked by ESET NOD32 Antivirus. >> >> http://www.esetnod32.ru >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >