Search results

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...

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...

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...

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...

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...

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...

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...