template file parameter? - Microsoft Access / VBA

MLH

Searching at http://support.microsoft.com/search/?adv=0 for Access 97
and "templatefile" returns the following:
There are no documents that match your search for "templatefile"

Has anyone ever seen any specification for HTML templatefile
microsoft says can be used in conjunction with the SendObject
and OutPutTo methods - anywhere on the web? Publications or
manuals? A friend or a cousin that may know something or someone?

Nov 20 '06 #1

Subscribe Post Reply

2556

CDMAPoster

MLH wrote:

Searching at http://support.microsoft.com/search/?adv=0 for Access 97
and "templatefile" returns the following:
There are no documents that match your search for "templatefile"

Has anyone ever seen any specification for HTML templatefile
microsoft says can be used in conjunction with the SendObject
and OutPutTo methods - anywhere on the web? Publications or
manuals? A friend or a cousin that may know something or someone?

I once did an HTML template in A97 by replacing valid text/values with
names inside of double angle brackets ala Word:

<<MyParameter>>

e.g., ... bgColor=#<<BackGroundColor>>...

You can use VBA to read in the text of your template, save it as a
string, then use a custom replace function call to substitute in the
values for each of your parameters. Maybe the OutputTo method can get
you an initial HTML file to get you to the starting line. I've never
used SendOutput because it seemed better to use more general methods,
but it may be worthwhile to examine which situations favor its use.

James A. Fortune
CD********@FortuneJames.com

Nov 20 '06 #2

CDMAPoster

CD********@FortuneJames.com wrote:

I once did an HTML template in A97 by replacing valid text/values with
names inside of double angle brackets ala Word:

<<MyParameter>>

e.g., ... bgColor=#<<BackGroundColor>>...

You can use VBA to read in the text of your template, save it as a
string, then use a custom replace function call to substitute in the
values for each of your parameters. Maybe the OutputTo method can get
you an initial HTML file to get you to the starting line. I've never
used SendOutput because it seemed better to use more general methods,
but it may be worthwhile to examine which situations favor its use.

James A. Fortune
CD********@FortuneJames.com

An extension of this idea can produce variable-length HTML tables. If
you have an existing HTML table you can find the part that repeats
(including tags) and use it to generate a variable-length table. Use a
replace marker to replace the repeating part of the HTML table. Then
use a data loop to concatenate as many repeating parts as you need into
a replacement string.

James A. Fortune
CD********@FortuneJames.com

Nov 20 '06 #3

MLH

Both great ideas. Can't wait to try the first one.
Am hoping its the one!

Nov 21 '06 #4

MLH

So something like the HTML snippet below (automatically
produced by the database app - which would explain the
relatively poor HTML design) contain these 7 replaceable
parameters wrapped in <<>might do the trick???

XYZCompany
FaxNum
strOwnerName
OwnerAddr
CodeNum
OwnrFoneNum
OwnrFaxNum


<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type"
CONTENT="text/html;charset=windows-1252">
<TITLE>rptMotorVehicleInfoFAXform</TITLE>
</HEAD>
<BODY>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=32 >
<TD WIDTH=2 ><BR></TD><TD WIDTH=619 ALIGN=CENTER ><B><FONT SIZE=5
FACE="Times New Roman" COLOR=#0000ff><<XYZCompany>></FONT></B></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=125 ><BR></TD><TD WIDTH=373 ALIGN=CENTER ><B><U><FONT
SIZE=3 FACE="Arial" COLOR=#000000>MOTOR VEHICLE INFORMATION FAX
</FONT></B></U></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=89 ><FONT SIZE=3 FACE="Arial"
COLOR=#000000>DATE:</FONT></TD>
<TD WIDTH=249 ALIGN=CENTER ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff>Tuesday, November 21, 2006</FONT></B></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=89 ><FONT SIZE=3 FACE="Arial"
COLOR=#000000>TIME:</FONT></TD>
<TD WIDTH=249 ALIGN=CENTER ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff>10:00:41 AM</FONT></B></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=83 ><FONT SIZE=3 FACE="Arial" COLOR=#000000>TO:</FONT></TD>
<TD WIDTH=540 ><FONT SIZE=3 FACE="Arial" COLOR=#000000>DMV
REGISTRATION </FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=21 >
<TD WIDTH=83 ><BR></TD><TD WIDTH=286 ><FONT SIZE=3 FACE="Arial"
COLOR=#000000>SECTION</FONT></TD>
<TD WIDTH=74 ><FONT SIZE=3 FACE="Arial" COLOR=#000000>VIA
FAX:</FONT></TD>
<TD WIDTH=180 ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff><<FaxNum>></FONT></B></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=94 ><FONT SIZE=3 FACE="Arial" COLOR=#000000>FROM</FONT></TD>
<TD WIDTH=529 ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff><<XYZCompany>></FONT></B></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=17 >
<TD WIDTH=623 ><FONT SIZE=3 FACE="Arial" COLOR=#000000>:</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=94 ><BR></TD><TD WIDTH=529 ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff><<strOwnerName>></FONT></B></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=94 ><BR></TD><TD WIDTH=529 ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff><<OwnerAddr>></FONT></B></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=44 ><BR></TD><TD WIDTH=183 ALIGN=RIGHT ><FONT SIZE=3
FACE="Arial" COLOR=#000000>USER CODE </FONT></TD>
<TD WIDTH=10 ><BR></TD><TD WIDTH=386 ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff><<CodeNum>></FONT></B></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=44 ><BR></TD><TD WIDTH=183 ALIGN=RIGHT ><FONT SIZE=3
FACE="Arial" COLOR=#000000>TELEPHONE </FONT></TD>
<TD WIDTH=10 ><BR></TD><TD WIDTH=386 ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff><<OwnrFoneNum>></FONT></B></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=44 ><BR></TD><TD WIDTH=183 ALIGN=RIGHT ><FONT SIZE=3
FACE="Arial" COLOR=#000000>FAX NUMBER:</FONT></TD>
<TD WIDTH=10 ><BR></TD><TD WIDTH=386 ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff><<OwnrFaxNum>></FONT></B></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=623 ><FONT SIZE=3 FACE="Arial" COLOR=#000000>SECTION I:
INFORMATION SUPPLIED BY USER CODE CUSTOMER</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=44 ><BR></TD><TD WIDTH=126 ><FONT SIZE=3 FACE="Arial"
COLOR=#000000>VEHICLE VIN #:</FONT></TD>
<TD WIDTH=453 ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff>1FAFP34P61W166736</FONT></B></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=44 ><BR></TD><TD WIDTH=186 ><FONT SIZE=3 FACE="Arial"
COLOR=#000000>ODOMETER </FONT></TD>
<TD WIDTH=398 ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff>121,391</FONT></B></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=17 >
<TD WIDTH=44 ><BR></TD><TD WIDTH=579 ><FONT SIZE=3 FACE="Arial"
COLOR=#000000>READING:</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=623 ><FONT SIZE=3 FACE="Arial" COLOR=#000000>SECTION II:
INFORMATION REQUESTED FROM DMV</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=44 ><BR></TD><TD WIDTH=579 ><FONT SIZE=3 FACE="Arial"
COLOR=#000000>1. OWNER NAME AND ADDRESS</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=44 ><BR></TD><TD WIDTH=579 ><FONT SIZE=3 FACE="Arial"
COLOR=#000000>2. LESSOR NAME AND ADDRESS</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=44 ><BR></TD><TD WIDTH=579 ><FONT SIZE=3 FACE="Arial"
COLOR=#000000>3. LIENHOLDER(S) NAME AND ADDRESS</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=44 ><BR></TD><TD WIDTH=579 ><FONT SIZE=3 FACE="Arial"
COLOR=#000000>4. VEHICLE VALUE FROM COMMISSIONER (required by
Clerk of Court)</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=14 >
<TD WIDTH=44 ><BR></TD><TD WIDTH=579 ><U><FONT SIZE=1 FACE="Arial"
COLOR=#000000(Even if vehicle is NOT found in STARS - I still want
and the Clerk of Court REQUIRES the vehicle
evaluation)</FONT></U></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=25 >
<TD WIDTH=2 ><BR></TD><TD WIDTH=174 ><B><I><FONT SIZE=3 FACE="Arial"
COLOR=#000000>SPECIAL NOTE FOR </FONT></B></I></TD>
<TD WIDTH=433 ><B><I><FONT SIZE=1 FACE="Arial" COLOR=#000000>Should
vehicle turn out to be a 'John Doe' (one on which the GA DMV has NO
</FONT></B></I></TD>
<TD WIDTH=447 ><B><I><FONT SIZE=1 FACE="Arial" COLOR=#000000>data on
file) worth less than $800 - then we respectfully request a
</FONT></B></I></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=17 >
<TD WIDTH=2 ><BR></TD><TD WIDTH=174 ><B><I><FONT SIZE=3 FACE="Arial"
COLOR=#000000>CHARLES DAVIS:</FONT></B></I></TD>
<TD WIDTH=447 ><B><I><FONT SIZE=1 FACE="Arial" COLOR=#000000>data on
file) worth less than $800 - then we respectfully request a
</FONT></B></I></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=12 >
<TD WIDTH=176 ><BR></TD><TD WIDTH=447 ><B><I><FONT SIZE=1 FACE="Arial"
COLOR=#000000>'Correspondence Letter' from the Mail & Distribution
Center (Mary Biggs) </FONT></B></I></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=12 >
<TD WIDTH=176 ><BR></TD><TD WIDTH=447 ><B><I><FONT SIZE=1 FACE="Arial"
COLOR=#000000>stating that GA DMV has no owner information on file for
VIN </FONT></B></I></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=12 >
<TD WIDTH=176 ><BR></TD><TD WIDTH=447 ><B><I><FONT SIZE=1 FACE="Arial"
COLOR=#000000>#1FAFP34P61W166736 (per Karen).</FONT></B></I></TD>
</TR>
</TABLE>

</BODY>
</HTML>

How is it that I tell the Access application's SendObject method to be
on the "lookout" for those variables and which values are slated for
substitution in place of the parms?

Nov 21 '06 #5

CDMAPoster

MLH wrote:

So something like the HTML snippet below (automatically
produced by the database app - which would explain the
relatively poor HTML design) contain these 7 replaceable
parameters wrapped in <<>might do the trick???

...

I think you've got the idea.

How is it that I tell the Access application's SendObject method to be
on the "lookout" for those variables and which values are slated for
substitution in place of the parms?

Replace the parameters one after the other in code. E.g.,

strHTMLFileText = Replace(strHTMLFileText, "<<XYZCompany>>",
Nz(MyRS("CompanyName"), ""))
strHTMLFileText = Replace(strHTMLFileText, "<<FaxNum>>",
Nz(MyRS("FaxNumber"), ""))
....

Instead of hard coding the replacements you can use a table:

tblReplacements

RID Token FieldName
1 <<XYZCompany>CompanyName
2 <<FaxNum>FaxNumber
....

and put the Replace line in a loop. Once you have the final HTML
string you can write it to a file or do something creative with it. As
I said, I don't use the SendObject method so I don't know if it can use
a string in memory directly.

James A. Fortune
CD********@FortuneJames.com

Nov 21 '06 #6

Similar topics

XSL transformation not finding template

by: Kevin Dean | last post by:

I'm trying to create an XSL transformation that will strip out development-specific attributes from deployment descriptors and other XML files. I have already successfully done so with web.xml but...

.NET Framework

template function as function parameter

by: rg | last post by:

Hi all, I was wondering if anyone had dealt with a similar problem. I need to use a template function as the parameter for a particular function (also template function). The program compiles...

C / C++

Template class partial specialisation problem

by: Lionel B | last post by:

Greetings. The following code compiles ok and does what I'd expect it to do: ---------- START CODE ---------- // test.cpp

C / C++

implicit type template warning

by: Johan | last post by:

Hi Can somebody explain to me why I get this warning message and how I can solve this warning message. Thanks a lot Johan In member function `void

C / C++

Why avoid constant template parameter

by: Tony Johansson | last post by:

Hello Experts! What does this mean actually. If you have a template with a type and non-type template argument, say, like this template<typename T, int a> class Array {. . .}; then A<int,...

C / C++

pure virtual template...

by: mathieu | last post by:

Hi there, I don't think I'll be able to describe my issue correctly, so instead I'll just give a pseudo C++ code I am struggling with. Basically I am looking for a 'pure virtual template'...

C / C++

Port to gcc-4.3 (template template issue)

by: ndbecker2 | last post by:

On upgrading from gcc-4.1.2 to gcc-4.3, this (stripped down) code is now rejected: #include <vector> #include <iostream> template<typename T, template <typename Aclass CONT=std::vector>...

C / C++

Giving NULL value to non-type template parameter

by: neelsmail | last post by:

Hi, I want to give default value as NULL/0 for non-type template parameter. I using SunStudio on Linux. I have tried following: #define non_closer ((int(*)(FILE*))0L) template<class T, int...

C / C++

A workable scheme for "template parameter-conditional compilation"?

by: Lionel B | last post by:

I frequently seem to run into the following annoyance regarding template class specialisation: I have a template class which implements, for a general template parameter, some basic functionality...

C / C++

Problem with template class

by: Gaijinco | last post by:

I'm trying to do a template class Node. My node.hpp is: #ifndef _NODE_HPP_ #define _NODE_HPP_ namespace com { namespace mnya { namespace carlos { template <typename T>

C / C++

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server