template file parameter? - Microsoft Access / VBA

MLH

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

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 Reply

2575

CDMAPoster

MLH wrote:

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

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=#<<Back GroundColor>>.. .

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********@Fort uneJames.com

Nov 20 '06 #2

CDMAPoster

CD********@Fort uneJames.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=#<<Back GroundColor>>.. .

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********@Fort uneJames.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********@Fort uneJames.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=wi ndows-1252">
<TITLE>rptMotor VehicleInfoFAXf orm</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>M OTOR 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>D ATE:</FONT></TD>
<TD WIDTH=249 ALIGN=CENTER ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff>T uesday, 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>T IME:</FONT></TD>
<TD WIDTH=249 ALIGN=CENTER ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff>1 0: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>T O:</FONT></TD>
<TD WIDTH=540 ><FONT SIZE=3 FACE="Arial" COLOR=#000000>D MV
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>S ECTION</FONT></TD>
<TD WIDTH=74 ><FONT SIZE=3 FACE="Arial" COLOR=#000000>V IA
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>F ROM</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>U SER 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>T ELEPHONE </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>F AX 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>S ECTION 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>V EHICLE VIN #:</FONT></TD>
<TD WIDTH=453 ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff>1 FAFP34P61W16673 6</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>O DOMETER </FONT></TD>
<TD WIDTH=398 ><B><FONT SIZE=3 FACE="Arial"
COLOR=#0000ff>1 21,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>R EADING:</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=623 ><FONT SIZE=3 FACE="Arial" COLOR=#000000>S ECTION 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(E ven 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>S PECIAL NOTE FOR </FONT></B></I></TD>
<TD WIDTH=433 ><B><I><FONT SIZE=1 FACE="Arial" COLOR=#000000>S hould
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>d ata 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>C HARLES DAVIS:</FONT></B></I></TD>
<TD WIDTH=447 ><B><I><FONT SIZE=1 FACE="Arial" COLOR=#000000>d ata 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>s tating 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># 1FAFP34P61W1667 36 (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(strHTML FileText, "<<XYZCompany>> ",
Nz(MyRS("Compan yName"), ""))
strHTMLFileText = Replace(strHTML FileText, "<<FaxNum>> ",
Nz(MyRS("FaxNum ber"), ""))
....

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

tblReplacements

RID Token FieldName
1 <<XYZCompany>Co mpanyName
2 <<FaxNum>FaxNum ber
....

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********@Fort uneJames.com

Nov 21 '06 #6

Similar topics

2434

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 I'm at a complete loss as to what is wrong with the one below. This is a very abbreviated server-config.wsdd: <?xml version="1.0" encoding="UTF-8"?> <deployment xmlns="http://xml.apache.org/axis/wsdd/"...

.NET Framework

1782

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 into an object file but then at the final stage it says that it can't find template function. The platform is WindowsXP Pro, MSCV++ ..Net. More specifically what I want to do is write an atl algorithm that will also

C / C++

2125

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++

1872

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++

3145

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, 1> and A<int, 2> are different types. Now, if the A template

C / C++

2745

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' function that I would be able to declare in the base class (*). Thanks for suggestions, -Mathieu

C / C++

2376

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> class Ring {

C / C++

3270

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 F(FILE*) = non_closer> but compiler throws error:

C / C++

3811

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 (i.e. set of methods). But either: 1) For one (or a few) particular methods, the implementation will be specialised for many possible template parameters, or 2) For one particular template parameter, one (or a few) methods will have a...

C / C++

391

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++

8459

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8889

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8572

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8652

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6206

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4202

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2782

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2017

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1779

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General