Results 1 to 10 of 10
  1. 04-25-2012, 08:35 AM #1
    starhawk85
    starhawk85 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    9

    help with tag

    Hey new here,

    So here is my problem, i have exported report as html, I have created a template and it all exports great!


    So here is my problem, (im using Microsoft example so show)
    In Bold Red i want to know if there is a way to place the Title with lets say Buisness name.. if so how?

    <HTML>
    <!--The following token places the object name in the title bar of the Web browser.-->
    <TITLE><!--AccessTemplate_Title--></TITLE>

    <!--The following HTML tag creates a different background color than the Web browser default.-->
    <BODY BACKGROUND = "gray.jpg">


    <!--The following token places all object output inside the <BODY> tag.-->
    <!--AccessTemplate_Body-->
    </BODY>
    <BR><BR>
    <!--The following four tokens create four navigation text buttons that jump to the first, previous, next, and last pages of a report.-->
    <A HREF = "<!--AccessTemplate_FirstPage-->">First</A>
    <A HREF = "<!--AccessTemplate_PreviousPage-->">Previous</A>
    <A HREF = "<!--AccessTemplate_NextPage-->">Next</A>
    <A HREF = "<!--AccessTemplate_LastPage-->">Last</A>
    <!--The following token inserts the text "Page n" , where n is the current report page number.-->
    <P ALIGN = CENTER>Page <!--AccessTemplate_PageNumber-->.</P>
    <!--The following HTML tag adds a company logo to the bottom of the Web page.-->
    <IMG SRC = "company_logo.jpg">
    </HTML>


    Thanks in advance.
    Reply With Quote Reply With Quote
  2. 04-25-2012, 11:59 AM #2
    starhawk85
    starhawk85 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    9
    In Bold Red i want to know if there is a way to place the "Title" with lets say "Buisness name" that is within the report its self.. if so how?
    Reply With Quote Reply With Quote
  3. 04-25-2012, 12:27 PM #3
    June7's Avatar
    June7
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,630
    I can't find anything about merging data from Access to html template. Is this template part of a web design?

    This thread offers alternative http://www.pcreview.co.uk/forums/htm...-t1101980.html
    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.
    Reply With Quote Reply With Quote
  4. 04-25-2012, 01:20 PM #4
    starhawk85
    starhawk85 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    9
    it is an HTML Template .... to export report to HTML file

    here are some links to hopefully better understand what i am trying to do.

    http://www.ehow.com/how_5652706_crea...ms-access.html

    http://office.microsoft.com/en-us/ac...005269264.aspx



    I aware of the following, but it does not tell me the method of putting in ACTUAL field names.

    <!--AccessTemplate_Title-->

    Here is an explination.

    <HTML>

    <!--The following token places the object name in the title bar of the Web
    browser.-->

    <TITLE><!--AccessTemplate_Title--></TITLE>

    <!--The following HTML tag creates a different background color than the Web
    browser default.-->

    <BODY BACKGROUND = "gray.jpg">

    <!--The following token places all object output inside the <BODY> tag.-->

    <!--AccessTemplate_Body-->

    </BODY>

    <BR><BR>

    <!--The following four tokens create four navigation text buttons that jump
    to the first, previous, next, and last pages of a report.-->

    <A HREF = "<!--AccessTemplate_FirstPage-->">First</A>

    <A HREF = "<!--AccessTemplate_PreviousPage-->">Previous</A>

    <A HREF = "<!--AccessTemplate_NextPage-->">Next</A>

    <A HREF = "<!--AccessTemplate_LastPage-->">Last</A>

    <!--The following token inserts the text "Page n" , where n is the current
    report page number.-->

    <P ALIGN = CENTER>Page <!--AccessTemplate_PageNumber-->.</P>

    <!--The following HTML tag adds a company logo to the bottom of the Web
    page.-->

    <IMG SRC = "company_logo.jpg">

    </HTML>
    Reply With Quote Reply With Quote
  5. 04-25-2012, 01:32 PM #5
    June7's Avatar
    June7
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,630
    From the second link:
    When you output a table, query, form, or report using the Export command on the File menu and you specify an HTML template file in the Output Options dialog box, Access merges the HTML template file with the .html, .asp, and .htx output files by replacing the tokens (such as <!--AccessTemplate_Title-->) with the following:

    <!--AccessTemplate_Title-->)
    Becomes the name of the table, query, form, or report placed in the title bar of the Web browser
    ...
    So according to this you would have to rename the object before exporting to template. I have seen code to do this. It was one poster's solution to a similar situation with Word or Outlook template.
    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.
    Reply With Quote Reply With Quote
  6. 04-25-2012, 01:36 PM #6
    starhawk85
    starhawk85 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    9
    so real confession, I don't use access, I'm a Graphic and Web Designer, just trying to understand how to accomplish this.

    So i would explain to the person whom handles access to rename the object? not sure what you mean.
    Reply With Quote Reply With Quote
  7. 04-25-2012, 01:40 PM #7
    June7's Avatar
    June7
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,630
    The solution I refer to uses VBA code to rename object, run export, then renames it back to the original generic name so it will be available for next execution with a different output name. Just don't know if I can find again.
    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.
    Reply With Quote Reply With Quote
  8. 04-26-2012, 12:10 PM #8
    starhawk85
    starhawk85 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    9
    ill really need help with this!


    <!--AccessTemplate_Table_Name--> somthing like this at all possible? HELP!!!!!!
    Reply With Quote Reply With Quote
  9. 04-26-2012, 05:04 PM #9
    June7's Avatar
    June7
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,630
    I found the thread I was thinking of. The solution involves opening a report and setting the caption property of the report. The caption property is used in the SendObject method naming the PDF document. I am guessing that if the caption property is empty, the report name will be used.

    So maybe does not relate to your situation but if you want to see it anyway:
    https://www.accessforums.net/showthr...ght=SendObject

    In your case, if setting the caption property does not work, then I am thinking the object has to be renamed, export to HTML, renamed back to original name. Review
    http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
    http://www.tek-tips.com/viewthread.cfm?qid=1129095
    Last edited by June7; 04-26-2012 at 11:29 PM.
    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.
    Reply With Quote Reply With Quote
  10. 04-26-2012, 09:19 PM #10
    starhawk85
    starhawk85 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    9
    this is a great idea i will send this to my access tech and see if we can get it to work for us. if not ill be back.. :P
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums