Wrox Programmer Forums
BOOK: Expert Access 2007 Programming ISBN 978-0-470-17402-9
This is the forum to discuss the Wrox book Expert Access 2007 Programming by Rob Cooper, Michael Tucker; ISBN: 9780470174029
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Expert Access 2007 Programming ISBN 978-0-470-17402-9 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 16th, 2008, 03:01 PM
Authorized User
Join Date: Aug 2006
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Default Question on Chapter 5

  I've got a question on the portion of chapter 5 that deals with exporting HTML with code. I'm not understanding how to run the code (or similar code) in order to get Figure 5-6. Is that code best run as a macro or how would you recommend. I admit my VB is poor at best, but that code is almost exactly what I need to do.

Thanks for any help.


Old September 2nd, 2008, 04:07 PM
Wrox Author
Join Date: May 2007
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts

Hi Arholly,

Thanks for your question and for your interest in the book! I apologize for the delayed response.

To call this function, you would call the routine named "CreatePageFromTemplate" that appears before Figure 5-6. The arguments to this routine are:

templateId - This is the ID of a template that is saved in the HtmlTemplates table created at the beginning of the section titled "Creating HTML Files"

fileName - Name of a file to write the results to

You can call this from the Immediate Window, an Access form, or another routine in a standalone module.

For example:
CreatePageFromTemplate 1, "<OutputFile.htm>"

Hope this helps,

Rob Cooper
Lead Software Design Engineer in Test
Microsoft Access Team

co-author: Access 2007 VBA Programmer's Reference
co-author: Expert Access 2007 Programming

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at microsoft.com/info/cpyright.htm.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 4 question davidle1234 BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 2 January 18th, 2007 12:18 AM
Chapter 16 Question SomeDude BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 4 October 24th, 2005 06:13 PM
Another chapter 10 question. czambran BOOK: Beginning CSS: Cascading Style Sheets for Web Design ISBN: 978-0-7645-7642-3 4 April 3rd, 2005 09:12 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.