Search results

I've took all patient detail out replaced with dummy - just a handful and added two referrals ive tried to add therapies too. https://www.dropbox.com/s/s12er4u11nau4f8/stroke%20liz%20test.accdb?dl=0 (not sure you can share DB on here) i just cant get the Ids to link f - eel like starting...

I think I know why because I have it as data entry, it is creating a new ID like it would in the original table as its autonunmber. if I put it to no data entry I cannot have it as a search / combo box?

hi ii tried this and I just get the main form is not open message?#

I might re do the sub form see if that works; with the code of opening form in it to start with. is there a way to search for a patient number and referral date to ensure I get the correct referral, as a patient could have two referrals so I need to know which one to enter the therapy data to.

they are still linked: in the sub-form properties its all still then same

Hi I hope I have done this right; signed up to dropbox to hopefully share a pic.. https://www.dropbox.com/s/zmswjjzvuet92w5/subform1.png?dl=0 its just adding a new referral each time when populating sub form instead of using referral selected :banghead:

Hi its working! as soon as I enter some data input into the subform it the brings through the ID giving the link however; its a new referral ID that is being generated in subform instead of the one already there in referrals form. I took data entry off that form but then it auto populates...

thank you - how would I post a sample? I do have confidential details within it, unless I could post pics of each form or would that not help

Hi I could not get my subform as form view, even though default shows as form / single form etc - there is no option on subform properties. so I did an event proc on opening the form: DoCmd.RunCommand acCmdSubformFormView which worked! however now my master and child links seems now...

Thanks. Do you think I should just have a referrals table, with a lookup to my patient pool to find the patient to add to referrals and not have a patients table. this is all based on referrals, all other forms (the referral could go to an outpatient form or an inpatient form or a therapy...

No Patient ID is just an autonumber to give a primary key patient number is a number like CC00123456 although I will only want 1 patient number in the table I maybe don't need this ID? but as I am linking to our national patients table I needed a table of just our patients in this service but...

I am creating a database to capture new referral information. So I have a patient table and a referral table to capture the data. I have created a form to set up new patients to add to the patient table. Patient number combo box has a control source of patient number from the patient table...

I'm afraid not. I have passed it onto a colleague who knows how to do it, in theory but has struggled a lot and is Stil trying to develop it. I Wil share once I know Sorry

Hi I will try best to explain what i need if you are able to help me; its, let say taking up a lot of my time trying to figure it myself :( I have a dataset of patients being discharged with a SpellEndDateTime and a CompDateTime. Now i need to calculate whether is was 24 hours between...

I have come stuck with different types of times fields. i have one time minus another in an access query which i then export to excel pivot and within the pivots i have that time as an average - but when it is a minus time it wont display! so then i thought i could change the calculation to a...

thank you im not sure i understand i create a table for all the objects and create a table for all the elements then create a table for all the object IDs and element IDS? whats the element value? thanks

Hi first post (apart from introduction) i orginally thought i should do this in excel but i think when the dataset becomes larger and i want to eventually get it on the web - i thought its access i need? anyway: i have created a mini dataset as an exmaple of what im trying to explain...

Hi im liz, from the UK. ive joined this forum becuase I am in constant need of help when it comes to access for little things needed for me to get my job done. I work as a data analyst with some experience of access (i can write queries and automate them to run alongside excel, where i...