> 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
'...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.