 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / July 2005Form Data
I have a form that pulls data from one file it then has two subforms. The data in the main form is updated by a file daily however I would like to know if it is possible to take the data and move it to another table that would contain all the informaion to another table if the person was to leave as they will no longer show up in the data update but we would like to retain the data after they leave as it looked on the day they go. For example: We have a guy that comes in he is here for 2 or 3 years then leaves, he is no longer in the data push we get from the server therefor we would not be able to pull his data up unless we had some way to move it to another table for future reference. Is this possible. Maybe you could set up a table which would hold your "inactive" information. When folks leave, you would move their data to the inactive information table. You may need some type of union query so that you can look at everything together. Linda >I have a form that pulls data from one file it then has two subforms. The > data in the main form is updated by a file daily however I would like to [quoted text clipped - 9 lines] > to pull his data up unless we had some way to move it to another table for > future reference. Is this possible. Or you could add a status field. Regards John > Maybe you could set up a table which would hold your "inactive" information. > When folks leave, you would move their data to the inactive information [quoted text clipped - 16 lines] > > to pull his data up unless we had some way to move it to another table for > > future reference. Is this possible. A status fild would be good however the data in the employee data table gets written over each day with updated information so the emp # and othe associated data would not be there. I would just like to be able to move the information I need into another table and use it with a report or form for if any one needs to go back and look at it again and still have all the data. I tried to do a copy data and append to a new table query however it copys all 2000 + lines I just want it to copy the person who goes not the entire table. > Or you could add a status field. > [quoted text clipped - 27 lines] > for > > > future reference. Is this possible. It sounds like you need create a master table to keep data across the time domain, which means that you would not have to delete information before filling from file. Regards - John > A status fild would be good however the data in the employee data table gets > written over each day with updated information so the emp # and othe [quoted text clipped - 35 lines] > > for > > > > future reference. Is this possible. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.