If you're running a Windows Web server, You can do this
with the Datbase Results Wizard.
1. Open a new blank page
2. Choose Database from the Insert menu, and then results.
3. On the first page of the wizard, specify the database
you want to query.
4. On the second page, specify the table you want to
query.
5. On the third page, click More Options, Criteria, Add,
and then specify:
Field Name: LastName (or whatever your field is named)
Comparison: Begins With
Value: (any legal form field name)
Use This Search Form Field: Checked.
And/Or: And
6. Click OK, OK, OK, Next, Next.
7. On the fifth and final page of the wizard, make sure
Add Search Form is checked.
8. Click Finish.
9. Save the page using a filename extension of .asp.
10. Browse the page using an http:// URL.
Jim Buyens
Microsoft FrontPage MVP
http://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)
|/---------------------------------------------------
*----------------------------------------------------
-----Original Message-----
I work at a radio station and have created an Access
database and related asp pages to input and retrieve
information about prize winners.
I want the person using the form to be able to search a
specific field for information. What I am trying to do is
search a field for a persons name to determine when the
last time they won a prize. This is to prevent someone
from winning more then once in a 30 day period.
Any thoughts on how this can be accomplished using
FrontPage or any other scripting?
