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,

(e-mail address removed)
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top