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
|
|||
|
|||
Creating a new form everytime a contact is made
I have created a database in Access 2003 to keep track of all of the data
needed for our hospital based bariatric program. The forms created work well. However now my problem arises that originally there was one contact about a month after surgery and the information filled in. Now the staff would like to show multiple contacts for that same patient using the same questions but on differant days or months. What I am trying to avoid is creating a giant form with the same fields listed six times because they might contact the patient once a month for six months or possibly daily for the next year. Is there a way to place a button on the bottom (or wherever) on the form so that the staff would fill out the inital form once, but allow them to quickly build a new form as needed for another contact with that patient as needed? |
#2
|
|||
|
|||
Creating a new form everytime a contact is made
Take a look at Access HELP regarding "subforms".
I believe what you are describing could be displayed using a "main form" to hold the patient info and a subform to display the visit info. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "John" wrote in message ... I have created a database in Access 2003 to keep track of all of the data needed for our hospital based bariatric program. The forms created work well. However now my problem arises that originally there was one contact about a month after surgery and the information filled in. Now the staff would like to show multiple contacts for that same patient using the same questions but on differant days or months. What I am trying to avoid is creating a giant form with the same fields listed six times because they might contact the patient once a month for six months or possibly daily for the next year. Is there a way to place a button on the bottom (or wherever) on the form so that the staff would fill out the inital form once, but allow them to quickly build a new form as needed for another contact with that patient as needed? |
#3
|
|||
|
|||
Creating a new form everytime a contact is made
On Tue, 5 Jan 2010 10:25:01 -0800, John
wrote: I have created a database in Access 2003 to keep track of all of the data needed for our hospital based bariatric program. The forms created work well. However now my problem arises that originally there was one contact about a month after surgery and the information filled in. Now the staff would like to show multiple contacts for that same patient using the same questions but on differant days or months. What I am trying to avoid is creating a giant form with the same fields listed six times because they might contact the patient once a month for six months or possibly daily for the next year. Is there a way to place a button on the bottom (or wherever) on the form so that the staff would fill out the inital form once, but allow them to quickly build a new form as needed for another contact with that patient as needed? STOP. You do NOT need multiple forms for multiple records. Your visits are not stored in Forms! Your patients are not stored in Forms! Information about both are stored in Tables; and the Forms let you manage data stored in those tables. A form is just a window, a tool to let you look at and edit data stored in a table. If you have a one (patient) to many (visits) relationship, you need two tables: a table of Patients (with a PatientID as a primary key) and a table of Visits (with fields for the PatientID as a link to Patients, VisitDate, reason for the visit, weight at the time of the visit, whatever other info you need). Take a look at some of these resources. Crystal's tutorial and video might be the best start: Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html Roger Carlson's tutorials, samples and tips: http://www.rogersaccesslibrary.com/ A free tutorial written by Crystal: http://allenbrowne.com/casu-22.html A video how-to series by Crystal: http://www.YouTube.com/user/LearnAccessByCrystal MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Creating a new form everytime a contact is made
John V. is quite correct to point out that the tables store the data, not
the forms. I mis-spoke ... you need a main form to DISPLAY the patient data and a subform to DISPLAY the visit data. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "John" wrote in message ... I have created a database in Access 2003 to keep track of all of the data needed for our hospital based bariatric program. The forms created work well. However now my problem arises that originally there was one contact about a month after surgery and the information filled in. Now the staff would like to show multiple contacts for that same patient using the same questions but on differant days or months. What I am trying to avoid is creating a giant form with the same fields listed six times because they might contact the patient once a month for six months or possibly daily for the next year. Is there a way to place a button on the bottom (or wherever) on the form so that the staff would fill out the inital form once, but allow them to quickly build a new form as needed for another contact with that patient as needed? |
#5
|
|||
|
|||
Creating a new form everytime a contact is made
On Jan 5, 1:25*pm, John wrote:
I have created a database in Access 2003 to keep track of all of the data needed for our hospital based bariatric program. The forms created work well. However now my problem arises that originally there was one contact about a month after surgery and the information filled in. Now the staff would like to show multiple contacts for that same patient using the same questions but on differant days or months. What I am trying to avoid is creating a giant form with the same fields listed six times because they might contact the patient once a month for six months or possibly daily for the next year. Is there a way to place a button on the bottom (or wherever) on the form so that the staff would fill out the inital form once, but allow them to quickly build a new form as needed for another contact with that patient as needed? I REALLY wanted to answer this one because it's within my set of skills but John and Jeff just HAD to steal my thunder. Could you smartie pants MVP-types please leave these more fundamental posts to users like myself who might find some bit of joy in being at least a little useful? I mean, don't you have something more challenging to help with? Really. |
#6
|
|||
|
|||
Creating a new form everytime a contact is made
On Tue, 5 Jan 2010 17:33:17 -0800 (PST), johnlute wrote:
I REALLY wanted to answer this one because it's within my set of skills but John and Jeff just HAD to steal my thunder. Could you smartie pants MVP-types please leave these more fundamental posts to users like myself who might find some bit of joy in being at least a little useful? I mean, don't you have something more challenging to help with? blush Nothing stopping you from posting your own (at this point probably very helpful!) point of view! -- John W. Vinson [MVP] |
#7
|
|||
|
|||
Creating a new form everytime a contact is made
Hi, John
I thought you and Jeff covered it pretty nicely - as always! On Jan 6, 12:11*am, John W. Vinson wrote: On Tue, 5 Jan 2010 17:33:17 -0800 (PST), johnlute wrote: I REALLY wanted to answer this one because it's within my set of skills but John and Jeff just HAD to steal my thunder. Could you smartie pants MVP-types please leave these more fundamental posts to users like myself who might find some bit of joy in being at least a little useful? I mean, don't you have something more challenging to help with? blush Nothing stopping you from posting your own (at this point probably very helpful!) point of view! -- * * * * * * *John W. Vinson [MVP] |
#8
|
|||
|
|||
Creating a new form everytime a contact is made
Now if we could just get a life!
Jeff B. "johnlute" wrote in message ... Hi, John I thought you and Jeff covered it pretty nicely - as always! On Jan 6, 12:11 am, John W. Vinson wrote: On Tue, 5 Jan 2010 17:33:17 -0800 (PST), johnlute wrote: I REALLY wanted to answer this one because it's within my set of skills but John and Jeff just HAD to steal my thunder. Could you smartie pants MVP-types please leave these more fundamental posts to users like myself who might find some bit of joy in being at least a little useful? I mean, don't you have something more challenging to help with? blush Nothing stopping you from posting your own (at this point probably very helpful!) point of view! -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|