Data Entry Web Page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I already know how to create a DB and insert into FP using the results
wizard but that only lets a visitor view a database and not update. I would
like to know how to create a page so a visitor can enter information into a
DB located on a page.What are the steps involved....thanks
 
You might consider the Frontpage "Database Interface Wizard" but in general
that won't enforce the security restrictions you probably want. For example,
it allows the visitor to update any field in any record.

In fact, the rules as to who can update what, and when, are usually tricky
enough that you have to custom code "update" pages in ASP.NET or ASP.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
 
Hi,

The security part is not an issue since it is part of a project for school.I
created the results database on a ASP PAGE but that just shows my imported
Access DB with the records i entered.Will this wizard assist me in a page
which will let a user key in records from the web page?
Thanks
 
If it's only input that you need, right-click the HTML form, choose Form
Properties, and save the form results to your database.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
 
Hello,

Let me re-word this another way.......a visitor arrives at my web site,
clicks on the page which contains a database.I need for the user to be able
to enter data from that page so later the results of all entries can be
displayed.........Do i set up this page with form fields so it can accept the
entries or is there a wizard to create a page for this feature?

Thank you
 
You have to create a form for the user to complete and then submit to the database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Yes you set up the form yourself with the fields for data you want entered. You
get started by using insert / Form / and pick say a one line text field. This
creates the beginning of a form.

Right click on the field in the form and name it the name you want for the
record in your database (dont use any spaces)

Repeat for each field you want someone to enter data for. You may want to clean
up how your form looks by using some tables to organize the entries.

When you have the form ready, follow the comments above -- right click on the
form / properties /send to database/options/create database ---- the wizard will
wind up putting your database in the fpdb folder. That's a good thing.

Then on a different page do Insert / database results and follow the wiz down
the yellow brick road to create a page that shows the results in the database.
Again, use tables to organized it to look nice.

Frontpage was *made* to do the job you want.
 
Back
Top