Getting ReportUtilities to work

[DirkReiners]

Hi everybody,

this is my first foray into the wonderful world of MS Access (or databases in general, for that matter), so please bear with me if I ask somewhat stupid questions. :)

I need to export a Report that has pictures in it to Word. Stock Access doesn't do it (no pictures in RTF), so I downloaded Stephen Lebans' ReportUtilities, which support it. But I can't get them to work.

This is with Access 2k on Win XP. Just to make sure I'm not missing anything stupid, here's what I do: File -> Get External Data -> Import A2KReportUtilities.mdb. Activate everything and import. Same thing with A2KReportSpecs.mde. Then I open the ReportUtilities Form, select my Report and click Export To File (doesn't matter which one). That gives me an error box 91 : "Object variable or With block variable not set" in CmdSaveRTF_Click: pf.ExportToWordpad Me.txtRptName.

Given that other people are using it successfully, there must be something wrong in the way I do it. I tried to figure what is meant by 'set a Reference' in the READMEFIRST, but help talks about a References entry in the Tools menu that doesn't exist.

Any help welcome

Dirk

[nico5038]

First open some VBA code (e.g. by opening a new module or pressing the code button when editing a form/report)
Then use Tools/References to add the needed library.

Clear ?

Nic;o)

[NeoPa]

...and you can use Alt-F11 from your Access window to open up, or switch to, the VBA window for that Access session.

As Nico says, that's where you'll find References under the Tools menu :).