I have a membership database created by someone who is no longer available to consult. It contains fields to check for organizations joined. The information was for 2008. I am getting ready for a new year and would like to keep the 2008 information but create a new form that clears those fields to insert 2009 information. Do I need to copy the 2008 database and save as 2009. I know this will sound crazy, but how do I do that? When I open the document and click save as it says save switchboard to _____________; save as _____________
The relationship between the members and the organizations should be setup as a one to many relationship. I am guessing that they set it up as a 1 to 1 relationship and you cannot add more records for those members. Could you empty out the data, zip and attach the file as an attachment in a post? Also you do not copy the file within Access you do it when browsing folders in windows explorer. I would not recommend having separate files for each year.
I would just click on the table with the 2008 data, paste it back into the same Access database. (Note, don't Save As.)
You will be asked to name the table (I would first rename the old table to something like "name" 2008 and then name the new one what it used to be called, that way any links, queries, etc. will go to the new table). Also, you will be asked if you want to append to existing data (no), paste Structure and Data (again, no) or paste Structure Only - click in this option.
Then you will have a new table with exactly the same structure as the 2008 one, and, since you used the name that the 2008 table used to have, all the queries, reports, forms, etc. will work.
He does not really want you to rename them. He wants you to copy them and then rename the original tables for 09. Are you going to ever need to track historical values along with current values?
Actually, I would rename them and retain the old tables for as long as needed - but keep the data in different tables. If I wanted to compare person x across years, I would just use a query to link the tables and filter for that person and see the data for all the years combined - or make a new table and append all the data to it.
But for using with a form, I would not keep the old data in with the new - gets too confusing.
Hold down your CTRL key and move the table down. You will have a copy of the table. Select the original hit "F2" which allows you to rename an object and name it 2009. Rename the copy you made to 2008 since it will say "Copy of 2008."
As an addendum after seeing slurpee's post. How I differentiate between old and current data is having a year field within the organizations table. I then have the form sort the record via the year in descending order to see the current records whenever they open the form. It is harder to count fields across tables when you have different years in different tables.
I always have a year field, so I didn't really think about it, but that isn't what I would do - but if I made a query of two tables, I could certainly track changes by including the year field in the query.
OK. I did the control and copy thing and renamed, but I removed the check boxes from the current or 09 table (not all boxes, thank heavens, just a few), but when I looked at the 08 copy those boxes had been cleared in the copy as well. What did I do wrong?
Can I ask why you want a new table for 2009, rather than just adding the records to the original table?
You can restrict what you see on your form by having a Query restrict the date to 2009, but your data would still be available in the same table.
I can understand it - I have several projects that have been going on for 7, 8 years. Keeping everything in one table would be impractical, given that I have to do quarterly reports.
I wanted historical data about memberships. As you can see, I know nothing about access design--I just know how to put info in the forms that were created for me to use. The address book that pulls from the tables lists:
name Member assoc. and X club
address
home phone
cell phone
work phone
email address
same info for spouse
children's names, ages, schools
year moved into neighborhood
We would like to run a report that will show us past memberships in assoc and clubs
Can you post the empty shell for us to look at like I requested before? Like I was saying before and OBP backed up I prefer doing one table with all of the membership information in it. That is not one table for all of the database information it is only for one table for membership information and it will be one table for client information.
Jim, the Op has sent me a copy of the database and it is a Split "Replica", not the original so the design can't be changed. Also it had no Relationships set at all.
I have Imported everything in to a New Blank Database, but the original had a couple of errors so it is possible that the new version may have a few bugs to iron out.
I don't mind your sharing--just don't want it to be info open to public. Tell me how to "strip" data and I'll try to do that. I'm fairly good at following step by step instructions.
Hi gang, been busy on 5 different but related databases today (much like and for the same client as that one you helped me with OBP).
As for stripping your data. First, make a copy of your whole database while it is closed - just copy and paste it. Open the new one up. Go to any table that might have data in it, highlight the data and hit delete.
If you can put in some fake data (John Doe, 555 Anywhere Street, Atlantis....that kind of thing) it will help me more. OBP can figure it out just from the design, but I need something more gritty to work with.
Then zip the file and upload it here using the Go Advanced button below - find the file upload button and follow the instructions....
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
860K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!