[AccessD] EatBloat Version 5 Update Status

All  I would say is thank you very much.  It sounds great.

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: 01 July 2009 15:57
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] EatBloat Version 5 Update Status

Hi Folks!

I wanted to provide some status on how this update is going so far.

The core of Max's form is great - export objects to text and bring those
text files back as objects clean of problems (Bloat!).

These are the changes I'm working on:

- From the form, you can choose the current database or a different database
to export objects from.  And you can choose the current database or a
different database to import objects into.  The current database will be
listed as the default.

- The export folder will be created using the current date and time in it's
title.  This ensures that you'll have a new folder and new files each time
you do an export.

- On the form, I am adding a 2nd listbox.  The left listbox will show the
objects you can select from (one type at a time).  The right listbox will
show the objects you have selected.  All objects in both listboxes will be
sorted alphanumerically.  (I found great code for this at:
http://blog.msvba.com/2008/02/sorting-listbox-items-alphabetically.html)

- You'll be able to move individual objects from one list to another by
double-clicking.  You'll be able to move multiple objects from one list to
the other by first selecting, then pushing a button.

- The selected objects will all be exported into the same folder.  They will
have name prefixes like 'FORM!' or 'MODULE!'.  Then when you import the
files back in, you'll be able to select all of them at once, or just some.
The database will know which file is of which type by the name prefix of the
text file.

- Because there are two listboxes, I can change the radio buttons to just
two buttons for each object type.  For example, there will be an 'All Forms'
button and a 'Select Forms' button.

- For tables, you can select to export them as XLS, XLM, or CSV format.

- I'm removing Data Access Pages from the choices of objects.

- Per one of Max's notes, you probably should export only tables, not a
table that is linked to the one you're working in.  So, I'm also removing
the option to export a table from a different database that is linked to the
one you're exporting from.  This is appropriate because this form will now
let you work with a different database anyway.

Well - this is more stuff than I thought I'd be getting into.  I've worked
on it for a few days, and I think that several days are left.  Starting next
week, I have a 1 - 2 week job, so this will probably be ready a few weeks
from now.

If I've made any major omissions or errors - let me know!

Thanks!
Dan


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com