Search results

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

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

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

Hello everyone! I've been trying to use the code below (created by chatgpt essentially) I'm essentially trying to pop a msgbox (and not save) whenever there is a given DiagID for a given StudID on overlapping days e.g. diagID 1 for studID 1 on 10-15 Jan (dur 6 days) already exists. User is...

Hi all I have a database that includes the following tables Students (firstname, lastname, ID, med_check) . Med_check is a date when each student last had a medical check (which is valid for 1 year). It may even be blank Sport_groups (ID, name, students.ID). Each sport group can contain more...

Hi all I have a table that includes names of students. Duration of studies is 4 years and each year new students come in and others graduate. There is a table (students) with everyone's names, last names and unique IDs I have then created a query that runs every time I want to create a report...

Hi all I've only just started getting more familiar with MS Access and SQL I have a table which contains patients details (firstname, lastname, id) and another one where it shows the dates of their admissions accross 4 different wards (from a dropdown list) in a hospital (e.g. 19/8/23-23/8/23...

Hello I have 3 tables Table1: FirstName, LastName, ID Table2: ID, diagnosis (dropdown list), dstartdate, denddate Table3: ID, admissiondate, dischargedate I want to create a query that will display the IDs and the dstartdate and denddate from table 2 and admissiondate and dischargedate from...

Hi all I am not yet fully familiar with MS access so this may be an easy one for some of you I have a table with some patients information and then another one with their hospital admissions. All of them have an admission date but only some of them have a discharge date (cause they are still in...