[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