winzip icon

Publish recordset(s) 2 HTML using template(s)

Submitted on: 1/17/2015 10:29:00 AM
By: Edwin Vermeer. (from psc cd)  
Level: Advanced
User Rating: By 28 Users
Compatibility: VB 6.0
Views: 2264
     A new version is now available as part of a commercial product. See With this code it is very easy to publish database information as HTML. Customizing such a publication is very easy because of the use of templates. This is the second version of this code. All the votes for the previous version inspired me to make some big improvements. Thanks for the votes! :-) The screenshot below and the demo project will show you most of the possibilities of this code. New features are: . Converted the module to a class module. . Added 3 events for next record, next page and error. . It is now possible to include other templates. (subforms!) . . These templates can have their own recordset. (donít have to) . . A 'subform' can be bound to the mainform by linking a field from the main recordset to a field in the sub recordset. (donít have to) . . You can include multiple templates and these templates can also include multiple templates. So you can create a sub of a sub. . I added a couple of system parameters that can be used in the templates (record number, line number inside a group, even/odd line, greenbar) You can use this to give every other line a different colour. . You can put in Ďí as the page grouping and you will get one big HTML file with all the data. Features that already existed: . You can put all fields from the recordset anywhere in the template. (even within HTML tags) . You can create multiple (nested) grouping levels. Each level will have its own header, footer and detail section. . There are a lot of system parameters and it is easy to add you own. Almost all App properties can be used. This code can be useful: . When you are not able to access your database dynamically from your web server. You can use this to publish database information. . When you need an easy to use and customizable data reporting tool. . When the number of data updates is much lower than the web traffic you have. In this case static WebPages will probably give a much smaller server load. . If you created your own web server in VB. You can use this to give it functionality to access a database . When ...?

winzip iconDownload code

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come out every day, so no prevention program can catch 100% of them. For your own safety, please:
  1. Re-scan downloaded files using your personal virus checker before using it.
  2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
  3. Scan the source code with Minnow's Project Scanner

If you don't have a virus scanner, you can get one at many places on the net

Other 10 submission(s) by this author


Report Bad Submission
Use this form to tell us if this entry should be deleted (i.e contains no code, is a virus, etc.).
This submission should be removed because:

Your Vote

What do you think of this code (in the Advanced category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor (See voting log ...)

Other User Comments

11/14/2017 12:53:51 AMDavid

404 - File or directory not found.
(If this comment was disrespectful, please report it.)


Add Your Feedback
Your feedback will be posted below and an email sent to the author. Please remember that the author was kind enough to share this with you, so any criticisms must be stated politely, or they will be deleted. (For feedback not related to this particular code, please click here instead.)

To post feedback, first please login.