Search/selecting...oh dear

[lynsey2]

OK dafty here again

Question?

i have a form(select patient)

I want the form to search for a patient when the doc either types in PAtient Number OR patient Name OR Dob

I want the rest of the feilds to be filled out when the serch finds the patient

i want to select that patient so when the doc is doing a prescription that patients details are on the prescription.

and well thats pritty much it i thought of DoCmd.FindRecord but not 100% sure if thats a good idea -cant get it to work either!
help
TA
lyns

 

[cogent1]

What's wrong with a combo box, O daft one?

 

[ColinEssex]

Hi Lyns

Why arn't you using your flag I sent you?
Col

 

[lynsey2]

oops! hang on a sec......getting the flag
there are over 500 patient so a combo box well i recon that would be tooooo confusing 4 docs

 

[lynsey2]

em... ok cant do the flag just now ill c 2 that l8r

I can work out this search thingy and its doing my nut in dont think this job shows my strong points...im sure i do have some somewhere hopefully this time next yr ill b btr

 

[lynsey2]

got the flag cant get it to go on to my profile thingy

 

[cogent1]

not rational

I can't understand your aversion to combos. The doc types in a Number or Name or DOB and up comes the corresponding results. Where's the difficulty? He/she doesn't have to search the list!

You'll have difficulties anyway if you're searching for a non-unique string, because Sod's Law ensures you'll have two Hamish McTavishes born on 1/1/1901...

A combo's the easiest route to success. That's why they're in every database you see...

 

[lynsey2]

got that!

thing is really...I have been asked to do it different.

they want a screen that the doc can go into type the Patient Number (if they know it) click on search and show that patients details
Didnt think a combo box would be good as they would have to look through it and find the number to select.

the patient name and dob thing is just so they can search for a patient even if they dont know the patient number.

I am prob just not being clear. Im trying

 

[lynsey2]

sorry....


I also need it so that when they have done the search and found the patients details they can go into the prescription screen and prescribe a prescription for the patient they have selected

 

[lynsey2]

They want the select patient form so they can first go in and search the patients table to find the patients name dob address etc
and when they go into meth prescription and do that prescription the patient that they have selected will be the patient for that prescription
BUT
when they go int art prescription they want the same patients details displayed so they can prescribe art for that patient aswell

in other words they dont want to have to select the patient in each differen prescription screen just select them once at the start till the end of the session!
dont have a clue just tryed a combo box but i dont get it to do what i want..
help!

 

[Hayley Baxter]

Lyns

Calm yourself down, no need to get all stressed. Databases are fun! Ok I helped my friend once upon a time with a database that is a little similar or sounds similar to what you are doing. If I get a little time before Friday I'll change the design a little and send it to you, will maybe give you an idea.

Hay

 

[Hayley Baxter]

What's your email again? I am not so far from finishing what I'm thinking you're asking for but I will need your email to send it! If It's not what you just let me know.

Hay

 

[cogent1]

don't get your sporran in a twist....

Databases are FUN???? I think not.....unless you are very good at them, which most of us are not.

If you are dead set against combo boxes, there are still ways to accomplish what you want. BUT, if you allow free entry, rather than using a list, you're going to get more keyboard errors. To call up the record you want, you have to write some code that inserts what you enter into the WHERE clause of an SQL statement. If you want to use three separate criteria for selection, you will have to find some strategy for choosing one record from among several e.g. where several patients have the same birthdate, you will have more than one row in your query and you'll have to whittle down to one.


Don't forget, that you can have a form open with your patient's primary key (and all sorts of other data )displayed and use this to supply a parameter or parameters to any queries you want to run, so maintaining continuity is no problem. Once you've retrieved the patient details, just leave the form open and , say, to call a report , just add Forms!MypatientForm!MYID field as a criterion in the report's query.

HTH, but you're probably ready to cave my skull in by now......

 

[Hayley Baxter]

I think they are fun Cogent1, I'm by no means the expert our very own Pat Hartman is but I have a good bash and I have posted some silly questions right here on this forum but quite frankly I enjoy the challenge. If I knew how to do everything in a job I would be oh so bored.

Hay

 

[ColinEssex]

Hayley is right - the challenge is the fun part. Making things happen to how the users want and adding clever little things make it worthwhile.

In my case, working for the NHS, some of my databases have directly helped the patients care and welfare, when that happens you feel kinda proud that someone may be getting better or quicker treatment because of what you've sweated over and created.

I just wish I was an expert like others on this forum.

Col

 

[cogent1]

FUN IT's NOT!

I call FUN being in good company, laughing and carousing, enjoying wine, food and flirtation! Not much of that when you're stuck deciding which event procedure to use and finding that none of them work anyway!

But I will concede to a certain weary satisfaction on the odd occasion when things actually go right... it ain't fun.

What me? a pessimist?

All the best

Colin

 

[cogent1]

FOR COL

So do I Col, so do I!

Anyone got a white flag avatar handy?

Colin

 

[TessB]

Colin,

I beg your pardon, but I know of at least one instance in which you should have been out "carousing with your mates" but instead you were sitting in your office titillating yourself with Access database questions.

You don't have me fooled one moment. I know you love databases.

 

[cogent1]

How dare you suggest that I indulge in self-titillation....!

 

[TessB]

Forgive me..... musing over Access database questions. Better?