By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,093 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Getting ReportUtilities to work

P: 1
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

Dec 1 '06 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,072
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 ?

Dec 1 '06 #2

Expert Mod 15k+
P: 31,602
...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 :).
Dec 2 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.