CaseManagement

[Joe]

Hi all,
Just created a database to keep track of case management for clients. I
have all demographics, types of case management intervention, but I'm having
problems with the notes.

How can I make the notes field do auto spelling? How can I add
"relationship" with ClientDemoghapics and types of case management with the
case management notes field?

 

[PieterLinden via AccessMonster.com]

Hi all,
Just created a database to keep track of case management for clients. I
have all demographics, types of case management intervention, but I'm having
problems with the notes.

How can I make the notes field do auto spelling? How can I add
"relationship" with ClientDemoghapics and types of case management with the
case management notes field?

Hard to explain without pertinent details about the structures of your tables!


Your description is not complete somehow. When I wrote one of these a
million years ago, the basic structure was:

CaseWorker---(1,M)---Case---(1,M)---CaseNotes

You can just include a text field in your CaseNotes table that indicates what
kind of note it is. The foreign key tells you which case it's related to.

Spelling... figured Terry would have it, and of course, he does!
http://www.accessruncommand.com/codeex/269.htm

 

[PieterLinden via AccessMonster.com]

Hi all,
Just created a database to keep track of case management for clients. I
have all demographics, types of case management intervention, but I'm having
problems with the notes.

How can I make the notes field do auto spelling? How can I add
"relationship" with ClientDemoghapics and types of case management with the
case management notes field?

Hard to explain without pertinent details about the structures of your tables!


Your description is not complete somehow. When I wrote one of these a
million years ago, the basic structure was:

CaseWorker---(1,M)---Case---(1,M)---CaseNotes

You can just include a text field in your CaseNotes table that indicates what
kind of note it is. The foreign key tells you which case it's related to.

Spelling... figured Terry would have it, and of course, he does!
http://www.accessruncommand.com/codeex/269.htm

 

[roccogrand]

Joe,

In Access 2007, auto-correct is controlled by Access Options as a Proofing
feature. Use the Office button to add words to the global dictionary.
Alternatively, add words to the Office dictionary in MS Word and they will be
enabled in Access (and PowerPoint). You can also customize the Word 2007
interface by adding an Auto-Correct icon to make faster changes to the
dictionary--again via the Office button.

HTH,

LDN