If... Then

[Aaron]

I work for a hospital and, as a courtsey, we maintain 'custom test profiles'
for our doctors. Every year we need to send out a letter that details which
tests are in their profiles, how much they cost if insurance won't cover it,
and a 'CPT' or billing code. The doctors indicated whether or not they want
to continue to use the profile, sign it and return it to us. Each doctor in
the practice needs to sign the form.

Each profile can contain any number of tests and different profiles can
contain the same tests (but they won't repeat in the indivudual profiles).

I was curious if there was a way to build an Access program that will do the
following:

1. When a profile name is selected, it will display the names of the tests
in that profile
2. When the test information is displayed, reference display the CPT, cost
and test name information (preferably formatted in a table, as doctors like
things to be neat)
3. Allow this information to be printed in a form letter.

I'd also like to build a feature that, when a practice name is selected, all
of the doctor's names appear at the bottom of the page (to allow them to sign
over their printed name).

I can build the databases with minimal trouble, and even possibly import it
from an Excel spreadsheet, but I'm not sure how to code the macros in. Is
this something that can be programmed in Access or am I barking up the wrong
tree?

Thank you!

 

[TonyT]

Sounds like Access is just the sort *container* you want for doing everything
you have outlined - careful table design will allow many ways to draw
together and display the information, and you have all the versatility of
Reports to print out single or batch run letters.
My only comment would be to avoid macros, and use the Events procedures in
forms to manipulate your data if required with vba code - more akin to excel
macros than the macro functionality of Access.

Good luck!

TonyT..

 

[Aaron]

Thank you. I'm going to need all the luck I can get.

Is there a manual or walkthrough I could look at? I don't have much
expirence with Access (short of the usual messing-around I do) but I'm fairly
decent when I have something to go off of.

Thank you again

 

[TonyT]

There's loads of books available on Access & vba to cover most skill levels,
if you search this forum someone was highly recommending a couple not more
than a few days ago - might be a good starting point. Either that, or pile in
and start playing around, If you starting from scratch you can't really do
any harm!!!

TonyT..