Search results

I have a form with many combo boxes that correspond to various answers for a survey. The fields are integers that correspond to various answers. e.g. 1; "very good"; 2; "good"; 3, "fair"; 4; "poor"; null, "N/A" I have the row source as shown above. (however not all combo boxes have the same...

Suppose I have 5 stages of development of a product. There are a lot of factors that go into determining when a certain stage is complete and they do not have to happen in any particular order. I don't have fields in my table representing each stage, however I can use one field, STATUS, to...

Im working with a database of heart transplant catheter procedures on patients. I'm trying to get the exam information for a number of patients from their exam closest to a given date. When a patient comes in for a regular checkup, they usually have a cath procedure done that day, but...

I'm pulling lab values from a hospital DB. They are stored in a table like this. Table: LABS Columns: LAB_ID, PATIENT_ID, LAB_TYPE, DATE, RESULT, UNITS Example: 123456, 654321, "WBC", 1/1/2000, 10.2, "K/uL" I have a list of PATIENT_IDs and certain LAB_TYPES from certain dates that I want to...

I have a big messy query, it looks like this: (about 1200 characters with 10 AND/OR statements) SELECT Patients.EMPI, [Patients].[LAST_NM] & ", " & [Patients].[FIRST_NM] & " " & [Patients].[MIDDLE_NM] AS PAT_NM, DateDiff('yyyy',[BIRTH_DT],Date()) AS AGE, Patients.SEX_CD, Providers.LAST_NM &...

I have a public function, Foobar, in a module that can be called from FormA, FormB, or FormC. Each of these forms contains a field we'll call Output. The output of Foobar is in part determined by where the function was called from. I.E. Public Function Foobar (arg1, arg2) if...

I have a rather complicated DB that is running incredibbly slow. Access is not in my job description so I'm asking for advice. Pardon the rather lengthy description. DB Info: I have a DB for screening patients for a clinical trial. Essentially there are two tables, one for patient demographics...

For a research study I'm writing a form to screen possible subjects based on various criteria stored in a table. The table essentially has three columns: field_name, Criteria_short, and Criteria_long. The form is pretty busy so there is only space for the short description of the field. e.g. "No...

I have just finished putting together a database for a lab inventory. I've got all the modules, forms, relationships, etc. just how I want them. Now I'm wondering what is the best way to deploy this. The database links to some existing tables that I have no control over and also uses some new...

I have a form with about 15 fields, we'll call them Field1,Field2, etc. With the exception of the primary key, all the fields can be null. I have a type defined, we'll call it a FormStruct, with all it's elements equivelant to the form fields and all are variant types to allow nulls. i.e. Type...

I have the following query SELECT items.itemKey, item.sample AS [Sample ID], item.PK AS EMPI, item.account AS Account FROM items WHERE (((items.sample) Like "*" & [forms]![tubetrack].[SampleID] & "*")) OR (((items.PK)=[forms]![tubetrack].[EMPI])) OR...

I have a field that holds item numbers. They are usually a number, but sometimes contain other characters and/or spaces. e.g. 123456 456789 789123 ABC123 BLAH01 456 XYZ When I query this field using LIKE and a wildcard, I am not seeing any all numeric results: WHERE ItemNumber LIKE '*A*'...

I am working on a database for inventory of a laboratory. Currently there is a table that defines samples, 'Samples'. This includes a primary key, sample ID, subject demographics, among others, and a numeric field of test tubes belong to a sample 'TubeNumber'. This table must remain intact...

First, a bit about the data: Each record has a unique key (autonumber), and an ItemID (text) that is not necissarily unique nor required, as well as various item information. It is possible that an item with the same ItemID may come through the system to be reprocessed. This would mean either a...

I currently have a basic query that uses a form field. This query is used as the row source for a listbox that has a lot of events associated with it. SELECT * FROM ITEMS WHERE ITEMS.ITEM_ID = Forms![Form 1]!ItemID How can I change this query to work in more than one form, not just Form 1...

I'm relatively new to Access but very willing to get my hands dirty. Here's a problem I've been trying to figure out for the last few days for a research lab DB. I've got three tables with the following relevant fields: --SAMPLES-- one to many tubes Skey - primary key unique to each sample...