Recent content by bilakos93

thank you. Do you think there is a way to make it more friendly to the eye on the report that is then printed? Maybe group by name also?

hello again! Thank you for your input. After having a thought, I created an extra table (tblHospDept: HospDeptID, HospDept), added a field on tblBookings (HospDeptID) and I also put a field on the form underneath the rest of the appointment stuff (date, type of scan etc). I have changed the...

Thank you Thank you You mentioned some indeed very interesting points but my main question is: how do I display on the report the department for the inpatients (medicine, surgery etc)? Unfortunately the appointments are currently on paper, so no need for HL7 messaging or anything like that...

Hello I am in the process of creating a database for hospital ultrasound appointments There are inpatients, outpatients. Being an outpatient means that you may be booked in a morning list (which is free of charge) or an evening list (which you'll have to pay a fee). We don't do evening lists...

just for the records this seems to be doing the job Public Function CheckAdmissionOverlap(StartDate As Date, EndDate As Variant, StudID As Long, TableName As String, ByVal FormName As String, ByVal IDFieldName As String) As Boolean ' Function to check if there is an overlap with existing...

it's tblCovid and frmCovid It's entirely like admissions in a hospital A studID can have an entry with startdate 1st Feb and no enddate. When someone tries to enter a new admission with startdate 15th Jan and enddate 20th Jan should be allowed to. They shouldn't be allowed though to enter an...

thank you I've got the point but i'm struggling to handle my null data.

hello people!! I have a tblCovid where essentially I keep hospital admissions (StudID, StartDate, EndDate). EndDate can be null if the Stud is already admitted what I'm trying to do is create a vba code which will prevent users from entering overlapping admissions. This how far I've come so far...

would you mind explaining why you put a timerinterval on a few instances?

thank you

hello again everything works fine apart from a small detail when editing records the warning box pops up as it recognises the record being edited overlapped by the new one (which are essentially the same) I could add a line excluding the current record from the function but this may create...

thank you!!

Here is my db Thank you

thank you that works well when navigating through records i want the subform though to change each time a value from the combobox is selected when creating a new record e.g.: when trying to create a new record. user selects employee3. subform shows employee3's leaves. then user selects...

Hello all I have a tblEmployees (ID, EmpName), tblLeaveType (ID, LeaveName), tblEmpLeave (EmpID, LeaveID, StartDate, Dur) I have a split form for entering data on the tblEmpLeave (combobox EmpID + EmpName, combobox LeaveID + LeaveName, StartDate, Dur) I want to add a subform where all the leaves...