Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Mon Feb 15 14:23:44 CST 2010
Hi Max -- Please have a look: http://sms-web.biz/add-in-express/apce.jpg This is Access 2007. I tested also with Access 2003 - and that was not my development PC - and I have got PowerTools CommandBar there. Please note that for MS Access 2003 CommandBar is getting visible only when you have a database opened. Please note also that you have to run setup.exe - if you used [Right-Click]->[Install] with .msi file from setup kit it could not work properly. I must say I only tested large setup first on my three systems: Vista, XP and Windows Server 2003 - and that worked OK. After large setup installed/deinstalled small one worked OK also. Still learning "Add-In Express for Office and .NET" setup features - setup package is created by this tool "automagically" (and worked well here on three systems) - there could be some "blues" with it I expect - let's find them together... One can also ask/look at Add-In Express support forum (http://www.add-in-express.com/forum/index.php) - there are quite some info there and discussions are quite active - and they are positive mainly, btw, Andrei Smolin, you can find there is a former AccessD member (10+ years ago)... 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 10:53 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET - Shamil, I have installed it (the small version) as Administrator but it does not appear anywhere. The Addins is empty. Where does it store it? FYI: I have both 2007 and 2003 installed but I use mainly 2003. In A2k3 the addin manager points to: Max/Appdata/Roaming/Microsoft/addins Thanks Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil Salakhetdinov Sent: 15 February 2010 19:15 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET - TIA, William, I have also put both zip archives on this page: http://northwind.codeplex.com/releases/view/26600 in the end of the list of available downloads. Thank you. -- Shamil P.S. Closing my working day here now - it's 10:13PM.... -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman Sent: Monday, February 15, 2010 10:03 PM 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 >>> > > -- 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 __________ Information from ESET NOD32 Antivirus, version of virus signature database 4869 (20100215) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru