-----Original Message-----
Is there a way to remove the yellow database results
region notification (i.e. the big ugly yellow messages)
from a webpage without messing up the results. The
yellow regions make it very difficult to format tables
with the data. I'm using FrontPage 2003.
No, FrontPage always puts them there.
Also, is there an easy way to format a database field as
currency.
No. There is, however, a difficult way. Create a custom
query that returns the data as a formatted string, and
then display the formatted string rather than the
original field value. For example, instead of
SELECT price, ...
code
SELECT Format([price],"$#,##0.00") As fmtprice, ...
or
SELECT FormatCurrency([price]) As fmtprice, ...
As to your subject line, displaying pictures that
physically reside in an Access database is difficult.
Refer to MSKB article 175261, HOWTO: Retrieve Bitmap from
Access and Display It in Web Page.
The better alternative to to store only the picture file
name in the database, and use that to construct an <img>
tag.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
