Results 1 to 3 of 3
  1. #1
    clrockwell15 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2017
    Posts
    23

    Creating a Hot Button on an Input Form

    I have a database to keep track of my men's club. It has name, address, etc. What I would like to do is create a Hot Button on the Input form that once I complete the fields, I click on this button and Name, address, city, state and zip appears on a set welcome letter I have created in MS Word. Is it possible?

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    yes it is possible. you will need code in the button click event. There are a few options.

    The easiest is to design your welcome letter as a report, then the code would open the report

    Or you can create a word mail merge template which would reference a query in your db for the personal details have your code open and populate that.

    Alternatively you could open your document and populate it directly with code

    In the first instance, google something like 'access vba populate a word template' to find code examples and adapt one that meets your requirements

  3. #3
    clrockwell15 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2017
    Posts
    23

    Regarding my access and welcome letter

    Quote Originally Posted by clrockwell15 View Post
    I have a database to keep track of my men's club. It has name, address, etc. What I would like to do is create a Hot Button on the Input form that once I complete the fields, I click on this button and Name, address, city, state and zip appears on a set welcome letter I have created in MS Word. Is it possible?
    Thank you for the quick response. I will try those ideas. Rocky

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

Similar Threads

  1. Need help creating input form
    By bps in forum Access
    Replies: 2
    Last Post: 05-09-2017, 08:54 PM
  2. Creating invoice input form in 2007
    By mogo3xc in forum Access
    Replies: 2
    Last Post: 04-01-2015, 02:47 PM
  3. Replies: 1
    Last Post: 11-04-2014, 12:07 PM
  4. Replies: 4
    Last Post: 10-20-2014, 12:57 PM
  5. Creating a input form...?
    By DarrenReeder in forum Access
    Replies: 4
    Last Post: 01-07-2011, 03:26 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