Search results

Count the number of patients a given provider has in his panel... CAn somebody tell what's the problem? Thanks. Groupers are Group 1 - Location Group 2 - Dept Group 3 - Provider count({%dept},{@location name})

Hi All, I have a select case statement and what I want do is, when the vbCancel is selected, I want to go back to the subform control's original value. any ideas? Many thanks in advance. Jim Code: Private Sub Command38_Click() Dim ctl As Object Cancel As Integer Select Case...

Hello everyone... I have a form that I want to copy selected field values to another form & subform. I have no problem copying some field values to frmEndorsement... but I can't figure out how to copy the other field values to the frmEndorsementSubform. I tried several ways but I'm still on a...

I just want to ask how can I add two additional multiselect listbox from the code below... right now I only have "lsService" on this code and I want to add "lsCampus" & "lsCategory". any help will be greatly appreciated... Jim :confused: Dim MyDB As DAO.Database Dim qdf As DAO.QueryDef...

Hello everyone... I have a query that looks like this : QryPatientInfo PatientID____PatientName____Modality____Notes____NDate 00001----------Doe,John---------FMCD---------text1-------01/01/05 00001----------Doe,John---------JJTX-----------text1------02/01/05...

Hello everyone, I have medication & diagnosis field in my query and I would like to print all the medications & diagnoses of each patient based on their monthly diagnoses & medications. each patient could have several diagnoses & medications per month. here's the report example: Unit PT Name...

Hello to everyone... I have a calculated(unbound) text field named(Age) on my main form. The Age is calculated based on patient's DOB(Date of Birth) Field using datediff function, and in the subform, I have a field named (AgeNo). There is a criteria for AgeNo Field depending on (Age) field for...

Is there a way I can create a menu for all network printers so users can choose which printers to use when they print reports? My boss basically wants to have users to print reports on a specific printer. Is there a better way to do this? Many Thanks... :confused:

I have a situation where I can't decide if I should have a report based on two queries or create a report based on multiple tables... My problem is how can I return values in my first condition even if the second condition is met, not met or null. I tried to making a report based on two...

Could somebody please tell me what is the problem with my query? I'm getting a type mismatch error and I can't find what's the problem... In my query, I have Patient_ID, Psych_visit, & Diag_Code (see table,query & module below). Many thanks.... ---TABLES--- Diag_Med_TBL Patient_ID (text)...