Results 1 to 3 of 3
  1. #1
    starhawk85 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    9

    Lightbulb Exporting to HTML Trouble

    Hello.

    I am attempting to export my report to html pages, I am using an HTML Template to do this I have setup the Template with the appropriate tags

    Lets say this is my whole template.

    Code:
    <html>
    <head>
    <title><!--AccessTemplate_Title--></title>
    </head>
    <body><!--AccessTemplate_Body--></body>
    </html>
    Now that i have my template, I am able to export to HTML from access when i export from access and i open my new HTML pages access was so kind to quickly create i have this code

    Code:
    <head>
    <title>REPORT NAME</title>
    </head>
    <body><TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
    <TR HEIGHT=10 >
    <TD WIDTH=388  ALIGN=CENTER  BGCOLOR=#FFFFFF ><B><FONT style=FONT-SIZE:6pt FACE="Arial" COLOR=#000000>FIRST TABLE</FONT></B></TD>
    </TR>
    </TABLE>
    <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
    <TR HEIGHT=31 >
    <TD WIDTH=389  ALIGN=LEFT  BGCOLOR=#FFFFFF ><B><FONT style=FONT-SIZE:20pt FACE="Arial" COLOR=#000000>SECOND TABLE</FONT></B></TD>
    </TR>
    </TABLE></body>
    </html>
    Now what i really would like to do is ensure that in my <title> </title> tag i can have it export with the table name instead such as

    Code:
    <head>
    <title>SECOND TABLE</title>
    </head>
    <body><TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
    <TR HEIGHT=10 >
    <TD WIDTH=388  ALIGN=CENTER  BGCOLOR=#FFFFFF ><B><FONT  style=FONT-SIZE:6pt FACE="Arial" COLOR=#000000>FIRST  TABLE</FONT></B></TD>
    </TR>
    </TABLE>
    <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
    <TR HEIGHT=31 >
    <TD WIDTH=389  ALIGN=LEFT  BGCOLOR=#FFFFFF ><B><FONT  style=FONT-SIZE:20pt FACE="Arial" COLOR=#000000>SECOND  TABLE</FONT></B></TD>
    </TR>
    </TABLE></body>
    </html>
    There must be a tag of some sort to replace <!--AceessTemplate_Title--> with something of the sort <!--AccessTemplate_Table_Table2-->
    Now i have tried various possibilities and really hoping some of you out there that are HTML and Access Knowledgeable could help me with this delema.


    Please respond with any ideas.

    Thanks in advance!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    The resulting HTML file is a text document and can be edited by a simple text editor so presumably code can be used to edit the file. Review http://itknowledgeexchange.techtarge...ms-access-vba/
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Print all New Records to HTML
    By ringod30 in forum Forms
    Replies: 0
    Last Post: 04-05-2011, 06:51 AM
  2. ODBC Html
    By trenta7 in forum Import/Export Data
    Replies: 1
    Last Post: 02-08-2011, 08:55 AM
  3. HTML Editor
    By mystifier in forum Forms
    Replies: 3
    Last Post: 11-11-2010, 05:51 AM
  4. Exporting a query to HTML
    By Remster in forum Access
    Replies: 8
    Last Post: 09-10-2010, 04:52 PM
  5. HTML E-mail Using VBA
    By graviz in forum Programming
    Replies: 1
    Last Post: 12-09-2009, 08:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums