JockVSJock
Technical User
I will try to explain this the best that I can...
Myself and a co-worker created an Access form where we entered in a person's first, last name, there phone number, and then three checkboxes for a successful contact, message left, and did person attend the meeting. Also a comments field. It worked great the first time, my coworker and I keyed in all of the data into this form as we called.
Little did we realize that this was going to be a monthly process. We went to use it again this month, and we weren't sure what to do. I created a table to input this info. for the month of June. But for the form, how do I clear out the past months data for the data that is not static: Like Successful contact, message left, attend meeting, and comments. These will be different every month.
Also, we have all of the static info. in a mainframe database. How do I make it work so if the mainframe database it modified, the chage will take place in my Access database?
Any other advice would be great...
thanks,
-Chris Miller
Myself and a co-worker created an Access form where we entered in a person's first, last name, there phone number, and then three checkboxes for a successful contact, message left, and did person attend the meeting. Also a comments field. It worked great the first time, my coworker and I keyed in all of the data into this form as we called.
Little did we realize that this was going to be a monthly process. We went to use it again this month, and we weren't sure what to do. I created a table to input this info. for the month of June. But for the form, how do I clear out the past months data for the data that is not static: Like Successful contact, message left, attend meeting, and comments. These will be different every month.
Also, we have all of the static info. in a mainframe database. How do I make it work so if the mainframe database it modified, the chage will take place in my Access database?
Any other advice would be great...
thanks,
-Chris Miller