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

...for each subject, is: Visit Date and Visit Outcome (e.g., no show, cancelled, completed). But this visit information needs to be related to *that particular patient* for *that particular study*. (To visualize it on a form, imagine you are on Joe's record on the Patients form. A datasheet...

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

...for that particular response (in tblQuestions). Me![Rspns].LimitToList = Me!LmtLst However, I can’t seem to write a similar event to set the *Input Mask* for each response, if there is one. I used similar syntax to the LmtLst code above, but doing this sets the Input Mask for *every*...

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

...in the code is not collating. I also tried the code without the -1. Same thing: 3 copies but not collated. Any other ideas? Hoving OnClick code: ******************************* With DoCmd .OpenReport "rptSurveys", acViewPreview .SelectObject acReport...

...are visible waiting for the user to begin entering. I like this. On the other hand, I have other queries that, when the result is Null, show *no* blank line and nothing in the record navigation area. Forms based on this query appear completely blank. I can't see what is different about my...

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

...to write what I assume should be a Where statement (like "Where DoctorName Is Not Null). Here's what I have so far in the code of frmMain: ************************************** Sub PrintReports(PrintMode As Integer) On Error GoTo Err_Preview_Click ' This procedure used in...

...to write what I assume should be a Where statement (like "Where DoctorName Is Not Null). Here's what I have so far in the code of frmMain: ************************************** Sub PrintReports(PrintMode As Integer) On Error GoTo Err_Preview_Click ' This procedure used in...

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

...button is pressed, the recordset combo box on the form is also filtered to list only names associated with the selected school? Thanks. - Hoving ****** The OnClick event for the School A button: Private Sub SchoolA_Click() ' Open frmStudents filtered for students in '...