Results 1 to 13 of 13
  1. #1
    New Lounger
    Join Date
    Mar 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    exporting static html from Access (Access 2002, sp2)

    Hi,
    First, my Access experience is "beginner level", so any help needs to be explained in detail.

    My requirement is to export a simple Access report to a series of static html pages. The report has no header or footer and I have used design view to lay out elements (fields) from the query in the report detail section. The export to an rtf file works ok.

    However, I'd welcome suggestions on the following:
    (a) When exporting the report to html, the created html files retain the page setup characteristics of a real printer (ie each html file contains the same amount of data/records that would be on an A4 printed page). How do I set the report to ignore this page size and put more data into each html file?
    ([img]/forums/images/smilies/cool.gif[/img] When the html files are created, the report detail layout changes slightly. For example, elements in the design view detail alter their relative alignment - elements of different vertical size (that I had placed aligned by their tops) align along their centres. Is there a way around this?
    The exported html files do not contain the images that are defined in the report detail (but this issue does not arise when exporting to rtf files). What am I not doing right?

    Thanks in advance for any responses.
    rgds,
    Dave

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: exporting static html from Access (Access 2002, sp2)

    I'm afraid your question is a bit confusing, Dave. If by "images" you mean graphics, they aren't exported to rtf at all, so I don't understand your remark. <img src=/S/confused.gif border=0 alt=confused width=15 height=20> As for changing the data that goes into the html document, the idea is to convert the report, as you see it, to html. If you want it different, the simplest thing to do is create a different report to export.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Mar 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: exporting static html from Access (Access 2002, sp2)

    charlotte - thanks.
    Yes, I mean graphics, and yes (I'm mistaken), the images are not exported to the rtf file (could have sworn differently!).
    So based on your response, the immediate requirement is to create a report that isn't bound by the physical characteristics of a printer - i.e. every time the report generates and A4 "page full" of data, I don't want the export activity to start a new html file.... But that's another way of expressing the problem I've encountered....every report I create appears to do that by default, and I don't understand what I'm doing wrong (or what I'm not configuring correctly) in the report definition.
    rgds,
    Dave.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: exporting static html from Access (Access 2002, sp2)

    Access is doing exactly what it was designed to do and exactly what you're telling it to do. The problem is that you really want it to do something it was NOT designed to do. Unless you are a programmer, I suspect you aren't going to be able to accomplish what you're trying to accomplish. What you actually need to do may be to export the data to XML with a style sheet to format the results, but that isn't the same thing as a static HTML page.
    Charlotte

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: exporting static html from Access (Access 2002, sp2)

    An Access report is a means of presenting data from the database on paper; it is divided into pages by its very nature.

    When you export a report to RTF, page breaks are inserted. When you export to HTML, a separate HTML page is created for each page in the report. I don't think you can prevent that.

  6. #6
    New Lounger
    Join Date
    Mar 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: exporting static html from Access (Access 2002, sp2)

    charlotte - thanks again!
    So the export of static html will always be bound by the associated printer page size - and if that;s the case, your quite right - it doesn't do what I need.
    I'll investigate alternatives.
    Thanks gain,
    Dave.

  7. #7
    New Lounger
    Join Date
    Mar 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: exporting static html from Access (Access 2002, sp2)

    Hans, thanks.
    You've stated the limitation very well!
    I may well look at the xml alternative as that may overcome the formatting limitation (as charlotte has suggested). (One of the other issues I had with the static pages were that the html contained its own formatting - therefore taking precedence ovber the style sheet settings on my site......)
    thanks,
    Dave.

  8. #8
    New Lounger
    Join Date
    Mar 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: exporting static html from Access (Access 2002, sp2)

    As a final input to this thread, and for the benefit of other readers, I did try defining a printer with continuous stationery and a looooonnnnnggg page size in an attempt to get the export to create larger html files. This had some success, but access places a limit on page length of just over 25".

    Thanks again for the help.
    rgds,
    Dave.

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: exporting static html from Access (Access 2002, sp2)

    According to the online help, each section in a form or report has a maximum width and height of 22 inches. I don't know if setting the Keep Together property of the detail section to No will allow more details sections to be printed to the same "page", but perhas you should ask yourself whether you want to confront people with a web page of more than 25 inches in height...

  10. #10
    New Lounger
    Join Date
    Feb 2003
    Location
    Toronto, Ontario, Canada
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: exporting static html from Access (Access 2002, sp2)

    Dave,

    If you are only concerned with making the Access report available via a web page, why not create a PDF image of the Access report and then add the PDF file, which has the image of the Access report, to the web site.

    Of course you would need a PDF creation tool such as Adobe Acrobat to create the PDF file.

    Or if you do not have a tool such as Acrobat, try a google search of 'FREE PDF' to look for some affordable PDF solutions.

    Regards

  11. #11
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: exporting static html from Access (Access 2002, sp2)

    Have a look at the thread beginning with <post#=196248>post 196248</post#> which deals with the same question, and has a couple of suggestions.
    If your report exports successfully to rtf, then the option of sending it to Word, then using the "Save as Web Page" in Word should work OK with no page breaks.
    Regards
    John



  12. #12
    New Lounger
    Join Date
    Mar 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: exporting static html from Access (Access 2002, sp2)

    John and others,

    Many thanks - I will pursue the ideas in the several responses on this thread.
    Hans - My database will be a book catalogue, so generating web pages longer than the normal A4 length is quite sensible once graphics are taken into account.
    thanks again,
    Dave.

  13. #13
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: exporting static html from Access (Access 2002, sp2)

    Graphics are lost when you export to rtf, so if your catalogue includes graphics, going via Word is not going to help.
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •