Page 1 of 1

"Adult" code on personal profiles

Posted: Mon Jan 30, 2012 3:22 pm
by compresby486
Hello everyone!

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! :wall:

Thanks!
Denise
Community Presbyterian Church
Forsyth, MO
Windows XP Home Edition, Svc pack 3
Power Church 11.1, program date 12/28/2011

Re: "Adult" code on personal profiles

Posted: Mon Jan 30, 2012 4:29 pm
by NeilZ
compresby486 wrote:Hello everyone!

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! :wall:

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.

Re: "Adult" code on personal profiles

Posted: Tue Jan 31, 2012 10:12 am
by compresby486
Ahah!

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!

Thanks so much!
Denise

Re: "Adult" code on personal profiles

Posted: Fri Feb 24, 2012 8:23 pm
by John Dykema
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?

Re: "Adult" code on personal profiles

Posted: Fri Feb 24, 2012 9:28 pm
by NeilZ
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.

Re: "Adult" code on personal profiles

Posted: Sat Feb 25, 2012 7:46 pm
by John Dykema
This is interesting. Maybe we've never run the Birthdate and Anniversaries Report before... hmmm. Thanks, Neil