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!

  • Congratulations Wanet Telecoms Ltd 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

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

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

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

    Null query result returns blank form. Help!

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

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

    Open report with option group

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

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

Part and Inventory Search

Back
Top