 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 2005Append from form
Hi, I have a large table of pupil details, each with a unique id number. This feeds through to a number of other tables with differing additional information. The user views this data through forms and it is necessary for users to be able to archive pupils from any of these other forms. Is it possible to write this into the form function in VBA as an afterupdate command? I am fairly new to VBA and am unsure as the the correct language Thanks in advance!! So what happens to a pupil record when it is archived? How is it archived? (command button, automatic based on data values, etc) Is it kept in the same table but filtered out with an Archive flag or moved to an Archive table? We need to know the above info to give a good answer. > Hi, > [quoted text clipped - 9 lines] > > Thanks in advance!! when it is archived, the record remians in the main table, but is not shown on the main form as is now 'is not null' it is archived by picking an 'archive due to' option from a list box on the form or table. there is a seperate sub table 'archived pupils' which the id should be appended to and is then date stamped. i hope this makes sense, thank you for your time!! I don't understand your first statment. What 'is not null' and how are you filtering it? Based on the rest of your post, I wonder if the secondary table is really necessary. My approach would be to have 2 fields in the pupil table. A Yes/No field that would be [ARCHIVED_FLAG] where No would be the default an Yes would mean the student is archived. The other field would be the date/time stamp of the archival. Then I would set the filter property of my form to exclude archived records. Another advantage is you could add a command button that would change the filter so you could see Not Archived, Archived, or both. To do the archival, I would suggest a command button that would update the two fields. > when it is archived, the record remians in the main table, but is not shown > on the main form as is now 'is not null' [quoted text clipped - 6 lines] > > i hope this makes sense, thank you for your time!! thank you for all your help. I have deleted the Archived table and added the additional fields to the master table. I still need to be able to pick the reason for archive from a list of values. I was therefore thinking of picking the value and then using a command button to then add the date stamp to the 'date archived' field. Is this the best way of doing this? Thank you again Your solution will work just fine. > thank you for all your help. > [quoted text clipped - 6 lines] > > Thank you again |
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.