C
Curtis
When I open my {frmPatient Data} and view the appropriate record, I want to
print the report {rptLetter} based on the current displayed Patient’s record
(exam results), the Patient’s [Exam ID]. As I press the Command Button
“Print Notificationâ€, an error reading message appears: “Microsoft Access
can’t find form ‘frmExam Data’ referred in a macro expression or Visual Basic
Codeâ€. It is referring to: Macro Name: UpdatePrintNotice; Condition:
True; Action Name: SetValue; Arguments: [Forms]![frmExam
Data]![ResultsNotified],Date()
This macro has two actions: 1) is SetValue and the 2nd is OpenReport. The
details for SetValue are above and the details for the action OpenReport:
Report Name: rptLetter; View: Print Preview; Filter Name: blank; Where
Condition: [ExamData].[ExamID]=[Forms]![frmPatient Data]![frmExam
Data]![ExamID]
There are two tables: main table is {PatientData} and subdatasheet is
{ExamData}, with the linked field [SSN], a one to many relationship. The
design of the {frmPatientData} has 3 tabs: Demographics from the table
{PatientData}, and the other two tabs Single Exam and Exam History are from
the table {ExamData}, the [ExamID] is the primary key for the table
{ExamData}. The original problem when I inherited the database, the naming
of the objects were non-distinctive; the tables, queries, forms & reports had
the same names; so I renamed the queries, forms and reports with the
prefixes: qry, frm & rpt; I did not get to the macros nor the tables. I
decided to leave them along for now. I’ve done a Compact and Repair
Database. This error reading is the 1st situation. The 2nd and 3rd are
similar as below. Prior to renaming the objects, the original database had
an existing error when pressing the Command Button: Run-time error 2427.
You entered an expression that has no valueâ€.
There are two other macros which when I try to open them separately, they
both have error readings: Macro 2: “can’t find ‘frmExam Data’ …†and Macro
3: “… can’t find ‘frmPatient Data’…â€
Macro 2 Name: ClearNotified; Condition: True; Action Name: SetValue;
Arguments: [Forms]![frmExamData]![ResultsNotified], Null
Macro 3 Name: ResultsIn=Today; Condition: True; Action Name: SetValue;
Arguments: [Forms]![frmPatient Data]![frmExam Data].[Form]![ResultsIn], Date()
I’m not sure what is causing these errors, and was wondering if someone
could assist me in this.
print the report {rptLetter} based on the current displayed Patient’s record
(exam results), the Patient’s [Exam ID]. As I press the Command Button
“Print Notificationâ€, an error reading message appears: “Microsoft Access
can’t find form ‘frmExam Data’ referred in a macro expression or Visual Basic
Codeâ€. It is referring to: Macro Name: UpdatePrintNotice; Condition:
True; Action Name: SetValue; Arguments: [Forms]![frmExam
Data]![ResultsNotified],Date()
This macro has two actions: 1) is SetValue and the 2nd is OpenReport. The
details for SetValue are above and the details for the action OpenReport:
Report Name: rptLetter; View: Print Preview; Filter Name: blank; Where
Condition: [ExamData].[ExamID]=[Forms]![frmPatient Data]![frmExam
Data]![ExamID]
There are two tables: main table is {PatientData} and subdatasheet is
{ExamData}, with the linked field [SSN], a one to many relationship. The
design of the {frmPatientData} has 3 tabs: Demographics from the table
{PatientData}, and the other two tabs Single Exam and Exam History are from
the table {ExamData}, the [ExamID] is the primary key for the table
{ExamData}. The original problem when I inherited the database, the naming
of the objects were non-distinctive; the tables, queries, forms & reports had
the same names; so I renamed the queries, forms and reports with the
prefixes: qry, frm & rpt; I did not get to the macros nor the tables. I
decided to leave them along for now. I’ve done a Compact and Repair
Database. This error reading is the 1st situation. The 2nd and 3rd are
similar as below. Prior to renaming the objects, the original database had
an existing error when pressing the Command Button: Run-time error 2427.
You entered an expression that has no valueâ€.
There are two other macros which when I try to open them separately, they
both have error readings: Macro 2: “can’t find ‘frmExam Data’ …†and Macro
3: “… can’t find ‘frmPatient Data’…â€
Macro 2 Name: ClearNotified; Condition: True; Action Name: SetValue;
Arguments: [Forms]![frmExamData]![ResultsNotified], Null
Macro 3 Name: ResultsIn=Today; Condition: True; Action Name: SetValue;
Arguments: [Forms]![frmPatient Data]![frmExam Data].[Form]![ResultsIn], Date()
I’m not sure what is causing these errors, and was wondering if someone
could assist me in this.