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