RKFerguson
07-30-2013, 11:31 AM
Hi Folks,
I have an MS Access project comprising four tables. I use one of those tables to conduct assessments. What I want to do is be able to archive that table when I finish an assessment,
then remove the contents of several fields in every record, so I can then reuse the database to conduct another assessment. But, prior to conducting an assessment, I want to be able to prompt for an input value, the push that value to a field in every record.
I have an inkling that I may be able to accomplish this with a Query, at least the arching part, but I would prefer to do it in VBA.
Can you help or point me to references?
Thanks,
Fergie
I have an MS Access project comprising four tables. I use one of those tables to conduct assessments. What I want to do is be able to archive that table when I finish an assessment,
then remove the contents of several fields in every record, so I can then reuse the database to conduct another assessment. But, prior to conducting an assessment, I want to be able to prompt for an input value, the push that value to a field in every record.
I have an inkling that I may be able to accomplish this with a Query, at least the arching part, but I would prefer to do it in VBA.
Can you help or point me to references?
Thanks,
Fergie