vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

 

Home  Contact Us
Order our Software

RSS & Newsletter  
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

  Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench  Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile,  shutdown database Read and Download

The Toolshed 
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More



The Toolbox

Libraries of software that we regularly import into our projects. This is a newer version of the Toolshed More..


Access >>> SQL 
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More

SharePoint
For our company file sharing and task management, we use
SharePointHosting

DryToast 
Backup and query your BaseCamp
® projects
Read More


Datamining/Graphs

Explore your data with this versatile graphing and data mining shareware tool.  Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

Like FMS Products?
Purchase them from us and get a free Workbench or Toolbox  More

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...

Search ...

or try our new site built with SharePoint Designer
 vb123.com.au
 

 

Next Tip   Exercise:  Building Your Own Static Page Generator

You will only really start to understand the technology if you start building your own application.   So what we will do is automatically build a html form that will link all the pages together.   To do this you will need to
bulletDevise a suitable HTML Skeleton that will display links to each of the html pages
bulletIncorporate that HTML into your Access VB code
bulletUse the examples from the MakeHTML subroutine explained on the previous page
bulletDebug your application until you have a suitable output page with links
bulletPost the new pages to the internet

More HTML That You Will Need To Know

<BODY   BGColour = "Green">    
Change the colour of the pages background.  This is one the Tag extensions that do not have an ending as this is covered by <
/BODY>

<B>Make Text Bold</B>   <I>Make Text Italic</I>  
Enclose text inside the Bold and Italic tags to emphasize your text

<Font Size=12 Colour="Green">Make the text bigger and green</Font>
There are many different permutations in text tags.  The trick here is to get the design right before you start building your web pages.

Link Tags   The "A" Tag

A link tag does have a start and finish.  Assume that you want to link to our Web Site then the tag would start as follows

<A HREF="http://www.vb123.com/graf/">Data Mining Shareware</A>

HREF="http://www.vb123.com/graf/" gives the destination

Data Mining Shareware is the alternative text that will be displayed for you to hyperlink from.   We will be using the Link tags to point the main page to the generated pages.

But if all your pages are being stored in the same directory as the page being displayed, you do not need to store the path of the link in the references follows

<A HREF="graf-fx.htm">Data Mining Shareware</A>

This is called a Relative Link.   If the graf-fx.htm file was in a sub directory called grafs, you would reference it as follows

<A HREF="grafs/graf-fx.htm">Data Mining Shareware</A>

So click on this

And start building your own link page using visual basic.

Next  Next Tip Lesson  Full Download Database In GR-FX Resource Kit   

 

Published  1999-05

 

Links >>>  Home | Search | Workbench | Orders | Newsletter | Access Security | Access professionals