Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Hoving

    Tracking patient visits for multiple studies

    > 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)...
  2. Hoving

    Tracking patient visits for multiple studies

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

    Tracking patient visits for multiple studies

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

    Change data type & values of related fields

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

    Hyperlink to .doc file - promt user for path

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

    Show alternative text if form is null

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

    Show alternative text if form is null

    > "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...
  8. Hoving

    Show alternative text if form is 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...
  9. Hoving

    Show alternative text if form is null

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

    Setting Input Mask by code

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

    Creating a frequency table

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

    Creating a frequency table

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

    Creating a frequency table

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

    Print and collate report - OnClick Code

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

    Null query result returns blank form. Help!

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

    Open report filtered from an option group

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

    Open report filtered from an option group

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

    Open report with option group

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

    Simple one . . . When I mouse cl

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

    Apply filter to recordset combo box?

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

Part and Inventory Search

Back
Top