We're starting the new year by emailing as many newsletters as we can. Our database was initially set up by someone not familiar with how databases work so I've been trying to catch all the little code errors that make reports and such not work right. I'm getting there!
One problem I'm having is the "Adult" code on the personal profiles. I spent several hours on Friday changing all the N's to Y's and saved each one. Today they're back to N's! I'm having trouble getting emails to pull off the personal profiles for the newsletter emails because of this. How could that happen?
Help!
Thanks!
Denise
Community Presbyterian Church
Forsyth, MO
Windows XP Home Edition, Svc pack 3
Power Church 11.1, program date 12/28/2011
We're starting the new year by emailing as many newsletters as we can. Our database was initially set up by someone not familiar with how databases work so I've been trying to catch all the little code errors that make reports and such not work right. I'm getting there!
One problem I'm having is the "Adult" code on the personal profiles. I spent several hours on Friday changing all the N's to Y's and saved each one. Today they're back to N's! I'm having trouble getting emails to pull off the personal profiles for the newsletter emails because of this. How could that happen?
Help!
Thanks!
Denise
Community Presbyterian Church
Forsyth, MO
Windows XP Home Edition, Svc pack 3
Power Church 11.1, program date 12/28/2011
Did anyone restore a backup over the weekend ?? You can check by heading to the Utilities menu and select View System Audit Log.
Also, under the Preferences -> Personal Profiles Setup what do you have the setting for Age at which a person is considered an adult set for ?? The system will automatically set the ADULT flag based on the date setup in the birthday date.
From the help screen:
To exempt someone from the Adult: Y/N functionality, enter the year 9999 in their birth date (05/06/9999). Use this method to also handle dates where the year has not been specified.
Neil, you are so good! The people who set up our database did not input ANY birth dates at all. So, off to input the workaround of 9999. Thank you, thank you! Sooner or later I may get this working the way it's supposed to. It's an awesome program!
As I was reading this thread I went to our Preferences/Profiles... to look at this. What I also noticed was that we can set the Anniversary date field to various numbered date fields. We have made Date 4 as the "Married Date" field, and therefore is our anniversary date field. But I noticed that Date entry in the Preferences was set to date-2, not 4.
What significance has that Anniversary Date setting make in the system?
John Dykema wrote:As I was reading this thread I went to our Preferences/Profiles... to look at this. What I also noticed was that we can set the Anniversary date field to various numbered date fields. We have made Date 4 as the "Married Date" field, and therefore is our anniversary date field. But I noticed that Date entry in the Preferences was set to date-2, not 4.
What significance has that Anniversary Date setting make in the system?
The Birthdays & Anniversaries report expects to find the Married date in a certain field, and you set that under the Preferences -> Personal Profiles Setup -> Dates tab's Anniversary date field. Just change that to 4 and you'll be fine.
