Thanks Ron and Kathleen
You have both helped me, yes Kathleen saw your method for 2003 and have
changed number of records plus added search, however we are using Frontpage
2002 so had to have a bit of luck and experimentation, here is how I did it
Putting a search form on Database Editor in FrontPage 2002
1. Open the Web site in FrontPage 2002.
2. After you create the database interface pages, double-click the
database1_Interface folder under Folder List, double-click the Results
folder, double-click the editor folder, and then double-click the List.asp
file.
Note "database1" is the name of the Web site database.
3. Click File, and then click Save As.
4. Type a file name to back up the List.asp file in a location of your
choice.
5. Open the List.asp file again.
6. Go to html view - Select the <table> and </table> tags that display the
results. Then, drag the table outside the <form> and </form> tags.
7. Go to normal view
8. Copy the hyperlink on from the Database Results Table to a part of the
page under/outside the table
9. Right click the Database Results region and click on Database Results
Properties to activate the Database Results Wizard
10. Step 1 - Select Database then click Next
11. Step 2 - Select Record Sourse then click Next
12. Step 3 - Click More options - set up Crieria, Ordering, Defaults & Limit
to Recoerds Returned - all to suit your needs - click Next
13. Step 4 - set up table to suit your needs - click Next
14. Step 5 - Set up how you want your records to displayed, make sure Add
Search Form is checked - click Finish
15. Go to Html view
16. Drag & drop the table you moved earlier to back inside the two form tags
17. Go to normal view
18. Cut & paste the hyperlink you copied earlier back into its original
location
19. Save
"Ronx" wrote:
> You are not doing anything wrong - I had not tried this myself.
>
> In Code view find grey code that starts:
>
> <!--webbot bot="DatabaseRegionStart" s-columnnames=
>
> In this code will be i-GroupSize="5"
>
> Change the number to a whatever seems appropriate for your pages.
> This does work correctly - I changed from 5 to 50.
> --
> Ron Symonds - Microsoft MVP (FrontPage)
> Reply only to group - emails will be deleted unread.
>
> http://www.rxs-enterprises.org/fp
>
>
>
>
> "Russell New zealand" <(E-Mail Removed)>
> wrote in message
> news:505A2F84-0B41-4B1B-BDA5-(E-Mail Removed):
>
> > Thank you Ronx
> >
> > Tried this but must be doing it in the wrong place or something, had tried
> > it before but got the pop up message "Do you want FrontPage to regenerate the
> > results region?" When we say yes we imediately lose functionality and there
> > is no longer a hyperlink to fetch the records for editing.
> >
> > To Reiterate it is the top selection frame where we want more than 5
> > records, there seems to be no problem in adding more records at the bootom
> > but also no point as you can only select one record to edit at a time anyway
> >
> > Cheers Russell
> >
> > "Ronx" wrote:
> >
> > > To increase the number of records displayed:
> > > Right click on the Database Results Region and choose Database Results
> > > Properties.
> > > On about screen 5 of the properties dialogue you can choose whether to
> > > show all records, or to group the records and choose how many in a
> > > group. The default is the group with 5 records.
> > >
> > > You can limit the records returned for editing by specifying criteria on
> > > page 3 of the above properties. For example, if the database uses an
> > > autonumber field you could use that to specify a start point -
> > > autonumberfield more than 25
> > >
> > >
> > > In Kathleens response, "inline" means her comments are interspersed with
> > > paragraphs in your question.
> > > --
> > > Ron Symonds - Microsoft MVP (FrontPage)
> > > Reply only to group - emails will be deleted unread.
> > >
> > > http://www.rxs-enterprises.org/fp
> > >
> > >
> > >
> > >
> > > "Russell New zealand" <(E-Mail Removed)>
> > > wrote in message
> > > news:13F6FE5C-116F-4276-98B0-(E-Mail Removed):
> > >
> > > > We have just set up a database with Access 2003 and have integrated it into
> > > > FrontPage 2002, have everything working in a basic fashion at
> > > >
> > > > Results Page -
> > > > http://www.designzontravel.co.nz/Dat...sults_page.asp
> > > >
> > > > Database editor -
> > > > http://www.designzontravel.co.nz/Dat...ase_editor.asp
> > > >
> > > > Problem is with the Database editor it only returns 5 records, is there a
> > > > way of searching for s specifis start point for records displayed and
> > > > increasing the number of records displayed, we have potentially hundreds
> > > >
> > > > Kathleen Anderson addressed this back in January 2006 but we don't
> > > > understand what she means by "inline"
> > > >
> > > > Have successfully used the wizard to create the desired results but when we
> > > > have tried using this to add a search function to the edit we lose the
> > > > funtionality of editing
> > > >
> > > > Any help would be most appreciated thank you
> > >
> > >
>
>
Similar Threads
