Search results

Drug after a : tends to give me :Drug this was not intentional, he he, found it funny though but just to let you know the very last smile was a smile the others b4 were Drug!:D

Do a qry that lists all the variations Of your data. e.g. say if they select 1, in box two 1 Could come in w,e,h. if they select 2, box two could come in w,p,v.if they select 1,w, box three could come in p,l,o BUT if they select 1,e, box three can come in a,b,c. you need a qry of this...

i think i kinda did this... i had a drug in one box and in the next box the Forms that that drug came in and then the frequencey that drug in that form came in etc... is that kinda what you are looking for??? let me know and ill try and help!

I have got a button on one of my forms! the button runs a qry!and displays the result in a table like format i need to be able to select one of the records from this table. i need the selected record to fill out fields in the form. e.g. a patient has a history of prescriptions, click on the...

i already have a link to this site on my page but i have just used the logo! is that ok?? ill change it if not!

im not gonna even tell you i dont know how to convert back to 97....:D the unbound Text box shows the patient number as soon as i select it from the combo box.:rolleyes: what is it with me...it should work yet again but doesnt, bet if someone else had done it everything would work like a treat!

Rich just tried doing what you said and it doesnt change anything! it works in the fact that the unbound combo shows patient number but when i click on the button to see the basline it still asks for the patient number.

Cheers guys! Ill give that a bash and let you know how i get on! Thanks for replying. :D

right my combo box is called combo43 it is not bound! patient number is the first column. i tried making the combo box bound to patient number and it doesnt like it, i also tried that code and got an error message i have created a qry to do this included all the feilds in the table and in the...

thats what i have Forms!Search_Patient!combo43 thats using the patient number criteria bit!

still didnt work this out...any clues welcome!:)

Sometimes we all do it, I have! But cols right I realise eventually someone does answer usually within a few days! Next time just post back to yourself in the same thing that brings it back to the top! The time difference like col said has a lot to do with it e.g. I posted at the back of 9 am...

i created my qry using the wizard, in the criteria of patient number i set it up so that it looks for the patient number that is in search patient! then i created a button in the prescription prescribing form called history when clicked on it runs the qry. PROBLEM when clicking on the history...

any other suggestions for me?

thanks, im creating a qry that goes through the history table and matches the selected patient number right now cos well i recon that will be my first point of call, filter the table to only show the selected patients past scripts...its from there ill b stuck! cheers for getting back to me!

i have searched and dont see anything relative.. i would like to have a button on one of my forms, call the button history and when the button is clicked on i would like a pop up form to come up and show either the last 12 or so prescriptions or all the prescriptions that a selected patient has...

Thanx!:D

Mario, i could be doing with a look at your code as this will be my next hurdle! I have heard that Access isn't good for graphs go doing one in excel is cool with me!

ps if anyone fanceys helping me on how i get the report to print out twice once with a date once without i would be very greatful...i will keep checking and let you know if i get it too. THANK YOU ALL!:D

ok right the meeting was bad but i didnt get sacked!YEY! must have given me a kick up the bum though cos i seem to have fixed most of the problems. TO ONLY GET THE CURRANT RECORD I took the filter bit out of my print button code, i went into the report and change the control source of the...