[AccessD] My latest bright idea, take two.

[John Colby]

Jack, I just don't have the time for the YouTube thing.  I tried and it
takes hours to get anything done.  However I already have tons of written
material.

On Sat, Jan 29, 2022 at 9:41 AM jack drawbridge <jackandpat.d at gmail.com>
wrote:

> John,
>
> I still think you could/should pursue youtube. Nobody has anything along
> the lines of your framework and classes experience. And, as you say - most
> of the access developers are pretty much oblivious to this side of
> things.😂
> jack
>
> On Sat, Jan 29, 2022 at 9:04 AM John Colby <jwcolby at gmail.com> wrote:
>
> > Bill,  You assume too much!😁
> >
> > The answer to your questions is no, I was driving down the road last
> night
> > blue skying.  I want to write a book.  I want to create a database that
> can
> > be built from scratch as the book evolves to demo the code in the book.
> I
> > know just enough to be dangerous.
> >
> > 🤕And so I am dangerous.
> >
> >
> > On Sat, Jan 29, 2022 at 7:57 AM Bill Benson <bensonforums at gmail.com>
> > wrote:
> >
> > > This sounds like so much fun, if my eyes were not putting me on short
> > > term disability, I would love to work with you on this project John!
> > >
> > > You are trying to get this to work on your hard drive alone, before
> > > attempting to move it to the web I hope? I think you are counting on
> > quite
> > > a lot going right, if you expect objects to get built by the user
> > clicking
> > > macro buttons that will make calls to web functions that will download
> > text
> > > files then run LoadFromText.
> > >
> > > Here are some considerations I had, without knowing anywhere near as
> much
> > > as yourself:
> > >
> > > * Will VBA wait to run the LoadFromText command, until the web command
> to
> > > download the text file is completed (i.e., are they synchronous?)
> > > * Forms will need to be saved and closed before they can be re-built
> > using
> > > LoadFromText, right?
> > > * From what I recall, I needed to save new form modules after using
> > > LoadFromText directly in the VBE, and there was no way to save them
> > > silently, the Save command caused there to be popup prompts to save
> each
> > > individual object.
> > >
> > > I can only presume you have this all sorted or you would not even be
> > going
> > > down this road.
> > >
> > >
> > >
> > > On Sat, Jan 29, 2022 at 7:30 AM John Colby <jwcolby at gmail.com> wrote:
> > >
> > > > I haven't tried it yet but...
> > > >
> > > > I want to publish my class stuff as an ebook a la Rocky.  The problem
> > is
> > > > creating an example database that I can update for eratta or fixes.
> > The
> > > > code below supposedly saves and loads forms and modules.  What I do
> not
> > > > know yet is whether it actually saves the form itself complete with
> all
> > > the
> > > > controls, their positions etc.  If so then...
> > > >
> > > > Imagine a power shell script which the book buyer runs.  The script
> > > > downloads a small, mostly empty database from my github page and
> opens
> > > it.
> > > > When it opens an autoexec fires, which runs code in the one little
> > module
> > > > in the mostly empty database.  The code loads a little switchboard
> form
> > > > with chapter buttons contained in a text file stored on my github
> page.
> > > > The click of each button loads any modules, classes and forms
> required
> > > for
> > > > a chapter from text files stored on my github page, essentially
> > > > bootstrapping a fully functional demo database from text files stored
> > on
> > > my
> > > > github page.  If any of these files need changing or updating, I
> update
> > > > them and load them back to my github page.  The next time the user
> > opens
> > > > the database, the changes are now loaded in the little database.
> > > >
> > > > If this works, I could build a maintainable demo database sitting in
> > > > GitHub.
> > > >
> > > > The user can use the switchboard to load demo modules, classes, forms
> > and
> > > > reports, and then open forms which demo the functioning classes and
> how
> > > > they work.
> > > >
> > > > In the old days (I know them well) a publisher would build a CD which
> > > would
> > > > be contained in an envelope in the back of the book.  The method I am
> > > > discussing would replace that CD.
> > > >
> > > > Questions, comments or things I forgot or didn't think about?
> > > >
> > > > *The code I referenced above...*
> > > >
> > > > The little documented SaveAsText and LoadFromText may help if an
> object
> > > is
> > > > corrupted or otherwise behaving weirdly.  *Or for my purposes
> above...*
> > > >
> > > > At the debug/immediate window type:
> > > >
> > > > Application.SaveAsText acForm,"MyForm","c:\form.txt"
> > > >
> > > > You can load the file into a new MDB.
> > > >
> > > > Application.LoadFromText acForm,"MyForm","c:\from.txt"
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > John W. Colby
> > > > Colby Consulting
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >
> >
> > --
> > John W. Colby
> > Colby Consulting
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
John W. Colby
Colby Consulting