Wondering if access can track visits/progress notes.

[jordancemery65]

Hello. I recently started playing around with Microsoft Access. I took a class in college on Microsoft Applications but that was about 5-7 years ago. I am the Nurse in a Camp Health Center and I was wondering if Access could track visits when campers come to the infirmary. I am not sure how i would go about setting it up. I know I could probably create a form but i am not sure as to how it would be stored. I have started entering fields into Access into a table and i have created a new form to use when we receive a campers health history form, but that is about the most i have done. I have also ran a few reports and set up some reports off of queries... I am loving the program, and i am sure it is going to help me a lot more than excel!!! Thanks in advance



Jordan

[alansidman]

Maybe something like this?

http://www.databaseanswers.org/data_...ctor/index.htm

[June7]

Yes, Access could be used for this. Consider:

tblCampers
CamperID (primary key)
LastName
FirstName
etc

tblVisits
VisitID (primary key)
CamperID (foreign key)
VisitDate
Reason
Diagnosis
Treatment

[jordancemery65]

so, just create a separate table for the visits? How could i create the form? Is there a way to take the tab control thing and when you choose a new tab it would automatically save as the date of the visit?

[June7]

Use a form/subform arrangement for data entry. Main form bound to tblCampers and subform bound to tblVisits. http://office.microsoft.com/en-us/ac...010098674.aspx

Don't understand your question about tab control.

[jordancemery65]

Ok... i guess i wasnt clear... Sorry about that. I was thinking about using that tab control function thingy to type in and have a new date on each tab... But i see what you are saying... have them in the form. I just want to make sure if i do this, i will be able to open up the campers health record, and there i will see all of the visits....

[June7]

The form/subform arrangement will allow that.

[jordancemery65]

Ok, thanks for your help!!! I will go play and see what i can come up with I really appreciate all of your help!! I am still learning this program!! It seems the opportunities are endless!!!

[jordancemery65]

Ok, thanks for your help!!! I will go play and see what i can come up with I really appreciate all of your help!! I am still learning this program!! It seems the opportunities are endless!!!

Ok, so this is probably going to seem really stupid. But, I have created a table called VisitID with the following columns... VisitID, CamperID, Last Name, First Name, Date of Birth, Visit Date, Vital Signs... blah blah blah... But now i am trying to figure out the form... When i open a new form for a new visit I want the name and all of their information to pop up... (all the information that i have already on the CamperID Table for instance their allergies, medications, emergency contact information) I am so sorry if this is a stupid question but hopefully you will have patients with me Can someone point me in the right direction... I am sure there is a thread somewhere that would help... i just couldnt find one

[June7]

Visits table should not have fields for camper names, DOB info. That is in the Campers table.

Did you review the link about form/subform arrangement?

Main form bound to Campers table. Subform bound to Visits table.

[jordancemery65]

I have read the article in depth! I created the form, and subform. However when i click on Form View to see how it looks, it comes up blank

[June7]

Did you bind the form to data - set the RecordSource property?

Is DataEntry property set to Yes?

[jordancemery65]

Did you bind the form to data - set the RecordSource property?

Is DataEntry property set to Yes?

yes, those are all set... Its amost as if there is a white box in front of the fields, hiding them. The field that i put in the header is showing up....

[June7]

Then try setting DataEntry to No. Yes prevents display of existing records when the form opens and allows only entry of new record.

If you want to provide db for analysis, follow instructions at bottom of my post. Identify the form involved.

[jordancemery65]

Camp Agawam Database (newer).zip

I tried each and still no luck.. Was wondering if you could look at it, and tell me what you think... I have attached the file here...