Results 1 to 9 of 9
  1. #1
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114

    How or can I, save a form as a template?

    I'm having to create new, and alter existing forms.

    How or can I, save a form as a template so I can have a consistent look to all the forms I create and not spend hours doing it?

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    This is why only way I have been able to find to do this.

    Create a new blank Access database. This will be your template "storage" dB. (I'll call it the Template dB)

    In your current dB (I'll call this dB the Working dB), set up the "look and feel" of the form the way you want. Save the form. (I'll call this form the Template Form)
    Close the "Working" dB and open the "Template" dB. Click on the "External Data" menu. In the group "Import and Link", click on "Access" and follow the steps to import the "template form" from the "Working" dB.
    Done.

    So now you are in the "Working" dB, and you want to add a new form.
    Click on the "External Data" menu. In the group "Import and Link", click on "Access" and follow the steps to import the "template form" from the "Template" dB.


    You can use the same method to have a Report template.

  3. #3
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114
    OK, now how do I disconnect the fields from the original table used to create the form and insert new fields for the new table?

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Delete/change the record source?

    You can put unbound text boxes, text boxes, etc as place holders, but obviously the record source can/will change for each use of the form.
    You would still have to connect the "Template" form to a record source
    The template part is to have the same colors, (continuous/single) view, basic buttons (like a close form button and code) across multiple form.


    Maybe I don't understand what you mean by
    ....save a form as a template so I can have a consistent look to all the forms I create.....

  5. #5
    AccessOH is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    2
    Does this work with Access 2013? Worked once, but can't get to work again. Thanks.

  6. #6
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    @AccessOH

    You do realize this thread is from almost 2 years ago??? By posting in this thread, you have done what is termed "Hijacking a thread". It is better if you start your own thread, ask a question and reference this thread......
    You will get more responses by starting your own thread, than posting in a thread marked solved from 2 years ago...


    But, yes, is should also work in A2013.
    Worked once, but can't get to work again.
    Don't understand this.......

  7. #7
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402
    Why not just use copy/paste ? creates a copy of the old form and asks for a new form name !

  8. #8
    AccessOH is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    2
    Sorry, this was my first post on a forum so that in itself has been a learning curve. Thanks for the info. I will keep trying the offered solution. Is there a way to delete this post and 'un-hijack' the thread? Thanks again.

  9. #9
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Nope. Can't delete the post - only that is a reserved function - well above our pay grades....
    Just letting you know so you can get better responses to your questions.


    And welcome to the forum.......

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 07-31-2014, 01:08 AM
  2. form - save entered data only with save button
    By cbrxxrider in forum Forms
    Replies: 3
    Last Post: 10-20-2013, 12:39 PM
  3. Need Help in Form already created in Template
    By Stephanie53 in forum Forms
    Replies: 8
    Last Post: 05-02-2013, 12:28 PM
  4. Replies: 3
    Last Post: 10-08-2012, 08:40 AM
  5. Replies: 9
    Last Post: 01-20-2011, 02:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums