Results 1 to 4 of 4
  1. #1
    penbell is offline Novice
    Windows XP Access 2016
    Join Date
    May 2017
    Location
    Alberta, Canadda
    Posts
    9

    How to add additional fields to e-mail and print command buttons in form (template used)


    I am not a regular access user but I managed to modify an existing template for customer contacts (issue tracker) and add additional fields to both the table and the form. I now need to add some of these additional fields into both the e-mail and print command buttons that are generated OnClick. Sorry if I am using incorrect terminology!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    We would need to see the code behind the OnClick to know how to incorporate additional fields.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    penbell is offline Novice
    Windows XP Access 2016
    Join Date
    May 2017
    Location
    Alberta, Canadda
    Posts
    9
    I am unable to add a picture of the screen shots I took of the OnClick action catalog, a copy/paste of the cmdEmail.OnClick Email database object and Message box for the items for which I would like to add additional information is contained below. For the first line item I would like to add a space and then Address after the title. For the second line item I would like to have FirstName space LastName space and Telephone# added on a line above the description.



    /Argument><Argument Name="Subject">=Replace(Replace("Issue |1: |2","|1",Nz([ID],"")),"|2",Nz([Title],""))

    </Argument></Action><Action Name="MessageBox"><Argument Name="Message">=[MacroError].[Description]

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    I don't use macros, but you should be able to add a field. That appears to be a funky way of doing it, but just concatenate to the end:

    ExistingBit & ": " & NewFieldName
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 25
    Last Post: 10-30-2013, 12:40 AM
  2. Form Command buttons
    By chazcoral2 in forum Forms
    Replies: 6
    Last Post: 05-01-2012, 08:10 AM
  3. Adding additional fields in form
    By ThebigCt in forum Forms
    Replies: 2
    Last Post: 02-23-2012, 12:33 AM
  4. Command Buttons on form
    By bespra in forum Forms
    Replies: 10
    Last Post: 11-12-2011, 01:50 PM
  5. Replies: 1
    Last Post: 04-22-2010, 04:54 AM

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