[dba-VB] Create a Module and Write to It

This may be what you need.  From Access 97, no less:

http://support.microsoft.com/kb/187318

Doug

On Sun, Mar 11, 2012 at 11:14 AM, Dan Waters <df.waters at comcast.net> wrote:

> Hi Arthur,
>
> If you are using SQL Server tables it's likely that you can skip all this
> entirely by using Linq-to-SQL.  With this method you can drag a table to
> the
> Linq-to-SQL screen to create the class.  Then in code you do things like
> Submit() to have LINQ-to-SQL update the data in the database.  It's a
> change, but it's a good one.
>
> Just do a search and you'll find a lot of explanation.
>
> Dan
>
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
> Sent: Sunday, March 11, 2012 12:41 PM
> To: Discussion concerning Visual Basic and related programming issues.
> Subject: [dba-VB] Create a Module and Write to It
>
> I've decided to resurrect an old utility I wrote years back, that accepts
> the name of a table and then generates a class definition complete with
> LETs
> and GETs for the fields, and methods for Load(), Insert(), Update() and
> Delete().
>
> Naturally, I can't locate the code which is somewhere on one of my numerous
> CDs. And besides, now that I'm a tad more mature, I can probably do it
> better now. The original, for example, just banged its generated code out
> to
> a text file, which I then had to manually import. Which brings me to the
> question in the Subject. How can I create a module in code, then write the
> generated code directly into it?
>
> TIA.
> --
> Arthur
> Cell: 647.710.1314
>
> The most likely way for the world to be destroyed, most experts agree, is
> by
> accident. That's where we come in; we're computer professionals. We cause
> accidents.
>
> -Nathaniel
> Borenstein<http://www.quoteland.com/author/Nathaniel-Borenstein-Quotes/63/
> >
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>