When you run the DRW, click the More Options button on
page 3, then click the Criteria button and set criteria
on the Student ID and Password fields. If Student ID is
numeric, be sure to set a default, such as 0. Also, be
sure to check Use This Search Form Field.
Then, on page 5, select Add Search Form.
At this point, after saving the page and browsing it
using an http:// URL, entering the student ID and
password should query the database and display the
matching record. The form field will be on the Web page,
though, and not in a pop-up window.
The security of this scheme is, of course, entirely
dependent on keeping the student ID and Password values
secret, and on marking the folder that contains your
database as non-browsable.
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'll follow your links and see if this is it.
What I'm doing is: I'm a HS teacher. I wrote a grading application in
Access. I want students/families to be able to review a student's grades
on-line. When doing this with an Access report, the underlying query demands
a Student ID and a password before constructing the report and thereby
restricts viewing to only that student's grades.
,sknahT
Kathleen Anderson said:
David:
If I am understanding your question correctly, you want a page to come up
with just a search field box, and then, when the user fills in their
criteria, display a page with the results?
Create a standard DRW page with a search field, and then follow this
tutorial to separate the search page from the results page:
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.
asp#return
If I am not understanding your question correctly, could you post back and
word your question differently?
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
David Carpenter
I can build dynamic web pages populated by records from Access. What
I need to understand is how to orchestrate this where the underlying
query includes an immediate request for criteria (e.g. [Enter
<criteria1>]).
I am new to web development--used to how this works with Reports and
Forms in Access where dialogs pop up 'automagically' requesting this
input.
I've only built pages using the Database Results Wizard for single
forms. Hoped that the "Add Search Forms" part of the wizard might
provide this service but it doesn't seem to and sometimes is
greyed-out.
Advice?
.
