Recent content by Hoving

> 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...