Recent content by lizcliff

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