Jim
Sun Dec 07 12:20:14 CST 2003
>-----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)
|/---------------------------------------------------
*----------------------------------------------------