Form Templates

  • Thread starter Thread starter Little Helper
  • Start date Start date
L

Little Helper

I was wondering if it were possible to create a form in
one DB, convert it to a template and distribute the form
to be used in another access db file.

I have multiple computers using the orginal access file I
created now I need to update the form and wondered if
there was an easier way to import the new form instead of
manually changing each form on each system.

Any ideas would be greatly appreciated.

Thanks in advance from Little Helper!
 
What you can do is create a whole new front end that just has all the new
forms, queries, and code. You can then distribute this new front end, and
then have it "link" to the old existing system.

In fact, splitting the database into two parts (front end = application) and
(back end = just the data tables).

Doing this split means you just send a whole new mde (you are using a mde
....right?) and their data tables are NOT thus over written.

From this point on, you can then OVER WRITE the old application. For the
first time, there will be no front end to "overwrite", but there is little,
or no reason why you have to split, or even touch their existing mdb file.
Just make that existing file they have now the back end.

Since you did not split before deploying, then you WILL HAVE to train the
users to now launch this new application, and NOT run what has become your
back end. Utlipolate, their existing back end should have the forms, code
etc removed, so they can't accidnelty run the wrong code.

For info on splitting, read up on:

http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm
 
-----Original Message-----
I was wondering if it were possible to create a form in
one DB, convert it to a template and distribute the form
to be used in another access db file.

I have multiple computers using the orginal access file I
created now I need to update the form and wondered if
there was an easier way to import the new form instead of
manually changing each form on each system.

Any ideas would be greatly appreciated.

Thanks in advance from Little Helper!
.
Hi,
Click to expand...

Search visual basic for either "GetOption" or "SetOption"
methods for infor about using form templates in Access.

Hope this help. Roddy
 
Back
Top