Access, Creating templates

R

Robert

I need to know if there is a way to create a form template that I have
created, so I can use it over and over again? Just like in MS Word you can
create a doc template, I need to know if template created is avail in Access.
Thanks
 
A

Arvin Meyer

Access templates are simply forms that are named as templates. After
designing your template form, click on Tools ... Options ... Forms/Reports
tab and type in your form's name. Yhe templates are limited. What I prefer
to do is create a form with some code, labels, etc. already built, then
right-click and choose Save As and give the copy a new name. It's much
faster that way.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
6

'69 Camaro

Hi, Robert.
I need to know if there is a way to create a form template that I have
created, so I can use it over and over again?
Click to expand...

Yes. Create a form template. Use it in the current database and import it
into any other database that you need the template. Each time you use the
Form Wizard to create a new form, the settings of the template form will be
used, but not the controls and not the formatting unless you set the
AutoFormat to do so when the Form Wizard creates a new form. To set up the
Form Wizard to use the specific formatting of your template form, please see
this Web page:

http://groups-beta.google.com/group/microsoft.public.access.forms/msg/65d10e66aa61cf76?hl=en&

If you need a copy of an already custom-designed form, then you should just
copy it in the Database Window.

For more information on form and report templates, please see the following
Web page:

http://allenbrowne.com/ser-43.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are [email protected] and [email protected]

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.
 
Top