Recent content by bilakos93

So the steps are - make updates on the accdb file - split it - delete the back end file - keep the accdb - create an accde from the new accdb - distribute the new accde Right?

new records on existing tables

Hello everyone I'm attaching the database after having removed any sensitive information. Just a few points to mention - the main point now is to have multiple scans under one appointment. I'm guessing this will mean creating a new table . My main worry is that I have to make it presentable...

because there have been new data since then on the back end file? Am I missing something obvious?

Hello I have created a database which is split (front end/back end). I've also created an accde version which I have distributed. I have kept the accdb file. I now want to make further changes/small improvements (such as adding some vba code, updating colours etc) on the front end. I assume I...

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