Printing a Brochure/Catalogue from Actinic

[mjohn]

I know there have been a few requests for this and an example given of using Access/Crystal reports and CV_Image to enable this.

I think I have found an alternative way to do this using just Access97 which basically involves importing the data from the Products database into another Access database then after modifying the image file (copy and paste the missing bit) path to show the full file path, then get access to produce a report with the images showing which you can print to Adobe acrobat.

For details on how to get Access to display the images in a report check out the Microsoft article Q148463.

I have tried this on a sample database and it works so I am about to try this on the full catalogue to see how it works.

I know this involves some programming of Access but it may be very worthwhile for printing, e mailing or burning to CD.

Hope this helps.

Mark

www.OneStopSafetyShop.co.uk

[mjohn]

Printing a Brochure or Catalogue from Actinic

Just tried this for real and it works, downside is manually editing the path to the full directory path. Can be very tedious pasting in the missing part of the path can anyone think of a better way of doing this.
eg
\MyPictures\Picture1
To
C:\Program Files\Actinic v7\Sites\Site1\MyPictures\Picture1

Thanks

Mark

www.OneStopSafetyShop.co.uk

[DaveT]

Why not copy to a query or temporary table in Access?

You can create in a query a field called NewImagePath.

The following SQL can be pasted into the SQL view of a new query:

SELECT "C:\Program Files\Actinic v7\Sites\Site1\" & [Product]![Image FileName] AS NewImagePath
FROM Product;


If you then saved this as a Make Table query or Update query and update the new temporary table, you'd save yourself hours. I do this all the time to add % off prices, change text, lots of things.

[mjohn]

Re:Printing a brochure

Thank you very much for the info, I am a bit rusty on Access but following your advice I have the query and tables working a treat now. I can now produce catalogues directly from Actinic to Access to Adobe acrobat very easily.

Many thanks

Mark