C
centaur
Guest
When exporting a report (Static HTML), It is possible to base it on an html
template.
I am aware of the tags that I have put at the close of my posting (so that
we are not confused as to what I am trying to explain).
What I would like to know please is (and I am not sure of the correct
terminology) what tags do I put in an HTML document to insure that specific
fields appear in specific places on a web page?
As a For Instance I may have a record that has the following information
Field01 = picture1.jpg
Field02 = This is the title in record 1
Field03 = This is a long description in record 1
Field04 = AMerryTune.mp3
Field05 = w w w.mymerrytune.com/moreinformation.html (NB have put spaces to prevent this becoming a real url)
My HTML Template will be such that :-
Field01 will put the correct picture on the page in the template
location - ie a different picture for each record hence record 1 has picture1.jpg
Field02 and Field03 Will put the title and description in the correct
place
Field04 Has The web section of Windows Media Player imbedded in the page
(I know how to imbed the player - I don't know how to pass the mp3 data from
access to the correct location) so when someone clicks the play the correct
tune will start playing the correct tune.
Field05 will be the URL that is loaded when a PICTURE of a button is
clicked in order to find out more information.
What Tags do I use, and how do I link them to fields, to put the right
data in the right place.
ALSO
Despite there being <!--AccessTemplate_PreviousPage--> tags. If there are
say 22 records, how can I make the following happen:-
First 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Last
I also know that there is 3rd party software that will do this such as dbqwiksite, but I would prefer to remain with access if it is possible.
Many thanks to all who reply.
Best wishes
Breezereef
Addendum - I aware of the following, but it does not tell me the method of putting in ACTUAL field names.
<!--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
<!--AccessTemplate_Body-->
The output of the table, query, form, or report
<!--AccessTemplate_FirstPage-->
An HTML anchor tag that links to the first page of a report
<!--AccessTemplate_PreviousPage-->
An HTML anchor tag that links to the page previous to the current report
page
<!--AccessTemplate_NextPage-->
An HTML anchor tag that links to the next page after the current report page
<!--AccessTemplate_LastPage-->
An HTML anchor tag that links to the last page of a report
<!--AccessTemplate_PageNumber-->
The current page number
HTML template file example
<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>
template.
I am aware of the tags that I have put at the close of my posting (so that
we are not confused as to what I am trying to explain).
What I would like to know please is (and I am not sure of the correct
terminology) what tags do I put in an HTML document to insure that specific
fields appear in specific places on a web page?
As a For Instance I may have a record that has the following information
Field01 = picture1.jpg
Field02 = This is the title in record 1
Field03 = This is a long description in record 1
Field04 = AMerryTune.mp3
Field05 = w w w.mymerrytune.com/moreinformation.html (NB have put spaces to prevent this becoming a real url)
My HTML Template will be such that :-
Field01 will put the correct picture on the page in the template
location - ie a different picture for each record hence record 1 has picture1.jpg
Field02 and Field03 Will put the title and description in the correct
place
Field04 Has The web section of Windows Media Player imbedded in the page
(I know how to imbed the player - I don't know how to pass the mp3 data from
access to the correct location) so when someone clicks the play the correct
tune will start playing the correct tune.
Field05 will be the URL that is loaded when a PICTURE of a button is
clicked in order to find out more information.
What Tags do I use, and how do I link them to fields, to put the right
data in the right place.
ALSO
Despite there being <!--AccessTemplate_PreviousPage--> tags. If there are
say 22 records, how can I make the following happen:-
First 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Last
I also know that there is 3rd party software that will do this such as dbqwiksite, but I would prefer to remain with access if it is possible.
Many thanks to all who reply.
Best wishes
Breezereef
Addendum - I aware of the following, but it does not tell me the method of putting in ACTUAL field names.
<!--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
<!--AccessTemplate_Body-->
The output of the table, query, form, or report
<!--AccessTemplate_FirstPage-->
An HTML anchor tag that links to the first page of a report
<!--AccessTemplate_PreviousPage-->
An HTML anchor tag that links to the page previous to the current report
page
<!--AccessTemplate_NextPage-->
An HTML anchor tag that links to the next page after the current report page
<!--AccessTemplate_LastPage-->
An HTML anchor tag that links to the last page of a report
<!--AccessTemplate_PageNumber-->
The current page number
HTML template file example
<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>
