Search results

I have a database for capturing OR utilization. On my main form (frmBlockEntry), I list the surgeons' OR block time (including fields StartTime and EndTime). On the subform (frmReleaseEntry), I chunks of the original block that were used, released, or given up to another surgeon, so I'll have...

I have a crosstab query (qryPhysicianLevelbyPayorMix) that references another query (qryChargeTotals for Physician) to determine what percentage of total charges were for each type of insurance. Unfortunately, this query is not producing the results I'm expecting to see. It either gives an...

I have read a previous thread on rolling sums using DSum (http://www.access-programmers.co.uk/forums/showthread.php?t=112221), but I am running into issues with writing the DSum query I want. Below are a few of the fields I have in table ImportData. (Note that these fields are named as they...

I have a table, tblPatientDiagnosis that is a many-to-many table. It hold PatientIntakeFormIDs (unique identifier for patient) and DiagnosisIDs. Obviously, each patient can have multiple entries. I am trying to pull patients who have X diagnosis, that do NOT have an entry for a Y type of...

I have a form that calculates evaluation task due dates based on an employee's hire date. For example, for something that needs to be done 45 days in advance of the anniversary date (the employee's hire date, but in the current year), I use the expression...

I noticed this issue when I tried to create a query against the table... I have a table, tblMaternalInfo, with a field called Gravida. It's just a numeric field. I can see the field when I'm in Design View, but when I go to Form View, the field is not listed. I've tried highlighting the...

Hi. I'm struggling with how to set the value of my PatientName field based on the patient's referral date (ReferralDate). Both fields are on frmPatientRecordbyLName and I'm sure I'll need to use VBA code since I'll need to set the color to one of five colors and Access2000 is limited to 3...

Hi, everyone. In preparation for my annual review (still a few months away), I'd like to come up with some questions for a survey that can be filled out by the end users of the datbases I've created in order to gauge their satisfaction with both the databases and my performance. My...

Is there a way (macro, maybe) to set the cursor position of a date field (that uses an input mask) when my users click on it? When a user tabs through the fields, she is automatically placed in the first position of the __/__/____ field. However, when a user clicks in the date text box, she is...

Sorry in advance - this is long I have a database in which I maintain information about patients. I am having problems getting the results of several calculations and "pulled" fields to display without closing the form and re-opening it. tblMaternalInfo - includes demographic info, as well...