Recent content by Fisher

I'm sorry for replying after such a long time. I couldn't back to it. Anyhow, I'm still having problems with the date calculations between different records. The article referenced seems to discuss time calculations for each record. I need to find the elapsed time from the discharge date and...

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

I have used =Left([LastName],1). Thank you for such a rapid reply. I am still learning (obviously) and this forum is always a tremendous resource.

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

That did it! Thanks so much to you both. When I initially checked the DAO option, the error still ocurred. When I changed the priority it worked. Thanks again RG and rborob, I appreciate it.

If you mean relationships, yes they are.

I'm sorry. I'm not sure how to make such a reference. Is it perhaps a matter of checking one of the options in the references list or is there code that needs to be inserted?

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

Thanks for replying. Is there not some way that I can have the response display blank or something other than the error?

Sorry. It should have read: =(Sum(IIf([Eligible]=True,1,0))) which is text 8 and =(Sum(IIf([Enrolled]=True,1,0))) which is text 10. I then want to divide text 10 by text 8.

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

Thank you. Very much appreciated.

Thanks for replying. Yes, sort of. If the user enters a new patient on the main form and then enters only a date on the first page without height and weight, then clicks on the next tab while the cursor is still in the date field, the whole form refreshes.

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