Search results for query: *

> 1) Does tblStudyStatus relate to > tblLinkStudies_Patients? Maybe you have a one-to-many > with StudyStatus and Visits, but be careful. > Will a patient do two studies in a single visit--if > so how will that data be represented? A patient will never do two studies in a single visit. > 2)...

Shane: I moved the visit info. into the tblLinkStudies_Patients. This did improve things. The new relationship window is here: http://members.cox.net/kheisler6/Studies2.jpg This way, if Joe has 1 visit for the Milk study: tblLinkStudies_Patients ----------------------------...

Here is a link to the relationships window for a database used to keep track of patients who are enrolled in one or more studies. http://members.cox.net/kheisler6/Studies.jpg A patient can be enrolled in more than one study. A study can have more than one patient. (Many-to-Many) Subjects...

I have two tables, a table of teachers and a table of students. The tables are linked by TeachID. tblTeachers tblStudents ---------------------- ------------------- TeacherLast (text) StudentFirst TeachID (PK) (autonum) StudentLast...

I would like to add a hyperlink to a form to point the use to the User's Manual (word document). However, because this database will be sent to multiple users throughout the state, I can't anticipate where the user (i.e., what folder/path) will save the User's Manual. The users are not...

Got it working. I ended up using this syntax . . . =IIF([txtStartDate] is null and [txtEndDate] is null,"All Dates", "Date Range: From "& [txtStartDate] & " To " & [txtEndDate] . . . combined with two hidden text boxes on the report (txtStartDate and...

> "Date Range: " & Nz(Forms.frmnuReportSelect.txtStartDate,"WHATEVERYOUWANTINHERE") > & " to " & Nz(Forms.frmnuReportSelect.txtEndDate,"WHATEVERYOUWANTINHERE") Thanks. Getting closer. This preserves a " " to " " format in either a null...

> =Nz(Forms.frmnuReportSelect.txtStartDate,"WHATEVERYOUWANTINHERE") > should do the trick That does produce a message if txtStartDate is null, but how do I integrate that into the larger syntax statement? In other words . . . If txtStartDate is null, show...

When a user enters a start and end date on a form (into txtStartDate and txtEndDate), a report opens and an unbound text box shows the parameter used. The control source for the text box is: ="Date Range: " & [txtStart] & " to " & [txtEnd] where txtStart is a hidden...

I’ve created a data entry form for a survey using a table and form structure similar to that used in Duane Hookom’s “At Your Survey” database (http://www.rogersaccesslibrary.com/OtherLibraries.asp). When a user selects a RspnsID on the main form (frmSurveyResponses), the matching...

I spoke a bit too soon. I'm having a problem with the At Your Survey database (and my derivative of it) that I can't figure out. In the Survey Response Entry form, when I select a survey (e.g., "Sample"), enter a name, and click the "Enter Results" button, the appropriate...

Duane: Excellent feedback, and the sample (At Your Survey) database is outstanding. It's just the kind of normalized model I'm looking for. Thanks. Kurt

I am trying to create a report to show a frequency table of survey data. The data are from 16 survey questions which are answered on a 5-point Likert scale (e.g., 1 = Strongly Agree, 2 = Agree . . . 5 = Strongly Disagree). The data entry form uses option groups (i.e., check boxes) for each...

When a user presses a command button on my form, I'd like the OnClick code to print and collate 3 copies of a report. My current code prints 3 copies of the report but it does not collate them. The print and collate options work fine when I manually do it (File > Print > ...), but the -1 in the...

I have a similar problem, and here's what it looks like at the query level: I have some queries that, when the result is Null, show a blank line with "(Autonumber)" in my Autonumber ID field, and Record "1 of 1" at the bottom. Forms based on this query won't appear...

The SELECT CASE Forms!frmMain.optSelectReport . . . statement in the Open event of the report was exactly what I was looking for. It works perfect. Creating an additional query as suggested would have worked, too, but I wanted to avoid creating another query if there was a more efficient way...

How do I open a report filtered from an option group? I have a report, rptEveryone, based on a query, qryEveryone. One field in the query and on the report is called DoctorName. I have an option group, optSelectReport, on a main form, frmMain. The option group has 3 options. When the user...

Two questions: 1. I have a report, rptEveryone, based on a query, qryEveryone. One field in the query and on the report is called DoctorName. What would I enter in the Filter property of rptEveryone so the report includes only records where the DoctorName field on the report is not blank (i.e...

Setting the focus as you suggested worked perfectly. Thanks. - Hoving > You could try setting focus on the onclick function > for the field. If you set focus to a second field > and then reset focus to the original field, it should > bring the focus in at the beginning of the original >...

When a user clicks buttons "School A" or "School B" on a switchboard, a form opens with records filtered according to which button was pressed (e.g., records of students in School A). What doesn't get filtered is a recordset combo box on the form where the user can select a...