Update form Records
Novice
Windows 7 32bit 
Access 2003
Hello,
I have a Membership database. Each year I would like to clear all the names and addresses etc. from the entry form but archive them.
When members pay I would like to enter their membership number and their record would be then be shown on the entry form again.
I would then just enter the amount paid, which may be different from previous payment.
Could someone please guide me how best to achieve this.
Roger
Moderator
Windows 10 Office 365
I suggest you post a copy of your database with only enough records to show structure and basic functions. Remove private /confidential info --replace with fake names(Porky Pig, Ima Gambler, Barb Dwyer..etc.). Once reader have some info in context, I'm sure you'll get some focused assistance.
Virtually Inert Person
Windows 10 Access 2016
Members and payments are to be in different tables, yes?
There are no doubt several ways to handle this. Simplest is having a checkbox field to identify their status, such as "Active". Your queries/forms only show those who are.
Or make Active (or Inactive) a date field. If no date (null) same as the unchecked checkbox field but now you have a date for when they became that.
Or have a field "Status" for when it is not a simple Y/N or Date/Null thing but is one of many possible values.
Whatever you do, don't move records around from one table to another and back again. It's very clunky and not necessary.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Novice
Windows 7 32bit Access 2003
Micron,
Thanks for your reply.
After reading your answer it made me realise that I was over complicating things.
All I needed was to keep the names and addresses, which will most probably be used again for next years renewals.
I then deleted all the Data that would not be relevant until they renewed next year.
As I fill in the forms new data I will use the amount paid, date paid, and other changeable values in Queries to provide the appropriate Reports etc....
Thanks again your answer made me think "out side the box".
Roger
Virtually Inert Person
Windows 10 Access 2016
Are you sure that's wise? You nor anyone else can think of a scenario where you might need to refer to historical data?I then deleted all the Data that would not be relevant until they renewed next year.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Update records in form
Update query not updating records even though message stating about to update records
Posting Permissions
Reply With Quote