Viewing documents in report

[vlh]

Hi Everyone,

I would like to view a document in a report based on user input. Can I
change the document based on the user input?

Thanks,
Vickie

 

[Larry Linson]

I would like to view a document in a
report based on user input. Can I
change the document based on the
user input?

Could you clarify what you mean by "view a document"? "Document" can have
many meanings and the meaning would affect the answer to your question. And
"viewng in a control" would be quite different than "using the document as
the data source for the report." How would a user identify the document?
Also, are you preparing a database for others to use, or is this just for
your own use?

Larry Linson
Microsoft

 

[vlh]

Hi Larry,

I have a report to print student certificates and would like the "teacher's
signature and title" to change on the report based on the input from the
user. I have set up a dialog box with a drop down for selecting the teacher.
I originally set up the report to use a bmp image for the signature, but the
images were not turning out right (too big or too small). I set up the bmp
and text in a Word doc and would like to insert it in the report.
I have a table set up with the teacher names and a field for the path to the
doc files but do not know the VB to attach to the event to get it in the
report.

Others will be using this DB when I finish with it.

Thanks,
Vickie

 

[Larry Linson]

Did you examine my answer to your other question, and take a look at the
example? I can't see why size would be a problem, if you choose Zoom in the
SizeMode property of an Image Control. What I do, if it is only a few
images, is to manually size them to approximately or exactly the size I want
outside Access, and then use Zoom, "just in case".

That'll be simpler and, most probably, look better than embedding a Word
Document just to display an image.

There's code in the example that you should be able to adapt.

Larry Linson
Microsoft Access MVP

 

[vlh]

Good Morning Larry,

I did not see an example in your previous response.

I have the images outside of Access set to sizes of approximately 2" x 0.6"
inches, but when I insert them in the report they show as 6" x 1.75". Why is
this happening? Is there a way to automate the 'zoom' so they come out the
correct size each time my users use this report?
The challenge will be that the teachers will be changing quite frequently
and I would like to just insert the new teacher in the teacher table with a
path to the appropriate bmp of thier signature.
I am fairly new to Access and do not know VB.

Thanks for your patience with my problem.
Vickie

 

[vlh]

Good Morning Again Larry,

I figured it out!! Sometimes it just takes this novice some time playing
with new applications to get what I need....
I set the image size to 2" x 0.6" on the report and then set the properties
"size mode' to zoom.

Thanks again,
Vickie

 

[Larry Linson]

I did not see an example in your previous response.

I'm glad to hear that you'd found the answer already. And I apolozie, I
assumed that I had already given you the following text with a link to a
Samples and Examples website (perhaps it will be of help sometime in the
future):

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP