Phil asked that I accelerate some changes to the RASC Toronto Centre membership database. Roger. Fired up Access 2003 and got to work.
Refined the Member Entry form. Cleaner layout, more consistent, good tab key order, improved labels, etc. Added search drop-down menus on the Main and Membership tabs. Made the name box at the top of the form also show the current ID (UTP).
Added a field to the main table called "RASColdID" for helping track when a member gets a new number ID from Nat Off.
Populated the new "TCstatus" field. But had to make some decisions based on expiry dates, companies, deceased members. Looked up a few of the hostiles that I knew of and set them to Unfriendly.
Touched up some of the corporate entries, moving the company name info into our new field.
Imported Yahoo List and ID information from multiple sources.
Created the new transaction tables, one for type, and one for category. Linked to transactions table. And appropriate adjustments made in form.
Still more to do...
Saturday, January 07, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment