problem with dates in DB Results table

C

Cliff

I have an Access table that list meetings and their dates.
When I try to put a DB Results page in FrontPage that gets
the meetings for specified date criteria (e.g for dates
after a specified date, or between two dates, or dates
after the date set as the default value) the DB Results
page does not retrieve the meetings and instead just gives
me an error message something like "Database Error: Data-
type mismatch."

What am I doing wrong? If you know, please email me
directly.

Thanks,

[email protected]
 
M

MD WebsUnlimited.com

Hi Cliff,

It would help if we had the URL to the page.

The first thing to check is that the dates are between hash marks.
#02/03/1988#
 
C

Cliff

I found Microsoft Knowledgebase article 284843 which
describes how to modify the html code generated by the DB
Results wizard to change the ' to # surrounding the
parameter name, but when I go to save the changes I get an
error message that says,
"The contents of a FrontPage component have been modified.
These contents will be overwritten when you save this
page." and then the hash marks revert back to single
parentheses.

So, how do make these edits stick?

Cliff
 
Top