PC Review


Reply
Thread Tools Rate Thread

Data Entry Web Page

 
 
=?Utf-8?B?ams=?=
Guest
Posts: n/a
 
      5th Dec 2005
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
 
Reply With Quote
 
 
 
 
=?Utf-8?B?SmltIEJ1eWVucw==?=
Guest
Posts: n/a
 
      5th Dec 2005
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


"jk" wrote:

> 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

 
Reply With Quote
 
=?Utf-8?B?ams=?=
Guest
Posts: n/a
 
      5th Dec 2005
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

"Jim Buyens" wrote:

> 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
>
>
> "jk" wrote:
>
> > 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

 
Reply With Quote
 
=?Utf-8?B?SmltIEJ1eWVucw==?=
Guest
Posts: n/a
 
      5th Dec 2005
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



"jk" wrote:

> 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
>
> "Jim Buyens" wrote:
>
> > 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
> >
> >
> > "jk" wrote:
> >
> > > 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

 
Reply With Quote
 
=?Utf-8?B?ams=?=
Guest
Posts: n/a
 
      6th Dec 2005
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

"Jim Buyens" wrote:

> 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
>
>
>
> "jk" wrote:
>
> > 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
> >
> > "Jim Buyens" wrote:
> >
> > > 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
> > >
> > >
> > > "jk" wrote:
> > >
> > > > 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

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      6th Dec 2005
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.
==============================================

"jk" <(E-Mail Removed)> wrote in message
news:14A6B767-F38B-4A86-BAC8-(E-Mail Removed)...
> 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
>
> "Jim Buyens" wrote:
>
>> 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
>>
>>
>>
>> "jk" wrote:
>>
>> > 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
>> >
>> > "Jim Buyens" wrote:
>> >
>> > > 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
>> > >
>> > >
>> > > "jk" wrote:
>> > >
>> > > > 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



 
Reply With Quote
 
Clark
Guest
Posts: n/a
 
      6th Dec 2005

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.

>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
>
>"Jim Buyens" wrote:
>
>> 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
>>
>>
>>
>> "jk" wrote:
>>
>> > 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
>> >
>> > "Jim Buyens" wrote:
>> >
>> > > 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
>> > >
>> > >
>> > > "jk" wrote:
>> > >
>> > > > 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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry dataentryoffshore@gmail.com Microsoft Excel Programming 0 4th Jun 2008 04:00 PM
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing admin.dataentryoutsourcing@gmail.com Microsoft Excel Misc 0 20th Mar 2008 12:45 PM
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing admin.dataentryoutsourcing@gmail.com Microsoft Access Form Coding 0 20th Mar 2008 12:44 PM
data entry attempt in any Excel page highlights cells, no entry =?Utf-8?B?TWlrZQ==?= Microsoft Excel Crashes 1 19th Feb 2006 01:51 PM
Data Access Page error in data entry =?Utf-8?B?SmFrZXI=?= Microsoft Access 6 18th Feb 2005 12:12 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:24 AM.