Search results

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

Rich, Thanks so much. I didn't find that previous post when I did my search. It was very helpful to actually see it in use. I was missing the call SetCount function in the group header. I appreciate the help.

I would like a total of 30 rows including those that have signed up for the session. So if 15 have registered, I would like the 15 names on the list and 15 blank rows. Thanks.

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'm sorry to keep at this but, believe it or not, I'm still struggling. The message box does not come up. Because the list for the combo box is so long, I have the items divided into categories. I have an ubound combo box that the users first select a category from and then the combo box only...

Mile and Delboy thank you for your responses. I think I will go with Mile's solution. Mile, thank you for taking the time to explain this so completely. It is so clear now that I was looking at it the wrong way. Your efforts (and all others who help here) are very much appreciated.