Access Expert Level 12 Lesson - Microsoft Access Expert 12


	Back to Access Expert 12 Comments List

Upload Images @Reply Bookmark Link Email

Access Expert Level 12 Lesson

Kenneth Wykoff

14 months ago

I just tried to fix the Collection Letter in Lesson 3 and after I did all that I started noticing I had nothing showing up in the process. Also when it was supposed to be finished and fixed, there were several things messed up and missing. I was sure we went over the items missing but I cannot remember what lessons and Levels they were in. Could you advise me of what they are so I can go back and review them to repair the issues? When we did it earlier I forgot to save things. Thanks, Ken

	Kenneth Wykoff OP @Reply 14 months ago

	Kenneth Wykoff OP @Reply 14 months ago
Also included a screenshot of the Design View

	Kenneth Wykoff OP @Reply 14 months ago

	Kevin Robertson @Reply 14 months ago
Did you rename the concatenated fields?

	Kenneth Wykoff OP @Reply 14 months ago
Kevin the last lesson I remember was to list them as FullNme and use the formula I have used. In the repair lesson, I don't remember being told to change anything on the letter other than to add a city where it was missing.

Kenneth Wykoff OP @Reply

14 months ago

Just wanted to let everyone know, I finally figured it out on my own. The begin date and due date on the original order were different than the one in the collection form area. Once I changed the dates to match the set dates in the LetterF it worked. Now my question is, how do you change the LetterF Begin Date on the Collection Letter Report area to fit into whatever timeline you need? It currently seems to be stuck in one area with the current formulas installed in each property area.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 12.