Access Report Posted on the Web

[ChiTownDiva]

I'm trying to post a daily Access Report on my company's website by running a macro where the output format is HTML. I have the template created and folder for the report pages.

For some reason, whe I run the macro, I get an error message that says:

You tried to use a form, report, or datasheet that contains an OLE object, but the OLE server (the application used to create the object) may not be registered properly. Reinstall the OLE server to register it correctly.

There is no OLE object on the report...only headers and footers and nothing out of the ordinary with those. There are no pictures, no unusal fonts, etc.

When I just plain exported the report, it worked fine, but I need to have this automated by (hopefully) using a macro.

Has anybody posted an Access report to their inter/intranet site?

Thanks.

 

[DougP]

paste you exact Macro code here DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[ChiTownDiva]

Hi, Doug,

Today I'm not getting that message, but now the hyperlinks at the bottom of the page are not there. It says &quot;</HTML&quot;, but when I look at the template called &quot;index.html&quot;, the hyperlinks are there, and the page ending tag is correct (</HTML>).

I created a template called &quot;index.html&quot; (I know I need to change the name--but right now I'm trying to get it work), and on the template it has the hyperlinks, &quot;First Previous, Next, Last&quot;.

I'm using a macro where the Action is &quot;OutputTo&quot;:

Object Type: Report
Object Name: qryCustSatAdministrators
Output Format: HTML
Output File: C:\Documents and Settings\ytalodin\My Documents\My Webs\Copy of CustSat\Customer Sat Report\qryCustSatAdministrators.html
Auto Start: No
Template File: C:\Documents and Settings\ytalodin\My Documents\My Webs\Copy of CustSat\index.html

So, what gives?