Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    May 2001
    Location
    QLD, Australia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Web Publishing Wizard (access 97)

    Hi all,
    I am publishing a report via the Web Publishing Wizard. The report is help desk calls for technical staff and I want the techs to be able to go to a web page and print all of their calls. Unfortunately (in this case), instead of publishing in long HTML file, the report is split into several pages. This means that to print out the calls, each tech has to jump to all of the links and click on print. THis is particularly clumsy if the tech has many calls. Does anyone know a way to force the Web wizard to NOT split the report into pages ?

    Craig

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

    Re: Web Publishing Wizard (access 97)

    I doubt that you can do anything with the wizard aside from what it's built to do. You're probably going to have to edit the html source for the pages yourself to get what you want.
    Charlotte

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

    Re: Web Publishing Wizard (access 97)

    Another way to achieve a similar result without the page breaks is to use Office Links to drop the report into Word, then use "Save as a web page" in Word.
    Regards
    John



  4. #4
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Web Publishing Wizard (access 97)

    Another way is to roll your own HTML export routine.

    I have a sample db that shows how to export a recordset to an HTML file, but it's at work and I'm at home <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

    I will try and remeber to post it tomorrow when I get to work.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  5. #5
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Web Publishing Wizard (access 97)

    Craig,

    Finally as promised, here is the sample database (plus supporting files) I was talking about.

    This will take an HTML template (template.html) and take the data from tblAirFare and puts it onto columns under the headings that are already in the template.

    If you open Module1 and run sTestReport, this will dump the data into a new html file called report.html in the directory "Cocuments and SettingsUSRDesktophtmlsample"

    Obviously you will need to change the paths to suit your needs, but it should be pretty self-explanatory where to do that.

    The heart of the code is in the sWriteHTMLReport procedure.

    What it does is uses low-level File I/O to read and write the html file. It gets a line at a time from the template.html and looks for an html comment < ! - - Data Goes Here - - >. Once it finds this line, it starts to build up the line of HTML code for that particular row of data. Once the line is built, it writes that line to the report.html file. This section loops until you hit the end of the recordset.

    Then it will go back to the template and write out the "footer" to the report.html.

    THis was originally written in A2K and then downconverted to A97. I can't test the downconverted version, since I don't have A97 here at work.

    If you have any questions, please ask.

    HTH,
    Attached Files Attached Files
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  6. #6
    New Lounger
    Join Date
    May 2001
    Location
    QLD, Australia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Web Publishing Wizard (access 97)

    Hey that's just what I needed ! Thanks for your time.

    Craig

  7. #7
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Web Publishing Wizard (access 97)

    Craig,

    I'm glad it was what you are after. Especially after I forgot to post the sample when I said I would <img src=/S/sorry.gif border=0 alt=sorry width=15 height=15>
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

Posting Permissions

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