B
BruceM
I have a database for keeping track of recommendations. Each recommendation
has four sections: Recommendation, Response, Follow-Up, and Final Approval.
Data entry is by means of a form.
Considering just the Response section, after completing a response the
employee who did so selects his or her name from a combo box. The combo box
row source is a query (qryResponseSignature) based on a table (tblEmployee)
that contains EmployeeName, etc., and a text field that is a path to a
network location at which is located a graphics file of the person's
signature. The reason for the link to the graphics file is that the report
of the Recommendation contains this facsimile signature. The combo box's
bound column is ResponseSignatureID, which is a Number field.
In order for the signature to appear on the report, I have made a query
(qryRecommendation) that includes tblRecommendation and the row source query
for the combo boxes. I have established a relationship between
ResponseSignatureID (the combo box record source in tblRecommemdation) and
the EmployeeID field from qryResponseSignature.
By basing the report on qryRecommendation I am able to have the facsimile
signature appear on the report. The way this happens, in case it matters,
is that there is on the report a hidden text box (txtResponseSignature)
bound to the text field that is the network path to the "signature". The
report's Print event contains:
Me.imgResponseSignature.Picture = Me.txtResponseSignature
(imgResponseSignature is an image control on the report).
This works fine as long as the response has been completed. However, I need
to see any recommendation, regardless of whether it is completed. If
ResponseSignatureID is blank, the record is not included in the query. I
need it to be included, but cannot figure out how.
FWIW, this situation is repeated for the Follow-Up and Final Approva
sections. I have left them out of my question since the solution to the
problem can be extended to those sections.
has four sections: Recommendation, Response, Follow-Up, and Final Approval.
Data entry is by means of a form.
Considering just the Response section, after completing a response the
employee who did so selects his or her name from a combo box. The combo box
row source is a query (qryResponseSignature) based on a table (tblEmployee)
that contains EmployeeName, etc., and a text field that is a path to a
network location at which is located a graphics file of the person's
signature. The reason for the link to the graphics file is that the report
of the Recommendation contains this facsimile signature. The combo box's
bound column is ResponseSignatureID, which is a Number field.
In order for the signature to appear on the report, I have made a query
(qryRecommendation) that includes tblRecommendation and the row source query
for the combo boxes. I have established a relationship between
ResponseSignatureID (the combo box record source in tblRecommemdation) and
the EmployeeID field from qryResponseSignature.
By basing the report on qryRecommendation I am able to have the facsimile
signature appear on the report. The way this happens, in case it matters,
is that there is on the report a hidden text box (txtResponseSignature)
bound to the text field that is the network path to the "signature". The
report's Print event contains:
Me.imgResponseSignature.Picture = Me.txtResponseSignature
(imgResponseSignature is an image control on the report).
This works fine as long as the response has been completed. However, I need
to see any recommendation, regardless of whether it is completed. If
ResponseSignatureID is blank, the record is not included in the query. I
need it to be included, but cannot figure out how.
FWIW, this situation is repeated for the Follow-Up and Final Approva
sections. I have left them out of my question since the solution to the
problem can be extended to those sections.