Updating Year....

[drblackard]

I have a church database for our choir...we are usually the same group each year ... I have built a database logging all robes, hymnals, etc... I have a table with the contact person (contact), address information, sizes, and yearly dues paid (year)... I would like to just update the year from one year to the next without having to change 135 individually... is there someway to automate this or a function that I can use.... I still would like to have access to the 2006 files to see if someone is making partial payments and check their records (as well pastdue balances) but at the same time move/update to 2007.... is there an easier way to this...I am fairly new to Access and don't mind trying something...I have backups of my database so I can try anything. thanks in advance..

 

[FoFa]

If you want history (still see the 2006 records) than updating is probably not what you want to do. You want most likely want to insert a new record for the new year. You probably don't have enough records to worry about this growing to large. You can use an insert based off a select from your curent data and just supply a new date.

 

[drblackard]

That sounds like what I need FoFa...Thanks.... will this all work using a select box for each year (this is what I have since I created it without thinking of going to each year)? I would also like to have a running sum for each member that does not pay....I think I can do that in the reports areas....back to my questions, can I do this with a combo selection box for the year or do I need to type in the year each time.... I'm kinda new to this...so bear with me..

 

[FoFa]

You could have the SELECT query pull the year from an input box on the form. To pull from a form, your query would need [FORMS]![MyFormName]![MyFieldName] (of course substitute the MyxxxName with your names).

 

[drblackard]

Where do I put this SELECT[FORMS]![Membership Dues]![Year] (of course substitute the MyxxxName with your names) ? Will this do what you explained in the last comment:


Today, 09:48 AM
FoFa
Registered User Join Date: Jan 2003
Location: Texas, USA
Posts: 2,818


If you want history (still see the 2006 records) than updating is probably not what you want to do. You want most likely want to insert a new record for the new year. You probably don't have enough records to worry about this growing to large. You can use an insert based off a select from your curent data and just supply a new date.
__________________
E Pluribus Unum - Out of Many, One

 

[drblackard]

the code

Just wondering if someone could help me with where to put the above code...thanks

 

[FoFa]

Basically you need to create a query, and have the criteria pull the information from your form. it can be either a selelction box (best) or manual input (make sure it is valid format). Once you have query working, you can use it as is, or base a form/report off of it.