Delete from DRW?

[Stephen Green]

I have a page that allows for selecting a name from a drop-down. It then
displays records for that person.

I have been able to create a form that allows for editing of the resulting
records. I'd like to add an option to delete a selected record.

How would I go about this?

Thanks.

Stephen

 

[Thomas A. Rowe]

FP2002 and FP2003 allow you to create these pages in the Wizard. FP2000 doesn't have this function.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Stephen Green]

Thanks for the reply, Thomas.

I already have the page set up for editing. What I would like is to add a
way to delete the selected record instead of editing it.

Do I need a new Database Report? Can I just add a "Delete" button and place
some code beneath it?

Thanks again.

Stephen

 

[Thomas A. Rowe]

Because you are working the FP database component, I would suggest letting FP create the deletion
page as well.

If you were hand coding, you could do this, but would have to have 2 form submit buttons on the page
and then direct to 2 separate page or separate script function on a processing page.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Stephen Green]

Thomas!

Using 2002, I haven't been able to find a way using the Database Results
Wizard. Can you point me in the right direction?

Stephen

 

[Thomas A. Rowe]

Stephen,

See:
http://support.microsoft.com/default.aspx?scid=kb;en-us;256868

This should help you get started, disregard the fact that it is for SQL server, as it should work
with Access.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================