Power Tip: Add Sparkline-like graphs to Access reports

re: Power Tip: Add Sparkline-like graphs to Access reports

Chris Downs — Mon, 14 Feb 2011 16:18:17 GMT

Great--thanks for the comment MehdiH, and also thanks to David Z, for the workaround.

re: Power Tip: Add Sparkline-like graphs to Access reports

David Z — Sun, 13 Feb 2011 21:53:29 GMT

@Chris Downs

Chris,

I have tried your proposal unfortunately with the same result. Actually I think it is not necessary to hold a reference to OLE Automation and MS VB for Applications Extensibility 5.3 libraries. The code is compiled properly without them too. I had to create new database and copy all the tables and module into it. If I copied the reports too, the same error arised. So the solution was to create three new reports from scratch.

Thanks for the tip.

David

re: Power Tip: Add Sparkline-like graphs to Access reports

MehdiH — Sun, 13 Feb 2011 07:27:41 GMT

Hi every one,

I just tried the .mdb version on Access 2007 and it worked very well :) thanks to all for the tip.

re: Power Tip: Add Sparkline-like graphs to Access reports

Chris Downs — Fri, 11 Feb 2011 19:10:37 GMT

@David Z,

We haven't seen that problem after running it on a few machines, but a problem like that could be caused by a missing reference. Try the following:

1. Press Alt+F11 to open the Visual Basic Editor.

2. On the Debug menu, click Compile SparkLines. Access will tell you if there are any missing references.

3. To add a reference, on the Tools menu, click References, and then select the one(s) you want to add, and then repeat Step 2.

4. Close the Visual Basic Editor.

5. On the Database Tools tab, click Compact and Repair Database.

6. Try the reports again.

Hope this helps!

--Chris

re: Power Tip: Add Sparkline-like graphs to Access reports

David Z — Fri, 11 Feb 2011 08:54:59 GMT

Hello,

I tried to look at all three reports in both versions. Unfortunately I cannot open them in Print Preview, because an error arises during the communication between MS Access application and OLE server or ActiveX control. Could anybody help me?

Thank you for your reply.

David