Search results
-
N
filtering report (with subreports) using multiple parameters
hey there i have a main PatientForm that contains patient information from multiple tables: [GENERAL] values Subform - [RefMD] values (referring doctor) Subform - [Drugs] values (prescribed meds) Subform - [Diagnosis] values (medical diagnosis) Subform - [Encounters] values (visits to the... -
N
limiting results in record source
hey there, i figured out that my problem was not what i previously thought it was.. i needed to change my record source rather than try to filter my report. thanks to the user who suggested this.. right now, this is the record source i have for my report Encounters. SELECT ENCOUNT.* FROM... -
N
filtering a subreport
hah, now that i have my report working, i need to limit one of the subreports.. i have a subreport called ENCOUNT, for encounters (or visits) to the doctor. in this subreport, there are the fields Date, ClinicType, and Notes. what i need to do is limit the number of rows that are displayed to... -
N
report master and child relationships?
right now i have a form that displays information from a GENERAL table and then 4 other subreports. i have set the master and child values of all the subreports to a unique value HistNum that is set throughout the database. however, none of the subreports appear. also, when i make a test... -
N
composing filter using checkboxes
heres what im trying to do i have a main form that displays medical patients information from my table GENERAL, and then from REFMD, DIAGNOSIS, ENCOUNTERS, and MEDICATIONS as subforms. i have a smaller form named multiple that has checkboxes with the values State, Zipcode, Diagnosis... -
N
master/child link not working? and whitespace
hey, here is my setup i have a GENERAL table with medical patients basic information. then i have multiple other tables (medications, visits, diagnosis, referring doctors), all linked by HistNum. i have a form that opens a report filtered to a single patient and is going to display all of... -
N
friendly appearance on reports
i have a form that will be filtered for each use that displays medical patients' information, including their information (master table), drugs (child subreport), diagnosis (child subreport), and more. however, i have been informed to design a report that compacts the information as much as... -
N
friendly looking reports
hey, i have a form that is going to display the information for medical patients all on one page. i want to know how to display the information without empty space in between like fields fname and lname etc. is there any way to display different columns, for example both fname and lname, in 1... -
N
form to add row with information pre-defined
hey, i have a main form with multiple subforms on it, and a command button for each subform. when clicked, how do i go about opening the relative subform in its own window with the linking value (histnum) already defined -
N
macro to create new row with information
**edit, this may be better in the forms section** hey, i have a form that displays the information for medical patients. inside this form, i have multiple subforms linked by HistNum (history number). some of these subforms include prescribed medications and different past appointments. on...