Frontpage and Database Results wizard

[Tyler Albright]

I have an access database that I have at work with the
personnel information in it (phone no., room, etc..) It
is working except I cannot get the hyperlink for the email
address field to work. I get the email field to link, but
it does not bring up the email editor. It is looking for
a web page link (http://) not a mailto:. Do I make the
link in the Access Database or is their a way to do this
in Frontpage?
Tyler Albright
(e-mail address removed)

 

[Jim Buyens]

Although you don't say so, I presume you're using the
Database Results Wizard to query the database. If so, on
page 2 of the wizard, you need to click Custom Query and
then Edit. Then, modify the SQL statement from
SELECT * FROM youremployees...
to
SELECT 'http://mailto:' & as emailurl,
FROM youremployees...

and then report the calculated emailurl field rather than
the native email field.

Then, in the finished Database Results Region, right-click
<<emailurl>>, select 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)
|/---------------------------------------------------
*----------------------------------------------------