If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Create a new form as needed
I have a database I created to track contact with bariatric patients who had
the surgery done at our hospital. One of the forms I created allows the nurse to fill in answers to questions when they call the patient post-op. Originally there was only one contact so the form worked well. Now the staff would like to use the same form howerver make it capapble to be used over and over again to show many contacts for the patient without loosing the original data. My first thought was to create a giant form with 7 copies of the same form all in a row so they could fill in for seven contacts. But what if they contacted the patient 30 times? Is there a way to place a button (or something similar) on the form so when the nurse wants to create a new version of the form they can just click something and it automatically creates a new blank form to use without copying over the old one? This way there can be an unlimited number of forms/contacts to be used. |
#2
|
|||
|
|||
Create a new form as needed
This has very little, to say nothing, to do with your form, but rather with
your table structure. What you need to do is have a patient table and then a post-op table which is linked to the patient table by the patient ID. Then you can have a 1-to-many relationship enabling you to have as many entries in the post-op table as required. Your post-op table should contain, amongst other things, the patient id, post-op consult date (this way you can sort the entries in an efficient manner). In this manner, you would either create a sub-form to house the post-op data in your main patient form or create a stand alone post-op form. -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "John" wrote: I have a database I created to track contact with bariatric patients who had the surgery done at our hospital. One of the forms I created allows the nurse to fill in answers to questions when they call the patient post-op. Originally there was only one contact so the form worked well. Now the staff would like to use the same form howerver make it capapble to be used over and over again to show many contacts for the patient without loosing the original data. My first thought was to create a giant form with 7 copies of the same form all in a row so they could fill in for seven contacts. But what if they contacted the patient 30 times? Is there a way to place a button (or something similar) on the form so when the nurse wants to create a new version of the form they can just click something and it automatically creates a new blank form to use without copying over the old one? This way there can be an unlimited number of forms/contacts to be used. |
#3
|
|||
|
|||
Create a new form as needed
Daniel
Thanks for the reply. Maybe I need to be more specific. I already have a post-op table which is where the original form was created from. The form/table works great for the original contact. However, when the nurse now makes the second contact using the exact same questions as the first form; and want to see the old data that was input on the first contact to make sure the patient is following through. She wants to add another copy of the same form to fill in for the second contact. They would like to see the forms in order of contact so they see all of the data. The contacts may happen daily, weekly or just once. I guess I could create a giant form with 10 sub forms all containing the same fields. If they only make one contact then the rest would be blank if they need more then they would only be limited to a certain number of contacts. Is there a way to add a subform (not sure what to call it) with the exact same fields as needed for a person who does not know Access and needs everything done simple. "Daniel Pineault" wrote: This has very little, to say nothing, to do with your form, but rather with your table structure. What you need to do is have a patient table and then a post-op table which is linked to the patient table by the patient ID. Then you can have a 1-to-many relationship enabling you to have as many entries in the post-op table as required. Your post-op table should contain, amongst other things, the patient id, post-op consult date (this way you can sort the entries in an efficient manner). In this manner, you would either create a sub-form to house the post-op data in your main patient form or create a stand alone post-op form. -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "John" wrote: I have a database I created to track contact with bariatric patients who had the surgery done at our hospital. One of the forms I created allows the nurse to fill in answers to questions when they call the patient post-op. Originally there was only one contact so the form worked well. Now the staff would like to use the same form howerver make it capapble to be used over and over again to show many contacts for the patient without loosing the original data. My first thought was to create a giant form with 7 copies of the same form all in a row so they could fill in for seven contacts. But what if they contacted the patient 30 times? Is there a way to place a button (or something similar) on the form so when the nurse wants to create a new version of the form they can just click something and it automatically creates a new blank form to use without copying over the old one? This way there can be an unlimited number of forms/contacts to be used. |
#4
|
|||
|
|||
Create a new form as needed
On Wed, 6 Jan 2010 11:46:04 -0800, John
wrote: Thanks for the reply. Maybe I need to be more specific. I already have a post-op table which is where the original form was created from. The form/table works great for the original contact. However, when the nurse now makes the second contact using the exact same questions as the first form; and want to see the old data that was input on the first contact to make sure the patient is following through. She wants to add another copy of the same form to fill in for the second contact. They would like to see the forms in order of contact so they see all of the data. The contacts may happen daily, weekly or just once. I guess I could create a giant form with 10 sub forms all containing the same fields. If they only make one contact then the rest would be blank if they need more then they would only be limited to a certain number of contacts. Is there a way to add a subform (not sure what to call it) with the exact same fields as needed for a person who does not know Access and needs everything done simple. You're making an easy job much harder. You can see multiple records - the past history of visits - using a Continuous Subform. The mainform would be based on the patient demographics; you could have a Subform (with its default view set to Continuous Forms) for the visit data. This will let the user see data from multiple visits all on screen at the same time, and allow new visit data to be added. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|