Insert graphic in report

I have a form (frmMain, based on tblMain) that includes a combo box
(cboUserName) from which the user selects his or her name. cboUserName is
bound to [UserName], a text field in tblMain. Its row source is a query
(qryUserName) based on a table (tblUserName) that includes the person's name,
ID, and an OLE object field for a graphic (.tif) version of the person's
signature. When I make a report (rptMain) based on tblMain I would like to
insert the graphic (the "signature") rather than the name.
I had thought I could do this by 1) creating a relationship between tblMain
and qrySig, 2) creating a query (qryMain) that includes those two objects,
and 3) basing rptMain on qryMain. In rptMain is a bound object frame with
the OLE field from qryUserName as its record source. One difficulty I am
having is that qryMain only returns records for which there is a value in
UserName. frmMain will be filled out in stages, and all records need to be
available at all times, no matter if they are complete.
The second difficulty arises no doubt from my unfamiliarity with graphics in
general, and graphics in Access in particular. The graphic is the correct
size when I insert it into a Word document, but it is much too small when I
insert it into the report. I cannot make it larger within Access due to
pixellation, yet am not sure what to do with the original to make it work.
There are people here who can work with graphics, but I don't know what to
request of them in order for the "signatures" to be sharp and clear on the
report.

Bruce:

My first thought, regarding the query only returning rows with a value in
UserName is to modify the join properties to make it a many-to-one
relationship. I'm assuming that there is a join that is creating a
one-to-one relationship, which then limits the results.

Not sure about the .tif image. Perhaps increase the size of the original,
before saving it into Access, to allow for the reduction in size. This, of
course, assumes Access is applying a standard reduction versus having a
display size limit.

Sharkbyte


"BruceM" wrote:

I have a form (frmMain, based on tblMain) that includes a combo box
(cboUserName) from which the user selects his or her name. cboUserName is
bound to [UserName], a text field in tblMain. Its row source is a query
(qryUserName) based on a table (tblUserName) that includes the person's name,
ID, and an OLE object field for a graphic (.tif) version of the person's
signature. When I make a report (rptMain) based on tblMain I would like to
insert the graphic (the "signature") rather than the name.
I had thought I could do this by 1) creating a relationship between tblMain
and qrySig, 2) creating a query (qryMain) that includes those two objects,
and 3) basing rptMain on qryMain. In rptMain is a bound object frame with
the OLE field from qryUserName as its record source. One difficulty I am
having is that qryMain only returns records for which there is a value in
UserName. frmMain will be filled out in stages, and all records need to be
available at all times, no matter if they are complete.
The second difficulty arises no doubt from my unfamiliarity with graphics in
general, and graphics in Access in particular. The graphic is the correct
size when I insert it into a Word document, but it is much too small when I
insert it into the report. I cannot make it larger within Access due to
pixellation, yet am not sure what to do with the original to make it work.
There are people here who can work with graphics, but I don't know what to
request of them in order for the "signatures" to be sharp and clear on the
report.

Turns out I had an inner join where I needed a left join, so now I see all of
the records. Thanks for pointing me in the right direction.
For the second part (regarding the .tif), I am hoping to avoid a lot of
trial and error. Graphics do not behave as they do in other Microsoft Office
programs. If I insert a particular tif file into Word it measures about 1".
When I open it with standard image viewing software (such as Windows Picture
and Fax Viewer) its properties show its size as about 1". However, when I
insert the same file into an OLE field in a table, then use a bound object
frame to insert the field into a report, it measures about one quarter of an
inch, and cannot be successfully enlarged.
I am not skilled with graphics, and am not familiar with such programs as
Paint Shop. There are people here who are skilled with such things, so
rather than learning the software (which I don't really have time to do right
now) I could just tell them what is needed, except I don't know what that is.
How do I know if Access is "applying a standard reduction"? Perhaps a .tif
is not the best way to go? I tried a bitmap, which works better, but the
file size is quite large. The documentation (Access Help) says something
about saving the image as a metafile, which is smaller than a bitmap. I will
have to check with the graphics people here to see if that is possible. I am
just trying to get some general guidelines about handling graphics so that
they don't become excessively annoyed with me.

"Sharkbyte" wrote:

Bruce:

My first thought, regarding the query only returning rows with a value in
UserName is to modify the join properties to make it a many-to-one
relationship. I'm assuming that there is a join that is creating a
one-to-one relationship, which then limits the results.

Not sure about the .tif image. Perhaps increase the size of the original,
before saving it into Access, to allow for the reduction in size. This, of
course, assumes Access is applying a standard reduction versus having a
display size limit.

Sharkbyte


"BruceM" wrote:

I have a form (frmMain, based on tblMain) that includes a combo box
(cboUserName) from which the user selects his or her name. cboUserName is
bound to [UserName], a text field in tblMain. Its row source is a query
(qryUserName) based on a table (tblUserName) that includes the person's name,
ID, and an OLE object field for a graphic (.tif) version of the person's
signature. When I make a report (rptMain) based on tblMain I would like to
insert the graphic (the "signature") rather than the name.
I had thought I could do this by 1) creating a relationship between tblMain
and qrySig, 2) creating a query (qryMain) that includes those two objects,
and 3) basing rptMain on qryMain. In rptMain is a bound object frame with
the OLE field from qryUserName as its record source. One difficulty I am
having is that qryMain only returns records for which there is a value in
UserName. frmMain will be filled out in stages, and all records need to be
available at all times, no matter if they are complete.
The second difficulty arises no doubt from my unfamiliarity with graphics in
general, and graphics in Access in particular. The graphic is the correct
size when I insert it into a Word document, but it is much too small when I
insert it into the report. I cannot make it larger within Access due to
pixellation, yet am not sure what to do with the original to make it work.
There are people here who can work with graphics, but I don't know what to
request of them in order for the "signatures" to be sharp and clear on the
report.

Bruce:

I am certainly no expert at Ole objects. However, take a look at Format
Size Mode - of the bound frame - and see if Stretch or Zoom resolves your
problem. (Clip is the default)

Sharkbyte


"BruceM" wrote:

Turns out I had an inner join where I needed a left join, so now I see all of
the records. Thanks for pointing me in the right direction.
For the second part (regarding the .tif), I am hoping to avoid a lot of
trial and error. Graphics do not behave as they do in other Microsoft Office
programs. If I insert a particular tif file into Word it measures about 1".
When I open it with standard image viewing software (such as Windows Picture
and Fax Viewer) its properties show its size as about 1". However, when I
insert the same file into an OLE field in a table, then use a bound object
frame to insert the field into a report, it measures about one quarter of an
inch, and cannot be successfully enlarged.
I am not skilled with graphics, and am not familiar with such programs as
Paint Shop. There are people here who are skilled with such things, so
rather than learning the software (which I don't really have time to do right
now) I could just tell them what is needed, except I don't know what that is.
How do I know if Access is "applying a standard reduction"? Perhaps a .tif
is not the best way to go? I tried a bitmap, which works better, but the
file size is quite large. The documentation (Access Help) says something
about saving the image as a metafile, which is smaller than a bitmap. I will
have to check with the graphics people here to see if that is possible. I am
just trying to get some general guidelines about handling graphics so that
they don't become excessively annoyed with me.

"Sharkbyte" wrote:

Bruce:

My first thought, regarding the query only returning rows with a value in
UserName is to modify the join properties to make it a many-to-one
relationship. I'm assuming that there is a join that is creating a
one-to-one relationship, which then limits the results.

Not sure about the .tif image. Perhaps increase the size of the original,
before saving it into Access, to allow for the reduction in size. This, of
course, assumes Access is applying a standard reduction versus having a
display size limit.

Sharkbyte


"BruceM" wrote:

I have a form (frmMain, based on tblMain) that includes a combo box
(cboUserName) from which the user selects his or her name. cboUserName is
bound to [UserName], a text field in tblMain. Its row source is a query
(qryUserName) based on a table (tblUserName) that includes the person's name,
ID, and an OLE object field for a graphic (.tif) version of the person's
signature. When I make a report (rptMain) based on tblMain I would like to
insert the graphic (the "signature") rather than the name.
I had thought I could do this by 1) creating a relationship between tblMain
and qrySig, 2) creating a query (qryMain) that includes those two objects,
and 3) basing rptMain on qryMain. In rptMain is a bound object frame with
the OLE field from qryUserName as its record source. One difficulty I am
having is that qryMain only returns records for which there is a value in
UserName. frmMain will be filled out in stages, and all records need to be
available at all times, no matter if they are complete.
The second difficulty arises no doubt from my unfamiliarity with graphics in
general, and graphics in Access in particular. The graphic is the correct
size when I insert it into a Word document, but it is much too small when I
insert it into the report. I cannot make it larger within Access due to
pixellation, yet am not sure what to do with the original to make it work.
There are people here who can work with graphics, but I don't know what to
request of them in order for the "signatures" to be sharp and clear on the
report.

The problem with enlarging the image in that way is analogous to attempting
to create an 8 x 10 photograph by enlarging a face from a crowd scene. The
enlarged image is too pixellated to be usable. The bitmap approach offers a
better chance at success, or metafile if I can figure out how to do that.
Thank you for your input. I appreciate your taking the time to reply.

"Sharkbyte" wrote:

Bruce:

I am certainly no expert at Ole objects. However, take a look at Format
Size Mode - of the bound frame - and see if Stretch or Zoom resolves your
problem. (Clip is the default)

Sharkbyte


"BruceM" wrote:

Turns out I had an inner join where I needed a left join, so now I see all of
the records. Thanks for pointing me in the right direction.
For the second part (regarding the .tif), I am hoping to avoid a lot of
trial and error. Graphics do not behave as they do in other Microsoft Office
programs. If I insert a particular tif file into Word it measures about 1".
When I open it with standard image viewing software (such as Windows Picture
and Fax Viewer) its properties show its size as about 1". However, when I
insert the same file into an OLE field in a table, then use a bound object
frame to insert the field into a report, it measures about one quarter of an
inch, and cannot be successfully enlarged.
I am not skilled with graphics, and am not familiar with such programs as
Paint Shop. There are people here who are skilled with such things, so
rather than learning the software (which I don't really have time to do right
now) I could just tell them what is needed, except I don't know what that is.
How do I know if Access is "applying a standard reduction"? Perhaps a .tif
is not the best way to go? I tried a bitmap, which works better, but the
file size is quite large. The documentation (Access Help) says something
about saving the image as a metafile, which is smaller than a bitmap. I will
have to check with the graphics people here to see if that is possible. I am
just trying to get some general guidelines about handling graphics so that
they don't become excessively annoyed with me.

"Sharkbyte" wrote:

Bruce:

My first thought, regarding the query only returning rows with a value in
UserName is to modify the join properties to make it a many-to-one
relationship. I'm assuming that there is a join that is creating a
one-to-one relationship, which then limits the results.

Not sure about the .tif image. Perhaps increase the size of the original,
before saving it into Access, to allow for the reduction in size. This, of
course, assumes Access is applying a standard reduction versus having a
display size limit.

Sharkbyte


"BruceM" wrote:

I have a form (frmMain, based on tblMain) that includes a combo box
(cboUserName) from which the user selects his or her name. cboUserName is
bound to [UserName], a text field in tblMain. Its row source is a query
(qryUserName) based on a table (tblUserName) that includes the person's name,
ID, and an OLE object field for a graphic (.tif) version of the person's
signature. When I make a report (rptMain) based on tblMain I would like to
insert the graphic (the "signature") rather than the name.
I had thought I could do this by 1) creating a relationship between tblMain
and qrySig, 2) creating a query (qryMain) that includes those two objects,
and 3) basing rptMain on qryMain. In rptMain is a bound object frame with
the OLE field from qryUserName as its record source. One difficulty I am
having is that qryMain only returns records for which there is a value in
UserName. frmMain will be filled out in stages, and all records need to be
available at all times, no matter if they are complete.
The second difficulty arises no doubt from my unfamiliarity with graphics in
general, and graphics in Access in particular. The graphic is the correct
size when I insert it into a Word document, but it is much too small when I
insert it into the report. I cannot make it larger within Access due to
pixellation, yet am not sure what to do with the original to make it work.
There are people here who can work with graphics, but I don't know what to
request of them in order for the "signatures" to be sharp and clear on the
report.