Search results for query: *

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

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

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

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

Simple one . . . When I mouse click into any text box that has an input mask (e.g., a date field with !99/99/00;0), the cursor appears at the location I clicked. How do I set it up so the cursor goes to the start of the field (i.e., to the beginning of the text box, just as it does when...