Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Tue Feb 16 11:32:50 CST 2010
Hi William,
Thank you for your feedback.
All the issues you mentioned are now posted on the Access.PowerTools project
Issue Tracker area (http://accesspowertools.codeplex.com/WorkItem/List.aspx
).
Please comment more, please vote for the features you wanted to have
implemented first of all - and you'll get them :)
Everybody are welcome to do that testing and commenting and voting...
<<<
...overall more than I expected for a first go :)
>>>
Thank you. I must say I also didn't expect that :) ...
... that I'd have invested that much efforts in it - but it went smoothly
from the very begining, and it was all my pleasure to make it over last
weekend's evenings, and this Monday...
I will collect and I will organize yours and others feedback now, and I will
be planning and implementing a new release to be developed and released
somewhere one month from today/end of March this year...
Thank you for your help and support.
--
Shamil
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
Sent: Tuesday, February 16, 2010 7:02 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET -
Shamil
1. setup went well but I question why you choose to deploy this to a private
folder rather than the Addins standard
it defaulted to my private application data directory
2. should have an uninstall option on the setup.exe or as a separate exe
3. must be a means to cancel a Backup in progress
4. absolutely NO automatic backing up of linked tables allowed
selectable option possible but I'd never use it
5. program hung on trying to export network linked table
6. 14,288 kb after compact & before running backup
17,180 after running backup & hanging
14,288 after compact
7. should be a means to easily configure the toolbar on install so it
doesn't automatically take up a line of its own
I know I can fix this manually but you can do better :)
8. as Max said " Needs a bit on hand-holding."
...overall more than I expected for a first go :)
William
--------------------------------------------------
From: "Max (MGA)" <max.wanadoo at gmail.com>
Sent: Monday, February 15, 2010 3:37 PM
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET -
> Aha!
>
> Got it, didn't realise it was on the menu bars. Sorry..duh.
>
> Ok, runs ok but not enough explanation of what is happening and what to
> expect. Backup and Restore seemed to go ok but "how would I know"?
> Needs
> a bit on hand-holding.
>
> No options to choose how tables should be exported (csv, xls, xml,
> data).
> I like the "plain data" that is good - ideal for pasting into Word etc. I
> will put that into my RemoteEatBloat program.
>
> Therefore, no option on which format to use to restore the tables.
>
> But, ran well, no problems that I could see.
>
> I will now run it on a "problem" mdb and report back.
>
> Thanks very much - excellent job
>
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
> Salakhetdinov
> Sent: 15 February 2010 20:24
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET -
>
> 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
>
>
>
> --
> 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
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4871 (20100216) __________
The message was checked by ESET NOD32 Antivirus.
http://www.esetnod32.ru