Query by Form Output

[Guest]

Hi...I've set up a form to perform a query, and now I'm trying to improve the user-friendliness of the QBF output. I'd like the results of the query to be output to a report. because I have some OLE objects that need to be accessed from the results (i.e. the OLE objects are journal articles in pdf format, that the user searches for using the QBF, and I want them to be able to open the OLE object right from the results of the QBF). I've tried using the OutputTo Macro, but I can't get it to work. This is my first experience with computer programming...any help or advice would be appreciated!

 

[Steve Schapel]

Nadia,

I am not 100% clear what you want to happen. But it will be difficult
to get your pdf documents into a report... it's probably possible, but I
have never tried it. But here's another idea that might serve your
purpose. Make a field in your table, set the data type to Hyperlink,
and enter the path and filename of the journal articles into this field,
preceded by the File protocol predicate, like this...
File:\\C:\MyArticles\FirstArticle.pdf
Then, display the data from this field on a form, either your selection
form, or a form bound to the results of your query, and then the user
just has to click the hyperlink, and the article will be opened in Adobe
Reader.