I have a 2006 access database that I have "saved as" a new 2007 database. I have stripped out certain data in the 2007 database, and I want to use the existing "form" and have this form populate the 2007 database. Is this even possible, or do I have to create a new form or completely new file/s for the 2007 Database? Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Existing form to DB file.
- Thread starter prl423
- Start date
Hi prl,
Are we supposed to guess what 'certain' data you have 'stripped out'?
If the form can work, then it will - so try it. If not, then it won't.
Converting to 2007 should work o.k. - depends on the 'certain' data that you have 'stripped out'.
ATB
Darrylle
Never argue with an idiot, he'll bring you down to his level - then beat you with experience.
Are we supposed to guess what 'certain' data you have 'stripped out'?
If the form can work, then it will - so try it. If not, then it won't.
Converting to 2007 should work o.k. - depends on the 'certain' data that you have 'stripped out'.
ATB
Darrylle
Never argue with an idiot, he'll bring you down to his level - then beat you with experience.
I haven't worked with 2007 yet, but I would say you need to:
1. If the form's data source is based on a query, modify the query so it doesn't contain the fields you took out
2. Remove controls whose Control Source is a field that no longer exists
1. If the form's data source is based on a query, modify the query so it doesn't contain the fields you took out
2. Remove controls whose Control Source is a field that no longer exists
- Thread starter
- #4
Let me rephrase the question, both responses dont even come close to the unknown answer.
My questions does not indicate I am working with 2006 or 2007 versions of access. Within access, I have a table named 2006 emp med file, and a form we enter data into that populates the 2006 emp med file. For the new year, I right clicked on the 2006 emp med file, then "save as" and named it as 2007 emp. med file. Then I stripped out the total amounts of dental useage for that field for all employees. Saved the file so that the 2006 data is removed, and that field contains no data in that column for 2007.
However when I go back to the form, it's accessing the 2006 table, instead of the 2007. So I guess this is a linking issue, to link the existing form to the new 2007 table. The stripped data has nothing to do with my question, it's simply a comment to the question. I could have stripped all the data from the fields in the 2006 table, and started a new year, but then employees names, hire dates, etc. would have to be re-inputted into the form to populate the 2007 database table.
There is no problem with the form, and it does work, but is attached or linked to the 2006 table. I want it attached to the 2007 table. When using the 2007 table, the dental field should be blank, ready for input into the new year table, not showing data from 2006. So the questions is this: How do you link last years form, to the new 2007, "saved as" table? Thanks, Paul
My questions does not indicate I am working with 2006 or 2007 versions of access. Within access, I have a table named 2006 emp med file, and a form we enter data into that populates the 2006 emp med file. For the new year, I right clicked on the 2006 emp med file, then "save as" and named it as 2007 emp. med file. Then I stripped out the total amounts of dental useage for that field for all employees. Saved the file so that the 2006 data is removed, and that field contains no data in that column for 2007.
However when I go back to the form, it's accessing the 2006 table, instead of the 2007. So I guess this is a linking issue, to link the existing form to the new 2007 table. The stripped data has nothing to do with my question, it's simply a comment to the question. I could have stripped all the data from the fields in the 2006 table, and started a new year, but then employees names, hire dates, etc. would have to be re-inputted into the form to populate the 2007 database table.
There is no problem with the form, and it does work, but is attached or linked to the 2006 table. I want it attached to the 2007 table. When using the 2007 table, the dental field should be blank, ready for input into the new year table, not showing data from 2006. So the questions is this: How do you link last years form, to the new 2007, "saved as" table? Thanks, Paul
Ahhh, this is why preciseness is important when making a new post. I'm still not sure what "stripped data" means, I guess it is "deleting records"?
I think what you want to do is change the underlying data source of your form, so it points to your 2007 table. I'm not sure if you are saying the 2007 table is another database (another MDB file) - if it is you would need to create a link to it.
However, what you are doing is not a relational database. The date should be a field in your table, and then you could open the form filtered for the appropriate year. That eliminates the need to create a new table every year - and follows proper relational database design.
I think what you want to do is change the underlying data source of your form, so it points to your 2007 table. I'm not sure if you are saying the 2007 table is another database (another MDB file) - if it is you would need to create a link to it.
However, what you are doing is not a relational database. The date should be a field in your table, and then you could open the form filtered for the appropriate year. That eliminates the need to create a new table every year - and follows proper relational database design.
- Status
Similar threads
