Hi. I'm looking at this subject with a view to create graphical reports and export as html to include in a website. I've not looked at this before but it seems quite a tricky subject to include formatting, images, charts etc to be shown as html.
Can any members offer any advice or links to good articles or examples?
Cheers
HTML Reports
-
- SilverLounger
- Posts: 1728
- Joined: 25 Jan 2010, 08:34
- Location: Stoke on Trent - Staffordshire - England
HTML Reports
Cheers ...
Dave.
Dave.
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: HTML Reports
The export-to-HTML feature built into Access is very weak - only the text is exported, all graphical elements are discarded.
One option is to write your own code that creates HTML pages complete with graphics. A lot of work.
Another option is to use print-to-HTML software, comparable to print-to-PDF. For example: Aurelia Systems - you can download a free 30-day trial version.
Or export to PDF (built into Access 2007 and later), and make the PDF available on the website.
One option is to write your own code that creates HTML pages complete with graphics. A lot of work.
Another option is to use print-to-HTML software, comparable to print-to-PDF. For example: Aurelia Systems - you can download a free 30-day trial version.
Or export to PDF (built into Access 2007 and later), and make the PDF available on the website.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1728
- Joined: 25 Jan 2010, 08:34
- Location: Stoke on Trent - Staffordshire - England
Re: HTML Reports
Hi Hans
You would have thought Microsoft would have a solution for this, obviously not so..
I've had a look at Aurelia this morning, it may be something to work with. Allen Browne's site has some information on exporting data to html along with css which works pretty well but its only good for table style data. I was hoping to create a graphical dash for each of my clients.
But, great information from you as ever and appreciated.
Thanks again.
You would have thought Microsoft would have a solution for this, obviously not so..
I've had a look at Aurelia this morning, it may be something to work with. Allen Browne's site has some information on exporting data to html along with css which works pretty well but its only good for table style data. I was hoping to create a graphical dash for each of my clients.
But, great information from you as ever and appreciated.
Thanks again.
Cheers ...
Dave.
Dave.
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: HTML Reports
I'm afraid that Microsoft isn't interested in improving the desktop version of Access any more.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: HTML Reports
What version of Access are they interested in?
Could this be the start of a giant shift for us?
Could this be the start of a giant shift for us?
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: HTML Reports
I haven't been taking notice, what can I read up on to keep abreast
-
- Administrator
- Posts: 78596
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: HTML Reports
Thank you Hans.
I will probably use the Hybridise approach in future as VBA is not supported in Web Apps or Web Databases using Access.
I will probably use the Hybridise approach in future as VBA is not supported in Web Apps or Web Databases using Access.