Re: Dynamic Web Pages from Access

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jim Buyens (news_at_interlacken.com)
Date: 08/05/04 

Date: Wed, 4 Aug 2004 20:43:40 -0700

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 [MVP - FP]" wrote:
>
>> 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
<DavidCarpenter@discussions.microsoft.com> wrote:
>> > 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?
>>
>>
>.
>

Quantcast