Results 1 to 3 of 3
  1. #1
    rts is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    34

    Best Way to Approach Standard Letters?

    Hello,



    I've been working my way through Access and I have a db that I'm pretty happy with, but I can't figure out the best way to go about Standard letters. We have about 10 standard letters in my company. I want to print them directy from the editable form, not as a report. I've laid the form out with our letterhead, standard fields, etc so that it prints just fine, but I don't know how to go about the different bodies of the letters. I wanted to be able to select an [ID] primary key to populate the text box with the appropriate letter body, but the problem is that some of the bodies contain parts that need to be filled in according to the current letter I am printing. For example, one letter body refers to a $ amount that I enter in another field on the COR form. If I pull the letter bodies from the "Letter" table, they will not find the values to insert from the COR table. It instead will say "Attached is our proposal for " & [SUB_VAL] & "for the current project." There is no way for that field to figure out what [SUB_VAL] is.

    I know I can input ="Attached is our proposal for " & [SUB_VAL] & "for the current project." in the control source of a text box, but I want the staff to be able to edit the text boxes as well. I want the general standard language of the letter, but I want everyone to be able to put the cursor anywhere and add a sentence. I thought about Iif, DLookup, etc., but haven't found anything that works. At the end of the day, what's the best way to create standard editable letters in Access? Thanks for any help!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,616
    Access won't work that way. It is not a text editor, it is a data manager. Users input data into tables through forms as interface. Reports output that data. You can have an unbound textbox that allows user to input anything but surrounding labels and textboxes probably won't space properly for the appearance of formatted sentence or paragraph. Could also have input parameter prompts in the form's RecordSource query that will take any input from user, misspellings and bad punctuation included.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    rts is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    34
    Thank you. I realize that was asking a little too much.

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

Similar Threads

  1. Standard format for Yes/No fields
    By coolpal9 in forum Forms
    Replies: 1
    Last Post: 01-20-2012, 04:56 AM
  2. Best approach for Absence DBase
    By JohnMc in forum Database Design
    Replies: 1
    Last Post: 11-17-2011, 12:00 PM
  3. Not sure how to approach this problem
    By Jasrenkai in forum Access
    Replies: 2
    Last Post: 02-28-2011, 05:23 PM
  4. Programming Approach for Pattern Layouts
    By IvoryDragonfly in forum Programming
    Replies: 3
    Last Post: 10-09-2010, 01:14 AM
  5. Best approach to export to HTML in this scenario
    By techguy817 in forum Import/Export Data
    Replies: 0
    Last Post: 04-17-2009, 10:28 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