Board index » Web Programming » Frontpage and Database Results wizard

Web Programming193
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

albrightts@ncaur.usda.gov


-

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:' & [email] 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

www.interlacken.com">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)

|/---------------------------------------------------

*----------------------------------------------------