Clinic database filtering

[eklausen]

In setting up a psychology clinic database we are running into a
problem (that might very well have a simple solution). We need to set
it up so that when a therapist logs in, only that person's clients
should in further forms be available. This filtering of what shows up
when going to subforms has to be repeated again so that when the
therapist goes into forms regarding a specific client, only that
client's information will show up (e.g., each week the clients fill out
questionnaires regarding how they are doing and this information is
then entered into the database -when entering or reviewing that
information, only that client's questionnaire answers should appear).
Problem is, I have no idea how to set up something like that (although
I suspect some kind of Macro would be involved). Any suggestions?

 

[Jeff Boyce]

I'm not entirely clear on the system you're describing. Do you mean you
have a clinician log into a system/application and you want everything s/he
sees after that to be restricted to his/her clients' data?

Or are you saying that you want the clinician to indicate him/herself on
each screen, thereafter seeing only his/her clients?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[eklausen]

This is an access database where the clinicians log in (using a user
name and password) and should be able to identify himself only once,
and when then going further into the database only getting access to
information connected to his name (him and his clients). At this level
it is both an issue of easyness of use and of security. After choosing
a client, he should only get up information for that client (unless, of
course, he moves back and chooses a new client -at which point only the
new client's information should be shown). At this level it is mostly a
matter of easyness of use.Thanks for prompting this clarification.

 

[Jeff Boyce]

If you have your clinician logging on, you should be able to capture the
identity of that person. If you create a variable in a code module that is
set to the clinician's ID/identity, you could modify your queries to "fill"
your forms and reports only with that clinician's clients' info.

That is, assuming that your data tables of client info include some way of
pointing back to the clinician's ID. Since you haven't really described the
data structure, I can only assume that you've captured this information.

Regards

Jeff Boyce
Microsoft Office/Access MVP