Donnie said:
I am looking for the best possible way to create a
database and import it into Frontpage 2000.
1. Create the database in MS Access.
2. In FrontPage, create a folder that will contain the database.
fpdb is a common choice.
3. Drag the .mdb file out of Widnows Explorer and drag it into
the folder you created in step 2.
I would like to click on a button and show a list of all
properties for sale.
1. Choose Database from the Insert menu, and then choose Results.
2. Answer the wizard questions.
3. Save the page and browse from a Microsoft Web server, using an
http:// URL.
I also would like to click on another button and show a list of
properties for sale by a specific agent.
Same as above, but on page 3 of the wizard, click More Options and then
Crireria.
I will need to list detailed info along with pictures for each listing.
Pictures are tricky. You have to put the picture file name in the database,
and then use a custom query on page 2 of the wizard. This means you
need to understand some HTML and some Structured Query Language
(SQL). For example, the query might begin:
SELECT '<img src="images/' & [listing_photo] & '">' as imgtag, ...
Then, after the wizard completes, right-click the imgtag column in the
Database Results Region, choose Database Column Value Properties, and select
Column Value Contains HTML.
--
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
