Results 1 to 4 of 4
  1. #1
    Laurielou is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2018
    Posts
    2

    Print Static Material on report from query

    I have a report we run out of Access that uses records from an SQL data base in our manufacturing software Syspro. We request what fields to be printed by entering a sales order number. These print out on cards.



    I would like to have a few lines of information print on each card that would always be the same. (Almost like a preprinted form)

    I am at a loss as to how to go about so any help in this matter would be so appreciated.

    Thanks,

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    One way of doing this is to use a label control and set its caption to the text you want
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Laurielou is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2018
    Posts
    2

    Smile

    Quote Originally Posted by ridders52 View Post
    One way of doing this is to use a label control and set its caption to the text you want
    Thanks so much........I am up and running now.

    Laurie

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You're welcome. There are other methods but for many situations, that is the easiest
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Replies: 3
    Last Post: 04-28-2017, 09:51 AM
  2. Replies: 8
    Last Post: 10-26-2016, 02:36 PM
  3. Replies: 5
    Last Post: 08-06-2015, 03:26 PM
  4. Replies: 1
    Last Post: 02-21-2015, 11:35 PM
  5. Replies: 10
    Last Post: 02-02-2015, 12:03 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