Search results

I'm having trouble getting my head around this. I have a database that collects stats of patients admitted to ICU. I have a table PtDataTable (pk = PtID) with a one to many relationship with PtVisitTable (pk = VisitID, fk = PtID). The patient visit table has the fields AdmissionDate and...

Hello. I'm sure this is a relatively easy question but I seem to be having trouble with it. We have a database of patients participating in studies. At times we would like to email certain reports. Due to confidentiality reasons we do not want to send patient names by email. How can I print only...

I have an unbound list box that updates the data displayed on the form when a selection is made from the list. Private Sub List13_AfterUpdate() ' Find the record that matches the control. Dim R As Recordset Set R = Me.RecordsetClone R.FindFirst "[HospitalID] = & '" & Me![List13]...

I am having trouble with report values returning as #Num! I have two text boxes that display caluculations based on the number of true values in yes/no fields: =(Sum(IIf([Eligible]=True,1,0))) which is text 8 and =(Sum(IIf([Eligible]=True,1,0))) which is text 10. I then want to divide text 10...

I have a main form that has a tab control with five pages / tabs. Each page has one subform on it that is set to display as a continuous form. The data on each of these pages is from the same table and the primary key from the table exists on each subform. There is also a date field that is...

I am hoping someone can help me. I am receiving this run time error when I am trying to open any database on my computer. I have a number of databases, some are on a network. The databases on the network still function from other PCs, even with my network login used. I am able to use the shift...

I have a small database we are using to schedule staff for training. I have created a report to be used as a sign in sheet for attendance. I would like to have 30 rows print on the report regardless of how many staff have registered to allow for walk ins. I have looked at previous postings...

I have a combo box (ICUAdmittingDx) that has a table (AdmittingDxtbl) for row source. There is a text box (AdmDxOther) on the form that needs to be filled in when specific items are selected from the combo box. There are 13 of these out of a total of 86. I would like to have a message box appear...

I have a database used for tracking patient eligibility for studies. I have a table that stores all the patient’s data that needs to be recorded, a table that stores the eligibility information for all studies on each patient, and a lookup table that lists the studies currently being conducted...

Hello, I'm having trouble trying to adjust a report in which I use IIf statements. I have a database that tracks all the major joint replacement surgeries done. (Total hip replacment, total knee replacement, etc.) In my report, the various surgeries are total for a defined time period which is...

I have found many posts on this subject, but can't find the answer I'm looking for. I would like to create a form requiring user input to generate a monthly report. I have used the calendars often and they work great, but, what I would really like this time is just a form where the user would...

Hi. I have a database where an admission date and a discharge date are entered on a form. From this I calculate the Length of stay. What I'm having trouble with is creating a query that calculates how many have a Length of stay of less than seven days, 8 - 10 days, 11-14 and >14, along with the...