Two questions

  • Thread starter Thread starter 1encapdiva
  • Start date Start date
1

1encapdiva

Hey everyone,

I have two questions:

1. I have created a patient manager database that tracks appointments,
billing, and medications. I have 4 subforms within a main form. I want to be
able to create one main record with subrecords for appointments, billing, and
medication associated to it. Can this be done?

2. Everytime I am in the database, other users can't save their records. How
do I change this and still limit user access?

Thank you in advance.
 
Hey everyone,

I have two questions:

1. I have created a patient manager database that tracks appointments,
billing, and medications. I have 4 subforms within a main form. I want to be
able to create one main record with subrecords for appointments, billing, and
medication associated to it. Can this be done?
Click to expand...

Yes.

There are no "subrecords" though, really! And data is not stored in your
forms. If you started with Forms, without a set of properly designed tables,
you're on the wrong track. What are your Tables? How are they related? Do you
have "one to many" relationships between the table displayed on your mainform
and the tables on your subform?
2. Everytime I am in the database, other users can't save their records. How
do I change this and still limit user access?
Click to expand...

Your database should - must, I'd say - be "split" into a Backend containing
only the tables, and a Frontend containing the forms, reports, queries and
code. See http://www.granite.ab.ca/access/splitapp.htm for a thorough
discussion.

Do note that any such database is covered by the very stringent HIPAA patient
privacy laws in the United States, and by similar laws in most other
jurisdictions. Some would argue that an Access database cannot be made
sufficiently secure to comply with those laws; at the very least you need to
be aware of the laws and what they require (unless you have several tens of
thousands of dollars to spare for fines). I'd REALLY suggest that you get
professional help from someone well versed in HIPAA (and I'm not such a
person).
 
Thanks John. You are right. The data is stored in a table. And, yes, only
personnel with user rights to the share can access the database (it's my job
to know HIPPA so I'm good there). It's just when I have the database open,
others on my team can't save their records.
 
And, I didn't create any tables for my subforms. I used the main table and
added fields from it.
 
And, I didn't create any tables for my subforms. I used the main table and
added fields from it.
Click to expand...

That really, really sounds like bad design (if you have a form and multiple
subforms all referencing *the same table*).

More info please?
 
That could be true. What info can I provide to you to help you help me?
Click to expand...

Some indication about the structure of your table (what fields, what they mean
if the name isn't obvious); what real-life Entities (people, things, events)
you're dealing with; how these entitities relate to one another in real
life...

I worry that you have basically a spreadsheet with all your data, and that
your form is just editing different areas of the spreadsheet. That's not how
Access is designed to work!
 
Hey everyone,

I have two questions:

1. I have created a patient manager database that tracks appointments,
billing, and medications. I have 4 subforms within a main form. I want to be
able to create one main record with subrecords for appointments, billing, and
medication associated to it. Can this be done?

2. Everytime I am in the database, other users can't save their records. How
do I change this and still limit user access?

Thank you in advance.
Click to expand...

Further to my response downthread:

I would expect that you would have at the *very least* separate tables for
Patients, Providers, Appointments, Medications, MedicationsPrescribed, Bills,
and Payments. In a fully worked out app you would have more.
 
I decided to start from scratch. I created tables for the main form and the 4
subforms and linked them to each other by "client number." Now, the
information is stored in each table and not creating duplicates. Does that
sound right?
 
I decided to start from scratch. I created tables for the main form and the 4
subforms and linked them to each other by "client number." Now, the
information is stored in each table and not creating duplicates. Does that
sound right?
Click to expand...

Based on the very vague idea I was able to gather from what you posted, all I
can say is "probably".
 
Back
Top