Database Editor how to create a search or determine records shown?

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

Guest

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/Database1_interface/Vernon1/results_page.asp

Database editor -
http://www.designzontravel.co.nz/Database1_interface/Vernon1/editor/database_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
 
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" <[email protected]>
wrote in message
 
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
 
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" <[email protected]>
wrote in message
 
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
 
Back
Top