Reports with data in the title (1 Viewer)

Trew · Mar 5, 2012

Problem: I have a MS Access database. I want to create individual web pages for each product in the table so people can use search engines find my product # and link to that page. Also, I would like to get the product name to display in the html <Title> tag.

So far, I am able to create a report which will export into individual html files/pages and display the product in the body. It displays the Report Name in the html <title> tag. So I'm close but can't bring it home. Here is the html I am currently generating:

<HTML>
<HEAD>
<METAHTTP-EQUIV="Content-Type" CONTENT="text/html;charset=windows-1252">
<TITLE>MY BUSINESS NAME</TITLE>
</HEAD>
<BODY>
<TABLEBORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TRHEIGHT=28 >
<TDWIDTH=8 ALIGN=LEFT > <BR></TD><TDWIDTH=472 ALIGN=LEFT ><FONTstyle=FONT-SIZE:18pt FACE="Arial" COLOR=#000000>My Business</FONT></TD>
</TR>
</TABLE>
<TABLEBORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TRHEIGHT=14 >
<TDWIDTH=52 ALIGN=LEFT > <BR></TD><TDWIDTH=428 ALIGN=LEFT ><FONTstyle=FONT-SIZE:8pt FACE="Arial" COLOR=#000000>Call 1-800-123-4567 for current availability and price</FONT></TD>
</TR>
</TABLE>
<TABLEBORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TRHEIGHT=14 >
<TDWIDTH=80 ALIGN=LEFT > <BR></TD><TDWIDTH=44 ALIGN=LEFT ><FONTstyle=FONT-SIZE:8pt FACE="Arial" COLOR=#000000>1</FONT></TD>
<TDWIDTH=356 ALIGN=LEFT ><FONTstyle=FONT-SIZE:8pt FACE="Arial" COLOR=#000000>abc123v</FONT></TD>
</TR>
</TABLE>
<TABLEBORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TRHEIGHT=19 >
<TDWIDTH=108 ALIGN=LEFT > <BR></TD><TDWIDTH=372 ALIGN=LEFT ><FONTstyle=FONT-SIZE:12pt FACE="Arial" COLOR=#000000>visit MyBusiness.com</FONT></TD>
</TR>
</TABLE>
</BODY>
</HTML>

The highlighted "ABC123V" is a sample product name supplied by the data table. "MY BUSINESS NAME" is the Report Name. Each of the following pages are identified by a page # ie. <TITLE>MY BUSINESS NAMEPage2</TITLE> and ideally I would like it to read something like <TITLE>MY BUSINESS NAME| ABC123V</TITLE> The crawlers will find the product in the body but I was hoping to improve indexing by getting it in the title tag. All help appreciated.

Simon_MT · Mar 6, 2012

The reason that no-one has replied is this html code is incorrect and incorrectly constructed. It may pay to look at http://www.w3schools.com and use sytlesheets. Your header should look like:

Code:

<head> <title>Trevor Sutton</title>
<meta name="description" content="Trevor Sutton contemporary abstract artist London">
<meta name="keywords" content="Trevor Sutton contemporary abstract artist London">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<link rel="shortcut icon" href="[URL="http://www.access-programmers.co.uk/forums/view-source:http://www.trevorsutton.com/favicon.ico"]http://www.trevorsutton.com/favicon.ico[/URL]" title="Trevor Sutton">
<meta name="rating" content="General">
<meta name="author"content="Simon Miles-Taylor">
<meta name="copyright" content="Designed Logic 2003-2012">
<meta name="robots" content="all">
<meta name="revisit-after" content="1 week">
<link rel="stylesheet" href="[URL="http://www.access-programmers.co.uk/forums/view-source:http://www.trevorsutton.com/include/artistsstyle.css"]http://www.trevorsutton.com/include/artistsstyle.css[/URL]">
</head>
<body>

Simon

Reports with data in the title (1 Viewer)

Trew

New member

Simon_MT

Registered User.

Similar threads

Users who are viewing this thread