Make a report from MS Word files, Picture and Text 1

[4Wile]

When I get a bulletin and it will be scanned to MS Word.
I would need to change the MS Word file to a MS Access
report? Can it been done. Please be specific, I'm
newbie..

 

[turtlemaster]

You may be able to link to the word document and use an activex control to view the word document from within the access report. Store the path and fileaname of the word file in the database and in the on load event of the report set the parameters of the activex control to open the word documents. I'm not sure of which control to use though -- I'm sure there is one that can do this though.

 

[4Wile]

Turtlemaster,
I am a Newbie to MS Access and I need more specific guidance.
I have a database named Test.mdb, MS Word file named Test.doc and a report called TestReport. The path for
C:\Test\Test.doc.
How to link word document and ActiveX contol??
Where to store the filename and path to the database??
How to set Load event to parameters of ActiveX control??

Please help..

 

[turtlemaster]

do you need the .doc file as part of the report or can you just put a hyperlink to it and have it open in word?

 

[4Wile]

Turtlemaster,

The system will send bulletins using WinFax to all
subjects based by parameters selected from MS Access.
I need make bulletins to MS Access reports to
ship them. Like:
1. Make a report for a attachment.
2. Select the people to Fax.
3. Push a button to Fax.
Everything is done but how to make a bulletin into
a MS Access report.

 

[turtlemaster]

When you say attachment, do you mean in an email? If so you could export the report to a snapshot file (it's kind of like saving a print preview of the report).

 

[4Wile]

Turtlemaster..

The WinFax command includes the following:

DoCmd.OpenReport "TestReport", acViewNormal

Some how, I need to convert a bulletin(from a scanner) and
import as a MS Access report. I thought to make a MS Word
files from the Scanner and try to import to MS Access.

I get many bulletins and I need to convert text and
pictures to send..

 

[turtlemaster]

It's making a little more sense now ... It might be easier to leave the scanned in report as an image?? It is easy to put jpeg's and stuff into a access report (I've done that quite a bit). Even if you wanted to store many bulletins, you could store them on a server and store their location in the database and bring them up on your report (to have historic bulletins). LMK if this would be suitable.

 

[4Wile]

Turtlemaster,

I think we're close to a solution...
All I need is how to get a scanned file into a report.

I need a button to place the scanned file into
TestReport... I can save any scanned report as
bmp files..or any Graphic files or text files..

Some event as OnClick, OnLoad, or etc..

 

[turtlemaster]

okay good,

In the onload event of the report tell the image activex control to loadpicture="drive:\path\filename.extension" and the image should apear in the report. LMK how that works (for more help check out help on the image control)

Nick

 

[4Wile]

Turtlemaster...

What does "LMK how that works (for more help check out help
on the image control)"?
and
"tell the activex control to "

I'm still a newbie...sorry

 

[turtlemaster]

LMK = Let me know

no prob,

The help in access is phenominal (epecially 97) and it should be referenced for a more detailed explaination.

1.) Put an image control in your report and give it a picture file to display (any will do it needs one or it wont work)
2.) Put this code in the onload event of your report.

Image1.Picture = LoadPicture("yourpicturefile.bmp&quot

(I'm not 100% sure on this syntax -- someone help me out) but this will put your bmp on the report. You could event put a field name for the yourpicturefile.bmp and make it dynamic)

 

[4Wile]

Turtlemaster...

Much thanks...Now I understand..

Bob Foreman
4Wile@mediaone.net