Search results

this is absolutely amazing! thank you so much. i think this could work, it is only in the interim so we can just get the poor patients in :) i may come stuck if a patient requires more than one followup but the odds in 12 weeks will be slim. Absolute star; i crumbled over this friday and was...

ive managed to get it all working putting one patient thtrough each form - works perfect, but when i do it again for another patient the 3rd form ID from the child doenst popualte the table so there is no link. how can the child and master now be affects, is it the control using a query that...

Hi ive had to pull together a booking database urgently with minimal skills; so we can get patients in ASAP due to our PAS system being replaced we cannot add any new clinic slots and patients are desperate to come in. So ive created a mini PAS system in access, to pick patients from a...

Thanks DBGuy - code worked perfect!

here is a screen shot of my row source - ive changed it to just a list - and still nothing?

it just puts it all into a table but that not what I need is it, Should I just type them all into row source? thx

Hi I have made a copy, taking out all patient details, and making up a few to have in there, then compacting it - and its still over allowed amount to upload - how do you get around that?:banghead:

Hi not sure I can with patient detail in, no error just closed form without message warning. erm I used the row source query on my table to bring the fields in - now i've pasted it it doesn't look much like a list - is this why? SELECT tbl_Inpatients.[Haem Discussion with Neuro Centre]...

Hi I had a go, but it hasn't worked. I changed the code to: If Me.[Primary Findings] = "IPH" Then For lngItem = 0 To Me.IPHlist.ListCount - 1 If IsNull(Me.Controls(Me.IPHlist.ItemData(lngItem))) Then Cancel = True MsgBox "Please complete all information in...

Thanks! this is really good and I 'think' easy to understand (for me) I will have a go!! :)

Thanks Db guy - errm blown my mind, how would I do that? sounds good though!

Hi i have a inpatients form with several sub forms on control tabs, on the stroke admission sub form where someone selects primary findings=IPH I need to make the HAEM subform mandatory for all text and combo boxes. Do I do this for each box or can it be applied across all boxes on that form...

wow - that simple :banghead: I knew it THANKS!

Hi I have created a subform within tabs, so all subform are on different tabs, but the form on the first tab (only one I have done so far) is repeated/shown on the 2nd tab - if I delete it , it deletes it from both am I missing something? searched for an answer but maybe I am not asking it...

thanks I think I have found it - that's the event after update? on the combo box

I think this has worked!!! thank you how? ... also is there a way the last patient doesn't show on form when open it again to fins another referral? ive tested it further and it is working! :) thank you so much, I just need to apply this to my original cope with real data once I understand...

Hi I have started from scratch only creating the referral form, and attempted sub form so they are related but I still cannot get the referral ID to equal the ID in referrals. (ignore all formatting I really haven't bothered with it until the joins are sussed) the idea is from a home screen...

thanks i m ight jut have to i think it could have something to do with the referralT1 form when searching for a hospital number, control source is hospital number but i need to be able to search number and ref date to reconcile them to a referral but the data entry clerk only knows the hosp...

Thanks you I have taken all code out and re-saved and able to change from datatsheet to single form - YAY but the ID still shows differently, it should bring in the ID from referrals table when select hosp number so it makes that link.? but the sub forms works without any code :)

thanks does this mean i have to start again...