PC Review


Reply
Thread Tools Rate Thread

Database Results Filtering

 
 
=?Utf-8?B?TWljaw==?=
Guest
Posts: n/a
 
      4th Mar 2006
I am using an Access database, and use the FP2003 DBRW to report the results
onto an ASP page. Is it possible to then delete one or more records from the
list (or edit a record), and then relist the remaining records without the
deleted records? Thanks in advance.
 
Reply With Quote
 
 
 
 
Stefan B Rusynko
Guest
Posts: n/a
 
      4th Mar 2006
See http://home.att.net/~codelibrary/FrontPage/drw.htm

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
_____________________________________________


"Mick" <(E-Mail Removed)> wrote in message news:E46F60C9-0E73-4B9B-A1D5-(E-Mail Removed)...
|I am using an Access database, and use the FP2003 DBRW to report the results
| onto an ASP page. Is it possible to then delete one or more records from the
| list (or edit a record), and then relist the remaining records without the
| deleted records? Thanks in advance.


 
Reply With Quote
 
=?Utf-8?B?TWljaw==?=
Guest
Posts: n/a
 
      5th Mar 2006
Hi Stefan, thanks for your response, I dont think I defined the problem well
enough. I dont want to change the database as I want to keep all the records
intact and unchanged. I am trying to delete some of the "reported" records.
e.g. 15 records match my criteria and are reported using the DBR feature in
FP. I want to intervene at this stage and trim them down to say 10 records on
the page by manually editing out the unwanted results, and then I want to
email the remaining results onwards.
Sorry my definition was not too clear, hope this is better. Thanks

"Stefan B Rusynko" wrote:

> See http://home.att.net/~codelibrary/FrontPage/drw.htm
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "Mick" <(E-Mail Removed)> wrote in message news:E46F60C9-0E73-4B9B-A1D5-(E-Mail Removed)...
> |I am using an Access database, and use the FP2003 DBRW to report the results
> | onto an ASP page. Is it possible to then delete one or more records from the
> | list (or edit a record), and then relist the remaining records without the
> | deleted records? Thanks in advance.
>
>
>

 
Reply With Quote
 
Stefan B Rusynko
Guest
Posts: n/a
 
      5th Mar 2006
The answer is still in the link I posted
- but you are pushing the DBRW beyond its limited capabilities

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
_____________________________________________


"Mick" <(E-Mail Removed)> wrote in message news:2EB9E5F9-83EE-4F64-B3AD-(E-Mail Removed)...
| Hi Stefan, thanks for your response, I dont think I defined the problem well
| enough. I dont want to change the database as I want to keep all the records
| intact and unchanged. I am trying to delete some of the "reported" records.
| e.g. 15 records match my criteria and are reported using the DBR feature in
| FP. I want to intervene at this stage and trim them down to say 10 records on
| the page by manually editing out the unwanted results, and then I want to
| email the remaining results onwards.
| Sorry my definition was not too clear, hope this is better. Thanks
|
| "Stefan B Rusynko" wrote:
|
| > See http://home.att.net/~codelibrary/FrontPage/drw.htm
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
| > _____________________________________________
| >
| >
| > "Mick" <(E-Mail Removed)> wrote in message news:E46F60C9-0E73-4B9B-A1D5-(E-Mail Removed)...
| > |I am using an Access database, and use the FP2003 DBRW to report the results
| > | onto an ASP page. Is it possible to then delete one or more records from the
| > | list (or edit a record), and then relist the remaining records without the
| > | deleted records? Thanks in advance.
| >
| >
| >


 
Reply With Quote
 
=?Utf-8?B?TWljaw==?=
Guest
Posts: n/a
 
      5th Mar 2006
That was quick!!! Thanks Stefan, Im not sure I have the skill to do this,
perhaps a "bridge too far" for both me and the DBRW. Thanks again

"Stefan B Rusynko" wrote:

> The answer is still in the link I posted
> - but you are pushing the DBRW beyond its limited capabilities
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "Mick" <(E-Mail Removed)> wrote in message news:2EB9E5F9-83EE-4F64-B3AD-(E-Mail Removed)...
> | Hi Stefan, thanks for your response, I dont think I defined the problem well
> | enough. I dont want to change the database as I want to keep all the records
> | intact and unchanged. I am trying to delete some of the "reported" records.
> | e.g. 15 records match my criteria and are reported using the DBR feature in
> | FP. I want to intervene at this stage and trim them down to say 10 records on
> | the page by manually editing out the unwanted results, and then I want to
> | email the remaining results onwards.
> | Sorry my definition was not too clear, hope this is better. Thanks
> |
> | "Stefan B Rusynko" wrote:
> |
> | > See http://home.att.net/~codelibrary/FrontPage/drw.htm
> | >
> | > --
> | >
> | > _____________________________________________
> | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> | > "Warning - Using the F1 Key will not break anything!" (-;
> | > To find the best Newsgroup for FrontPage support see:
> | > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> | > _____________________________________________
> | >
> | >
> | > "Mick" <(E-Mail Removed)> wrote in message news:E46F60C9-0E73-4B9B-A1D5-(E-Mail Removed)...
> | > |I am using an Access database, and use the FP2003 DBRW to report the results
> | > | onto an ASP page. Is it possible to then delete one or more records from the
> | > | list (or edit a record), and then relist the remaining records without the
> | > | deleted records? Thanks in advance.
> | >
> | >
> | >
>
>
>

 
Reply With Quote
 
Stefan B Rusynko
Guest
Posts: n/a
 
      5th Mar 2006
To get past the DBRW
Start here
http://www.w3schools.com/asp/default.asp
or
look at the samples here
http://www.asp101.com/samples/

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
_____________________________________________


"Mick" <(E-Mail Removed)> wrote in message news:F3E5A48E-F3FA-4016-9AAB-(E-Mail Removed)...
| That was quick!!! Thanks Stefan, Im not sure I have the skill to do this,
| perhaps a "bridge too far" for both me and the DBRW. Thanks again
|
| "Stefan B Rusynko" wrote:
|
| > The answer is still in the link I posted
| > - but you are pushing the DBRW beyond its limited capabilities
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
| > _____________________________________________
| >
| >
| > "Mick" <(E-Mail Removed)> wrote in message news:2EB9E5F9-83EE-4F64-B3AD-(E-Mail Removed)...
| > | Hi Stefan, thanks for your response, I dont think I defined the problem well
| > | enough. I dont want to change the database as I want to keep all the records
| > | intact and unchanged. I am trying to delete some of the "reported" records.
| > | e.g. 15 records match my criteria and are reported using the DBR feature in
| > | FP. I want to intervene at this stage and trim them down to say 10 records on
| > | the page by manually editing out the unwanted results, and then I want to
| > | email the remaining results onwards.
| > | Sorry my definition was not too clear, hope this is better. Thanks
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > See http://home.att.net/~codelibrary/FrontPage/drw.htm
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
| > | > _____________________________________________
| > | >
| > | >
| > | > "Mick" <(E-Mail Removed)> wrote in message news:E46F60C9-0E73-4B9B-A1D5-(E-Mail Removed)...
| > | > |I am using an Access database, and use the FP2003 DBRW to report the results
| > | > | onto an ASP page. Is it possible to then delete one or more records from the
| > | > | list (or edit a record), and then relist the remaining records without the
| > | > | deleted records? Thanks in advance.
| > | >
| > | >
| > | >
| >
| >
| >


 
Reply With Quote
 
=?Utf-8?B?TWljaw==?=
Guest
Posts: n/a
 
      5th Mar 2006
Thanks stefan, I'll have a go! cheers Mick

"Stefan B Rusynko" wrote:

> To get past the DBRW
> Start here
> http://www.w3schools.com/asp/default.asp
> or
> look at the samples here
> http://www.asp101.com/samples/
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "Mick" <(E-Mail Removed)> wrote in message news:F3E5A48E-F3FA-4016-9AAB-(E-Mail Removed)...
> | That was quick!!! Thanks Stefan, Im not sure I have the skill to do this,
> | perhaps a "bridge too far" for both me and the DBRW. Thanks again
> |
> | "Stefan B Rusynko" wrote:
> |
> | > The answer is still in the link I posted
> | > - but you are pushing the DBRW beyond its limited capabilities
> | >
> | > --
> | >
> | > _____________________________________________
> | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> | > "Warning - Using the F1 Key will not break anything!" (-;
> | > To find the best Newsgroup for FrontPage support see:
> | > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> | > _____________________________________________
> | >
> | >
> | > "Mick" <(E-Mail Removed)> wrote in message news:2EB9E5F9-83EE-4F64-B3AD-(E-Mail Removed)...
> | > | Hi Stefan, thanks for your response, I dont think I defined the problem well
> | > | enough. I dont want to change the database as I want to keep all the records
> | > | intact and unchanged. I am trying to delete some of the "reported" records.
> | > | e.g. 15 records match my criteria and are reported using the DBR feature in
> | > | FP. I want to intervene at this stage and trim them down to say 10 records on
> | > | the page by manually editing out the unwanted results, and then I want to
> | > | email the remaining results onwards.
> | > | Sorry my definition was not too clear, hope this is better. Thanks
> | > |
> | > | "Stefan B Rusynko" wrote:
> | > |
> | > | > See http://home.att.net/~codelibrary/FrontPage/drw.htm
> | > | >
> | > | > --
> | > | >
> | > | > _____________________________________________
> | > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> | > | > "Warning - Using the F1 Key will not break anything!" (-;
> | > | > To find the best Newsgroup for FrontPage support see:
> | > | > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> | > | > _____________________________________________
> | > | >
> | > | >
> | > | > "Mick" <(E-Mail Removed)> wrote in message news:E46F60C9-0E73-4B9B-A1D5-(E-Mail Removed)...
> | > | > |I am using an Access database, and use the FP2003 DBRW to report the results
> | > | > | onto an ASP page. Is it possible to then delete one or more records from the
> | > | > | list (or edit a record), and then relist the remaining records without the
> | > | > | deleted records? Thanks in advance.
> | > | >
> | > | >
> | > | >
> | >
> | >
> | >
>
>
>

 
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
Filtering Database Results =?Utf-8?B?TWljaw==?= Microsoft Frontpage 1 22nd Feb 2007 12:52 AM
Filtering database results =?Utf-8?B?TWljaw==?= Microsoft Frontpage 15 12th Jun 2006 04:38 PM
Filtering database results. =?Utf-8?B?TWljaw==?= Microsoft Frontpage 2 21st Nov 2005 12:20 PM
Database Results Dropdown Imbedded in Other Database Results form Nicholas Microsoft Frontpage 0 29th Jul 2004 07:17 PM
ASP Database Results and Search Form page displays results upon initial entry =?Utf-8?B?RGF0YWd1cnU=?= Microsoft Frontpage 3 27th Mar 2004 06:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:46 AM.