X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Exporting Report Into A Single Html File With Images And Lines, Access 2016    
post Nov 30 2017, 09:31 AM

Posts: 4
Joined: 12-November 02

Hi Everyone,

I'm relatively new to access and I am trying to export my report into a single html file. Below are some problems I encounter:
1. It generated many html files because I have a relatively long list. It also comes with previous and next page. I am trying to have everything in a long page.

2. The images in my data is not reflected in the html. The image area is blank.

3. Border lines on by Report are not showing in the html file(s)

Please kindly advise if what I am trying to do is possible.

Ideally I am trying to have my report embeded into the MS Outlook email but I am more than happy to have it in a single html file with images as well as the borderlines in place.

Thanks in advance!
Go to the top of the page
post Nov 30 2017, 09:45 AM

Posts: 18,324
Joined: 29-March 05
From: Wisconsin


I'm not aware of a way to "export" a report to HTML format automatically. However, years ago I created some code to build an HTML file from scratch using data from a query. Depending on the complexity of your report, and your skills with VBA, this may be something you want to look into.

The first step to this would be to create a test report manually. You can do this in Word. However, rather than just using the HTML created by Word (which frankly is excessive and hard to read, IMHO), you can use this web page to convert the Word file contents to clean HTML. Once your test report looks good in a web browser and the HTML is fairly easy to read, the next step will be to write a subroutine that re-creates an exact copy of this file using code.

The code I created was heavily based on a chapter in "Access 97 For Dummies" - specifically the chapter on Publishing Data for the Web that was on the included CD. I did say it was years ago, after all. smile.gif

Hope this helps,


EDIT: I'm not sure if this is what you meant, but any images that appear on your HTML page will need to be separate from the HTML file. You can't combine them into one file.
Go to the top of the page
post Nov 30 2017, 12:41 PM

Posts: 4
Joined: 12-November 02

Hi Dennis,

Thanks so much for your reply. Let me have a look and will let you know if it works smile.gif

Very much appreciated!!

Go to the top of the page
post Nov 30 2017, 03:16 PM

Utterly Eccentric and Moderator
Posts: 4,065
Joined: 4-March 00
From: Bristol / Ipswich / Spain

you can add an image to an HtML file using an 'undocumented' feature. Its HERE

All the best,

Go to the top of the page
post Dec 1 2017, 06:27 AM

Posts: 4
Joined: 12-November 02

Thanks for your advices.

Didn't know this request itself is so tedious. I am seriously having problems as I'm not savvy with the codings. Appreciate lots.
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    23rd October 2018 - 05:45 PM