[AccessD] My latest bright idea, take two.

Sat Jan 29 09:11:49 CST 2022

Maybe once you have the book constructed you could have some
supplemental material in video form to lure people into the book.

Have you thought about titles,  "Making Your Access Projects Classy"
or something like that?

GK

On Sat, Jan 29, 2022 at 8:50 AM John Colby <jwcolby at gmail.com> wrote:
>
> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

-- 
Gary Kjos
garykjos at gmail.com