Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.scripting.vbscript > #11978 > unrolled thread

Is there a way to add forms and modules to an Access database programmatically from VBscript?

Back to article view | Back to microsoft.public.scripting.vbscript

Contents

  Is there a way to add forms and modules to an Access database programmatically from VBscript? Dan Campbell <dcwhatthe@gmail.com> - 2018-09-28 07:12 -0700
    Re: Is there a way to add forms and modules to an Access database programmatically from VBscript? JJ <jj4public@vfemail.net> - 2018-09-28 23:26 +0700
    Re: Is there a way to add forms and modules to an Access database programmatically from VBscript? GS <gs@v.invalid> - 2018-09-28 14:35 -0400

#11978 — Is there a way to add forms and modules to an Access database programmatically from VBscript?

Is there a tool or a vbscript method to automate the generate of an Access database, INCLUDING the forms and modules?

I know how to create the tables progrmmatically, of course.  But I'd like to be able to generate everything, via script.


A free script or a commercial tool are both ok.  Whatever works.

[toc] | [next] | [standalone]

#11979

On Fri, 28 Sep 2018 07:12:46 -0700 (PDT), Dan Campbell wrote:
> Is there a tool or a vbscript method to automate the generate of an Access
> database, INCLUDING the forms and modules? 
> 
> I know how to create the tables progrmmatically, of course.  But I'd like
> to be able to generate everything, via script. 
> 
> A free script or a commercial tool are both ok.  Whatever works.

I think it can be done using Windows Scripting Host's VBScript (not to be
confused with MS-Office's VBScript). i.e. create projects, databases, forms,
and modules. All from scratch.

Although it would be better to use WSH-VBScript mainly as a "kick starter".
i.e. to create the module which contains the main automation script, then
continue the automation from the Office-VBScript context. Because in the VBA
context, many of the external objects are preloaded, and it also includes
several macros and additional functions.

MS-Office came with an offline help which also contain guides and references
for its VBScript. If it didn't get installed when the application is
installed, update the application setup to install it.

[toc] | [prev] | [next] | [standalone]

#11980

> Is there a tool or a vbscript method to automate the generate of an Access 
> database, INCLUDING the forms and modules?
>
> I know how to create the tables progrmmatically, of course.  But I'd like to 
> be able to generate everything, via script.
>
>
> A free script or a commercial tool are both ok.  Whatever works.

Have a look at the VBA component. It allows full automation of Access, forms, 
and controls.

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

[toc] | [prev] | [standalone]

Back to top | Article view | microsoft.public.scripting.vbscript

csiph-web