Search results

I am building a database to keep track of isolated patients. Can anyone think of a way to keep track of the number of days that a patient stays in a room, and be able to change the location of the patient without creating a whole new record, while keeping a running tally of the number of days a...

Hi there, I have a database that keeps track of adverse incidents in a hospital. I'd like to provide some feedback to individual managers in a general form, and then see how they'd like the data presented in the future. Im thinking I could provide summaries of total incidents from...

Actually, no it doesnt seem to be populatiing my table at all.

Yes, had to comment out the [K#] Field out too, AND the MSGBOX saying it was succesfully added, and the close function. BUt it seems to work well after that :P I wish I was smart. -Z

Could the error simply come from the way I am trying to get a new record added, in particular on the opNew (option box) line. I haven't used that type of control before.

I really have no idea the differences between ADO and DAO. Should I switch? Is the other one easier? Z

Thanks rural. I fixed that line and I no longer get that error. Now it is throwing me: Run-time error '-2147217887 (80040e21):' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. The debugger points to this line...

I dont remember where I got it, but it works like a charm, here's the other similar code. Private Sub rmAddIncident_Click() Dim err As Integer Dim cnn1 As ADODB.Connection Dim Risk_Data As ADODB.Recordset Dim strCnn As String 'Check that all fields are filled in rmENCON.SetFocus...

I'm not really sure what you are getting at, Im pretty new to VBA, but I took all of the framework for this code from allen browne's page. I have identical code in another DB that seems to work fine. Can you go into a more detailed explanation of your last reply? -Thanks, Z

I tried replacing Dim tblCase As ADODB.Recordset with Dim tblCase As Recordset I get the error: Method or Data member not found. The yellow arrow in debugger points to the "Private Sub cmdAddNew_Click()" line. And tblCase.CursorType = adOpenKeyset is highlighted in blue (the BOLD...

I receive the same error.

Hey guys, Im trying to build a new database project from scartch and I have copied exactly my code from a similar project (I think.) I cannot find out why the type mismatch error 13 gets thrown at me when I fill out the form and try and add the record. Private Sub cmdAddNew_Click() Dim...

Ok, I've chopped it down to size enough so that I can upload it. I'm trying to get totals for the following: Under the "type" "Treatment/Test/Procedure" I want the totals of each specific type (these can be found in the table: "SpecificType_Treatment/Test") Please let me...

Ok, sorry about that. I am using 4 fields in this query. Date, Type, Specific Type, and Location. There are 5 "types" of records, each with it's own set of "Specific Types". Location is a numeric field, and date is just a date type field. I wish to display the totals of all the "specific type"...

I think I've nearly got it. The only problem is that I am not getting the totals over the selected time period, I am getting the totals for each day between 1/1/2008 and date() that fits the bill.

I think my question is even more general than that. What type of query do I need to do this? Crosstab? I want the end result to look like a pivot chart. -Z

I have a database that logs incident reports. It logs things like the type of incident (complaint, fall, medication error), specific type (which are subtypes ex: falls -> slipped, tripped etc.) location, and that sort of thing. I want to build a query that displays the totals for each...

Oh! THOSE kind of relationships!

Thanks Gemma and Kafrin, Just to be clear, this database would only be used by infection control practicioners, who are support staff in my organization. It's purposes are to help manage the resources that deal with the isolation of these patients and effective communication between front...

Hi there, Im am building a new database to keep track of infections and infection precautions. I am trying to decide whether to keep track of multiple infections and date ranges in a single record or to separate one patient's infection precautions into more than one record...